Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A company wants to study the relationship between an employee's length of employment and their number of workdays absent. The company wants to be able
A company wants to study the relationship between an employee's length of employment and their | ||||||
number of workdays absent. The company wants to be able to estimate the number of workdays absent | ||||||
based on the employee's length of employment. The company collected the following information on a | ||||||
random sample of seven employees. Somewhere in the spreadsheet: 1) Create a Scatter Chart to visually | ||||||
show the relationship between the variables. Then calculate the slope and y-intercept. Finally, use the slope and y-intercept | ||||||
in the simple linear regression equation to predict what the y value will be when x = 5, put you answer in cell B9. |
X | Predicted Value for X = 5 | |
5 | ||
Employee Selected for Sample | Length of Employment in Years (x) | Number of Workdays Absent (y) |
Employee 1 | 5 | 2 |
Employee 2 | 6 | 3 |
Employee 3 | 9 | 3 |
Employee 4 | 4 | 5 |
Employee 5 | 2 | 7 |
Employee 6 | 2 | 8 |
Employee 7 | 0 | 8 |
Please show steps in excel worksheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started