Question: From the below data set, Please calculate the Slope and Y-intercept. Also, use the slope and Y-intercept in the simple regression to predict what the
From the below data set, Please calculate the Slope and Y-intercept.
Also, use the slope and Y-intercept in the simple regression to predict what the Y value will be when X=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 all steps in excel worksheet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
