Hi can you help me with this please (the data is in the excel file):

Given the following data, use Excel to construct a least squares regression model that develops relation between the number of games lost, the rainy days, and the team payroll of the Winterville Indians baseball team. The model should predict future lost games.

a) What is the regression equation?

b)What are expected 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.

S

Given the following data, use Excel to construct a least squares regression model that develops relation between the number of games lost, the rainy days, and the team payroll of the Winterville Indians baseball team. The model should predict future lost games. a) What is the regression equation? b)What are expected 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. Year games lost rainy days payroll ($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