Patient Records Excel Statistics
Budget: ₹600 – ₹1,500 INR
I have a set of patient records and need clear, no-frills descriptive statistics focused on their medical history. Using Microsoft Excel alone, please:
• Clean and organize the dataset (remove obvious entry errors and duplicates).
• Generate summary tables—counts, means, medians, ranges, and standard deviations—covering diagnoses, procedures, medications, or any other medical-history fields present.
• Create basic visuals (pivot tables or simple charts) that make the results easy to read at a glance.
No predictive or comparative work is required; I’m looking strictly for a concise snapshot of the data as it stands. Provide the finished workbook with formulas intact and a brief, one-page explanation of the findings so I can reference or share it quickly.
• Clean and organize the dataset (remove obvious entry errors and duplicates).
• Generate summary tables—counts, means, medians, ranges, and standard deviations—covering diagnoses, procedures, medications, or any other medical-history fields present.
• Create basic visuals (pivot tables or simple charts) that make the results easy to read at a glance.
No predictive or comparative work is required; I’m looking strictly for a concise snapshot of the data as it stands. Provide the finished workbook with formulas intact and a brief, one-page explanation of the findings so I can reference or share it quickly.