Excel Patient Recovery Analysis
Budget: $30 – $250 USD
I have a dataset of medical records in Excel and need a clear, data-driven picture of how quickly patients recover. My focus is on patient recovery times, drilling down specifically into two metrics: the time to full recovery and the frequency of complications.
I’ll provide a clean spreadsheet containing anonymized patient IDs, treatment dates, follow-up notes, and outcome flags. I’m looking for an analyst who can:
• Structure the data so those two metrics are easy to isolate
• Run descriptive statistics and visualizations that highlight averages, medians, ranges, and any outliers
• Create pivot tables or a dashboard that lets me filter by treatment type, age group, or other variables already present in the sheet
• Summarize key findings in a short narrative so I can quickly relay them to the clinical team
Any advanced techniques—such as regression to correlate treatment variables with recovery speed—are welcome if you feel the data supports it. The final deliverables should be the updated Excel file with all formulas, charts, and pivot tables intact, plus a concise write-up (one page is enough).
If this sounds straightforward to you and you’re comfortable working in Excel (Power Query or VBA if helpful), I’m ready to share the file and timeline right away.
I’ll provide a clean spreadsheet containing anonymized patient IDs, treatment dates, follow-up notes, and outcome flags. I’m looking for an analyst who can:
• Structure the data so those two metrics are easy to isolate
• Run descriptive statistics and visualizations that highlight averages, medians, ranges, and any outliers
• Create pivot tables or a dashboard that lets me filter by treatment type, age group, or other variables already present in the sheet
• Summarize key findings in a short narrative so I can quickly relay them to the clinical team
Any advanced techniques—such as regression to correlate treatment variables with recovery speed—are welcome if you feel the data supports it. The final deliverables should be the updated Excel file with all formulas, charts, and pivot tables intact, plus a concise write-up (one page is enough).
If this sounds straightforward to you and you’re comfortable working in Excel (Power Query or VBA if helpful), I’m ready to share the file and timeline right away.
Related categories:
Excel
Statistics
Statistical Analysis
SPSS Statistics
Statistical Modeling
Regression Analysis