Patient Demographics Excel Analysis
Budget: ₹600 – ₹1,500 INR
I need a clear, concise statistical review of a patient-demographic dataset currently stored in Excel. The goal is to run basic statistical analysis that highlights any obvious trends or notable patterns within the population.
Here’s what I’m looking for:
• Clean and organise the existing worksheet so duplicate or inconsistent entries are flagged.
• Produce descriptive statistics (counts, means, medians, standard deviations) on key demographic fields such as age, gender, and location.
• Build simple pivot tables and a few straightforward charts that make the insights easy to understand at a glance.
• Summarise your findings in a short, bullet-point report directly inside a new worksheet tab, referencing each chart or table.
A standard Excel toolset—formulas, pivot tables, and basic charting—should be all that’s required. No need for macros or external add-ins; keep everything contained in the workbook so I can review and reuse it later.
If you’re comfortable working with healthcare-related data and can turn this around quickly, I’d love to see your approach and estimated timeframe.
Here’s what I’m looking for:
• Clean and organise the existing worksheet so duplicate or inconsistent entries are flagged.
• Produce descriptive statistics (counts, means, medians, standard deviations) on key demographic fields such as age, gender, and location.
• Build simple pivot tables and a few straightforward charts that make the insights easy to understand at a glance.
• Summarise your findings in a short, bullet-point report directly inside a new worksheet tab, referencing each chart or table.
A standard Excel toolset—formulas, pivot tables, and basic charting—should be all that’s required. No need for macros or external add-ins; keep everything contained in the workbook so I can review and reuse it later.
If you’re comfortable working with healthcare-related data and can turn this around quickly, I’d love to see your approach and estimated timeframe.