Question

ECON 483 Case Study Chapter 4 Bowie State University athletic department wants to develop its budget for the coming year, us attendance. Football attendance accounts for the largest portion of the University revenues. The new President of the university who is also a football fan has asked the athletic director to come up with strategies in promoting the university football team. The athletic director believes that attendance is directly related to the number of wins by the team. Instead of attempting to predict attendance based on only one variable (wins), the athletic department has included a second variable for advertising and promotional expenditures as well. The university president is anxious to know the result of this forecast to determine strategies that improve attendance and boost revenues for the University. The business manager of the BSU football team has accumulated total annual attendance figures for the past 8 years: ing a forecast for football Wins Promotion Attendanoe 4 $14500 21300 6 40700 25100 6 36300 26200 8 72000 38000 6 6000 29000 7 57000 30600 5 40300 24000 7 66600 32500 Given the number of returning starters and the strength of the schedule, the athletic director believes the team will win at least seven games next year. He wants to develop a multiple regression equation for these data to forecast attendance for this level of success. Discussion 1. Given that Attendance as the dependent variable and Wins questions and Promotion as independent variables, use excel to estimate the relationship between attendance and promotion and wins. Copy and paste results from excel output). Also write down the estimated equation. 2. What is the strength of this relationship? Use the coefficient
What do I need to do on Microsoft excel?

Answer 1

cient at alu 0.901133&15 hR squad valus dajines, the stdlationshtp ts shrong beca t is greater than O Ta pentantaga es anCl by wragrassion equation is 9o 113 3815 3 Using ANOVA Table Hoi 1 2. Tr-test-一statistics EE MSR4/MS Ras-11-7067 P- Valu 0.0030 The test statistic is signilicant andl oujecks HO at 0.05 ーsignificant-lovel'-Tharu IS-SuMcient evidence to suppork the clanm that sinipica utelattons hie-between .-Vania bles-