Question: Given the following data, use excel to construct a least squares regression model that develops a relation between the num days, and the team payroll

Given the following data, use excel to construct a least squares regression model that develops a relation between the num days, and the team payroll of the Winterville Indians basball team. The model should predict fute lost games Year Games LostRainy DaysPayroll ($000) 1993 25 26 175 1994 20 30 178 1995 10 3 240 1996 15 6 235 1997 22 17 180 1998 12 10 241 1999 25 22 173 2000 8 2 255 2001 4 2 267 2002 28 38 160 2003 29 34 147 A.) What is the gression Equation? B.) What are texpected games lost if Winterville experiences 15 rainy days and has a payroll of $200? C.) What is the model's correlation coefficient and coefficient of determination? Interpret and discuss these values. D.) What are the model's R, F, and t statistics? Comment on their outcomes. relation between the number of games lost, the rainy lost games cuss these values

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 General Management Questions!