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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!