| EGH222 Healthcare Analytics |
1. Assessing how lifestyle could affect sick days.
1.1.
A company HR department launched a project to study how the number of reported sick days in a year is affected by the employees’ demographics and lifestyle and to build a model to predict annual sick days of current and potential employees. A survey was carried out on the demographics and lifestyles for a sample of 10 employees, and the survey results were recorded in an Excel workbook, ASSN2data.xlsx.
1.2.
The data collected consist of:
- Number of sick days recorded in a year
- Age of employee, recorded in years
- Weight of employee, recorded in kilogrammes (kg)
- Height of employee, recorded in metres (m)
- Number of hours of sleep per day (for 7 consecutive days)
- Number of hours of exercises per day (for 7 consecutive days)
- Number of calories consumed per day (for 7 consecutive days)
- Number of alcoholic drinks over 7 days
- Number of cigarettes smoked over 7 days
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Native Singapore Writers Team
- 100% Plagiarism-Free Essay
- Highest Satisfaction Rate
- Free Revision
- On-Time Delivery
1.3.
Based on the data in the Excel workbook, build a model to predict number of sick days reported based on the employees’ demographics and lifestyle. Describe how each type of demographic data and lifestyle data affect the number of sick days reported. You may want to use correlational study and multiple linear regression to do your analysis and build the predictive model.
1.4.
Based on your analysis, propose a regression model to use selected demographics and lifestyle habits to predict sick days taken per year by an employee.
1.5.
Submit your report as a Word file, together with your Excel workbook containing your analysis. Your submission filenames must contain your admin no.
For additional resources to understand multiple linear regression in Excel, see
Multiple Regression in Excel – P-Value; R-Square; Beta Weight; ANOVA table:
Part 1: https://youtu.be/262aROsetdg
Part 2: https://youtu.be/cmvCQlohPdE
Part 3: https://youtu.be/GVvNacNXZt0
Healthcare Analytics Page 2 of 2 Effective Date: 21 Apr 2025
Official (Open)
Assignment rubrics:
| Description | Marks |
|---|---|
| Preparation and selection of data used for the eventual analysis. | 20 |
| Use of Excel formulae and proper cell referencing. | 20 |
| Appropriate iteration of linear regression. | 20 |
| Interpretation of result of analytical tools and conclusion. | 20 |
| Logical and tidy presentation of workbook and report: Excel worksheets and data are appropriately labeled. Word report is logical and grammatically correct. | 20 |
| Total | 100 |