Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer 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 complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer 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.
College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter4: Polynomial And Rational Functions
Section4.6: Rational Functions
Problem 11SC: Find the mean hourly cost when the cell phone described above is used for 240 minutes.
Related questions
Question
Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary).
Answers that need formulas must have them within the answer 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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 12 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell