Patient Data Statistics in Excel
Budget: ₹600 – ₹1,500 INR
I have an anonymised spreadsheet containing patient records, and I need clear descriptive statistics drawn from the medical-history columns alone—diagnoses, chronic conditions, prior procedures, medication lists, and similar fields. No trend-line projections or comparative testing are required; I’m strictly after a snapshot view of the current population.
You’ll begin by tidying the file so each medical-history element is consistently coded and ready for calculation. From there, please create summary tables (frequencies, averages, medians where they make sense) and embed pivot-table or Power Query logic so I can refresh the results when new rows are added. Simple charts inside the workbook that spotlight the most common conditions or comorbidity counts will be helpful.
Deliverables
• Cleaned Excel workbook with separate “Data Raw”, “Data Clean”, and “Analysis” tabs
• Built-in tables, pivots, or formulas providing all descriptive metrics on medical-history fields
• One-page summary sheet or dashboard highlighting key takeaways
Accuracy, clarity, and respect for healthcare confidentiality are essential. If you’ve handled clinical datasets before, that’s exactly the experience I’m looking for.
You’ll begin by tidying the file so each medical-history element is consistently coded and ready for calculation. From there, please create summary tables (frequencies, averages, medians where they make sense) and embed pivot-table or Power Query logic so I can refresh the results when new rows are added. Simple charts inside the workbook that spotlight the most common conditions or comorbidity counts will be helpful.
Deliverables
• Cleaned Excel workbook with separate “Data Raw”, “Data Clean”, and “Analysis” tabs
• Built-in tables, pivots, or formulas providing all descriptive metrics on medical-history fields
• One-page summary sheet or dashboard highlighting key takeaways
Accuracy, clarity, and respect for healthcare confidentiality are essential. If you’ve handled clinical datasets before, that’s exactly the experience I’m looking for.