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.

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

a. What is the regression equation?

b. Use the model to forecast sick days if someone got 85 hours of sleep.

c. Is the model statistically significant at the .05 level?

d. How much of the variability in sick days is determined by hours of sleep?

Show formulas and all work done in excel.