Patient Record Descriptive Excel Analysis
Budget: ₹600 – ₹1,500 INR
I have a spreadsheet containing Patient records that needs to be explored in Excel. The goal is to run clear, defensible descriptive statistics—mean, median, standard deviation, counts—focused on two key fields: Age and gender as well as Medical history details.
Here is what has to be handed back to me:
• A clean, well-structured workbook with all raw data preserved on one sheet and any transformations or helper columns clearly separated.
• Summary tables and pivot charts that show the central tendencies and distributions for the selected fields.
• A short commentary sheet (or built-in notes) explaining the findings so a non-statistician can read and understand the results.
Accuracy is paramount because these numbers will feed a larger clinical audit, so formulas must be transparent and reproducible. I work in recent versions of Microsoft Excel, so stick to native functions—no external add-ins or macros unless we discuss first.
If this scope is clear, feel free to let me know how quickly you can turn the workbook around and any clarifications you need before starting.
Here is what has to be handed back to me:
• A clean, well-structured workbook with all raw data preserved on one sheet and any transformations or helper columns clearly separated.
• Summary tables and pivot charts that show the central tendencies and distributions for the selected fields.
• A short commentary sheet (or built-in notes) explaining the findings so a non-statistician can read and understand the results.
Accuracy is paramount because these numbers will feed a larger clinical audit, so formulas must be transparent and reproducible. I work in recent versions of Microsoft Excel, so stick to native functions—no external add-ins or macros unless we discuss first.
If this scope is clear, feel free to let me know how quickly you can turn the workbook around and any clarifications you need before starting.