Patient Record Statistical Excel Analysis
Budget: $250 – $750 USD
I have a dataset of patient records that I need explored in Excel. The goal is to run a full statistical analysis, starting with descriptive statistics to summarise key variables, then moving into regression analysis to see how selected factors relate to a defined outcome.
The raw data are already in spreadsheet form but still require tidying—consistent formatting, removal of obvious entry errors, and clear labelling of variables—before any formulas or the Analysis ToolPak can be applied. Once cleaned, I’d like the workbook to include:
• a dedicated tab containing the descriptive outputs (means, medians, standard deviations, frequency tables, and any helpful charts),
• another tab with the regression model, complete with coefficients, p-values, R², residual plots, and brief on-sheet commentary explaining the practical interpretation,
• and a short, reader-friendly summary sheet that highlights the main take-aways in plain language.
If you prefer to automate repeat steps with Power Query, VBA, or recorded macros, that’s fine—as long as everything stays inside a single .xlsx file and remains transparent enough for me to trace the logic later. Accuracy, clear cell referencing, and tidy presentation are more important to me than elaborate visuals.
I’ll share the anonymised patient file as soon as we start, and I’m happy to answer clarifying questions about variable meanings or the outcome definition. When you return the finished workbook, I should be able to open it in Excel 365 and see every calculation running without errors or add-in issues.
The raw data are already in spreadsheet form but still require tidying—consistent formatting, removal of obvious entry errors, and clear labelling of variables—before any formulas or the Analysis ToolPak can be applied. Once cleaned, I’d like the workbook to include:
• a dedicated tab containing the descriptive outputs (means, medians, standard deviations, frequency tables, and any helpful charts),
• another tab with the regression model, complete with coefficients, p-values, R², residual plots, and brief on-sheet commentary explaining the practical interpretation,
• and a short, reader-friendly summary sheet that highlights the main take-aways in plain language.
If you prefer to automate repeat steps with Power Query, VBA, or recorded macros, that’s fine—as long as everything stays inside a single .xlsx file and remains transparent enough for me to trace the logic later. Accuracy, clear cell referencing, and tidy presentation are more important to me than elaborate visuals.
I’ll share the anonymised patient file as soon as we start, and I’m happy to answer clarifying questions about variable meanings or the outcome definition. When you return the finished workbook, I should be able to open it in Excel 365 and see every calculation running without errors or add-in issues.