12. The following table gives a football team's season-ticket sales, percentage of games won, and number of active alumni for the years 1998-2015. Season-Ticket Percentage of Number of Year Sales Games Won Active Alumni 1998 4.995 40 NA 1999 8,599 54 3,450 20010 8.479 5S 3.801 2001 8,419 58 4,000 2002 10,253 63 4,098 2013 12,457 75 6.315 2004 13,285 36 6,860 2005 14,177 27 8.423 2006 15,730 63 9.000 2007 15,805 70 9,500 15,575 72 9.530 2009 15,900 75 9.550 2010 14,010 80 9.560 201 1 12,500 82 9.575 2012 10,900 30 9.540 2013 9,998 25 9,580 2014 12,750 78 9.705 2015 14,050 78 10,000 a. Enter the data into an electronic file. b. Estimate a regression model for sales = Percentage of games won. c. Estimate a regression model for sales = Number of active alumni. d. Butimate a multiple regression model predicting sales using variables of your choice. c. If sales is the dependent variable, which of the two independent variables do you think explains sales better? Explain.5. Test the following hypothesis using the data summarized in the table below. Interpret your result: HI: Iwerner retailers offer lower prices for tables computers then do traditional in-store retailers. Retail Type Tablet Average Price Standard Deviation E-tailers $371.95 $50.00 25 Multi-Channel $360.30 $45.00 25 Retailers6. Selected territories in a company's eastern and western regions were rated for sales potential based on the company's evaluation system. A sales manager wishes to conduct a f-test of means to determine whether there is a difference between the two regions. Conduct this teyl, preferably using a statistical software package. Region Territory Rating WORD 74 West 88 Weyl 78 West 85 West 100 West 114 WORD East 63Hast 10) East EGGE Fast East L\f2. Perform a x- test on the following data (hint: set up a spreadsheet to perform the calculations as a good way of learning what the test really does): a. Managers and line employees differ in their response to: "Increased regulation is the best way to ensure safe products." Agree Disagree No Opinion Managers 58 66 8 Line Employees 34 24 10 Totals 92 90 18