Please submit one Excel file with answer cells that require formulas having the formulas within the cell. A manager is trying to educate employees on the effects of personal health and workplace performance. The manager has gathered data from a group of employees to evaluate the effects of sleep and sickness. The manager asked employees to record the total number of hours of sleep they had over 10 working days in two weeks and compared it to the number of sick days that each took over those 10 days. The manager wonders if a non-linear model is a better relationship between the variables. Sick Days Total hours of sleep 0 80 2 40 1 60 0 70 3 50 2 90 4 35 1 68 0 72 2 55 Is a linear or non-linear relationship better for hours of sleep predicting sick days and why? Use the most appropriate model to forecast sick days if someone got 85 hours of sleep. PLEASE USE AN EXCEL FILE TO DETERMINE THE ANSWER AND SHOW THE FORMULAS USED. PLEASE USE AN EXCEL FILE THANK YOU!
Please submit one Excel file with answer cells that require formulas having the formulas within the cell. A manager is trying to educate employees on the effects of personal health and workplace performance. The manager has gathered data from a group of employees to evaluate the effects of sleep and sickness. The manager asked employees to record the total number of hours of sleep they had over 10 working days in two weeks and compared it to the number of sick days that each took over those 10 days. The manager wonders if a non-linear model is a better relationship between the variables.
Sick Days |
Total hours of sleep |
0 |
80 |
2 |
40 |
1 |
60 |
0 |
70 |
3 |
50 |
2 |
90 |
4 |
35 |
1 |
68 |
0 |
72 |
2 |
55 |
- Is a linear or non-linear relationship better for hours of sleep predicting sick days and why?
- Use the most appropriate model to
forecast sick days if someone got 85 hours of sleep.
PLEASE USE AN EXCEL FILE TO DETERMINE THE ANSWER AND SHOW THE FORMULAS USED. PLEASE USE AN EXCEL FILE THANK YOU!
Step by step
Solved in 4 steps with 1 images