Excel Statistical Analysis: Patient Records
Budget: ₹600 – ₹1,500 INR
I have a dataset of patient records that I need examined in Excel. Your task is to run a concise statistical analysis that spotlights disease prevalence across the population.
Here’s what I need from you:
• Clean the raw spreadsheet so the variables relevant to prevalence are clearly labeled and free of duplicates or obvious entry errors.
• Produce summary statistics—counts, percentages, and basic measures of central tendency—that show how common each disease is within the sample.
• Create one simple visual (bar chart or pie chart) that presents those prevalence findings at a glance.
• Conclude with a brief write-up (a paragraph or two) that explains the key takeaway, all inside the workbook so everything lives in one file.
The dataset is small, so please keep the workflow light and entirely inside Excel—no external add-ins or advanced scripting needed. Accuracy and patient confidentiality are critical; handle the file securely and return only the finished workbook.
Here’s what I need from you:
• Clean the raw spreadsheet so the variables relevant to prevalence are clearly labeled and free of duplicates or obvious entry errors.
• Produce summary statistics—counts, percentages, and basic measures of central tendency—that show how common each disease is within the sample.
• Create one simple visual (bar chart or pie chart) that presents those prevalence findings at a glance.
• Conclude with a brief write-up (a paragraph or two) that explains the key takeaway, all inside the workbook so everything lives in one file.
The dataset is small, so please keep the workflow light and entirely inside Excel—no external add-ins or advanced scripting needed. Accuracy and patient confidentiality are critical; handle the file securely and return only the finished workbook.