6 regression Modeling CHAPTER 6 421 Given the following data, use Excel to construct a least squares regression model that develops a relation between the number of games lost, the rainy days, and the team payroll of the Winterville The model should predict future lost games. 15. GAMES LOST RAINY DAYS PAYROLL ($000) 1993 1994 20 178 1995 10 240 1996 15 235 1997 17 180 1998 12 1999 22 2000 2001 267 2002 28 38 160 2003 34 147 a. What is the regression equation? What are expected games lost if Winterville experiences 15 rainy days and has a payroll of s200? What is the model's correlation coefficient and coefficient of determination? Interpret and discuss these values d. What are the model's R, E and t statistics? Comment on their outcomes. e. Run tests for multicollinearity, autocorrrelation, and heteroscedasticity. Comment on the outcomes.