Medical Demographic Excel Statistics
Budget: ₹600 – ₹1,500 INR
I have a dataset containing patient-demographic variables and I need you to put it through a rigorous statistical workout in Excel. The goal is clear: produce sound, publication-ready statistics that summarise the population and verify a handful of hypotheses.
Here’s what I expect once you open the workbook:
• Descriptive statistics that quickly tell me how the cohort looks—means, medians, standard deviation, frequency tables and any other distribution measures that help paint a full picture.
• Inferential statistics to confirm or refute relationships or differences I’m interested in. Test selection will depend on variable types (t-tests, χ², ANOVA, regression, etc. as appropriate). Please justify each choice in a short comment sheet so reviewers can follow the logic.
• A compact “Results” tab where both descriptive summaries and key inferential outputs are laid out cleanly, accompanied by concise interpretations.
Keep everything formula-driven so future updates flow through automatically, avoid add-ins that might break on other machines, and name ranges clearly for transparency. If you need to transform or clean any column, include a brief note so I can audit your steps.
Once done, send back the updated workbook and a one-page PDF report that pulls the findings together—that will be my quick reference when discussing the study with colleagues.
Here’s what I expect once you open the workbook:
• Descriptive statistics that quickly tell me how the cohort looks—means, medians, standard deviation, frequency tables and any other distribution measures that help paint a full picture.
• Inferential statistics to confirm or refute relationships or differences I’m interested in. Test selection will depend on variable types (t-tests, χ², ANOVA, regression, etc. as appropriate). Please justify each choice in a short comment sheet so reviewers can follow the logic.
• A compact “Results” tab where both descriptive summaries and key inferential outputs are laid out cleanly, accompanied by concise interpretations.
Keep everything formula-driven so future updates flow through automatically, avoid add-ins that might break on other machines, and name ranges clearly for transparency. If you need to transform or clean any column, include a brief note so I can audit your steps.
Once done, send back the updated workbook and a one-page PDF report that pulls the findings together—that will be my quick reference when discussing the study with colleagues.