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 regression 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. Problem assignments require that you show all of your work. Your input will be in an Excel spreadsheet. Only ONE Excel fil Use Excel to complete your the problems. Then use your work to fill out the answers in the Individual Assignment 3 Answers your Excel file using this drop box. If you fail to submit an Excel file with your work and/or you do not answer the questions o assignment. sheet. Only ONE Excel file will be opened and graded. Answer all questions asked! ual Assignment 3 Answers quiz below. Once you have completed the answers quiz, post not answer the questions on the associated answers quiz, you will receive a zero on the 3. Schalpfer Inc. is trying to determine whether to give a $15 rebate, to cut the price to $8, or to have no price change on a software networking product. Currently, 40,000 units of the product are sold each week for $45. The variable cost of the product is $6. The most likely case appears to be that a $15 rebate will increase sales 35% and about two-thirds of all people will claim the rebate. For the price cut, the most likely case is that sales will increase 25%. a. Given all other assumptions, use Excel to create a model that describes all the scenarios given. b. Holding all assumptions constant except the rebate claim rate, at what rebate claim rate would the rebate and price cut be equally desirable? c. Is the no price change scenario a good choice? When? 8. You are thinking of opening a copy shop. It costs $8000 to rent a copier for a year. It costs $0.023 per copy to operate the copier. Other fixed costs of running the store amount to $600 per month. You charge an average of $0.12 per copy. You are open 365 days per year. Each copier can make up to 150,000 copies per year. a. Using Excel, construct a two-way profit table (number of copiers on the left running top to bottom and daily demand on the top running from left to right) for 1 to 5 copiers rented and daily demands of 1000, 1500, 2000, and 2500 copies per day. That is, compute annual profit for each of these combinations of copiers rented and daily demand. b. Given that you rent three copiers, what daily demand for copies will allow you to break even? Draw a break-even graph to show this break-even relationship. The Graduate Assistant for the Santa Clara Broncos Football Team has complied the following Statistics: Year Wins 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Average OfAverage Interceptions 10 500 2 8 450 4 5 250 10 10 485 1 7 399 4 11 521 2 4 158 15 11 525 0 8 485 4 4 300 9 5 350 9 7 375 9 2 150 15 5 380 5 A.) Using Excel, Develop a linear regression model for wins, employing average ofensive yards and average interceptions. B.) Calculate the MAD for your model. C.)Calculate R, F and t statistics and interpret them. D.) Run Tests for multicollinearity, autocorrelation, heteroscedasticity. Comment on the Outcomes d average interceptions