Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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