Excel Medical Data Summary
Budget: ₹12,500 – ₹37,500 INR
I’m working with an anonymized spreadsheet of patient records and need a tidy, reader-friendly snapshot of what the data is telling us—nothing predictive, strictly descriptive.
The task starts with basic data hygiene in Microsoft Excel: eliminate duplicates, correct obvious entry errors, and bring formats into a consistent structure so every column can be analyzed without surprises. Once the sheet is clean, I want concise summary statistics for each medical-history field you find—diagnoses, procedures, medications, or anything similar that appears. For every field, please return counts, means, medians, ranges, and standard deviations.
Clarity matters, so accompany those numbers with simple visuals created directly in Excel. Pivot tables and straightforward charts (bar or pie where it makes sense) should illustrate the highlights at a glance. I’ll need the finished workbook back with all formulas intact, no values hard-coded, so I can rerun or adjust the analysis later.
Finally, include a one-page explanation—plain language, bullet-point style is fine—summarizing the key takeaways and pointing me to the relevant tabs or visuals.
The task starts with basic data hygiene in Microsoft Excel: eliminate duplicates, correct obvious entry errors, and bring formats into a consistent structure so every column can be analyzed without surprises. Once the sheet is clean, I want concise summary statistics for each medical-history field you find—diagnoses, procedures, medications, or anything similar that appears. For every field, please return counts, means, medians, ranges, and standard deviations.
Clarity matters, so accompany those numbers with simple visuals created directly in Excel. Pivot tables and straightforward charts (bar or pie where it makes sense) should illustrate the highlights at a glance. I’ll need the finished workbook back with all formulas intact, no values hard-coded, so I can rerun or adjust the analysis later.
Finally, include a one-page explanation—plain language, bullet-point style is fine—summarizing the key takeaways and pointing me to the relevant tabs or visuals.