Only needing help with 2e and 2f

2. The ticketing office at a professional sports venue has noticed that ticket sales seem to fluctuate. The manager wants to introduce the strategy of demand- pricing in order to maximize attendance and revenue. Based on historical sales, manager wonders if there a connection between winning percentage (in decimal form) of the team and attendance (seats). Attendance (seats) Winning Percentage (decimal form) 78,000 0.6 89,000 0.67 93,000 0.7 59,000 0.5 65,000 0.55 97,000 0.9 0.6 86,000 77,000 0.55 91,000 0.8 61,000 0.53 a. C. a Run a regression analysis. What is the regression equation? (15 pts) b. is the model statistically significant at the 0.05 level? (10 pts) How much of the variability in attendance is determined by the winning percentage? (10 pts) d. What is the forecasted attendance if winning percentage is 0.72? (10 pts) e. Develop a regression equation by adding a non-linear variable for winning percentage (decimal form) to the original model and evaluate these additional variables. Opponent's winning Conference vs. Non- percentage (decimal form) conference 0.7 Non-Conference 0.5 Conference 0.4 Conference 0.9 Non-Conference 0.6 Non-Conference 0.5 Conference 0.6 Conference 0.7 Conference 0.8 Non-Conference 0.5 Non-Conference What is the regression equation only for those variables that are statistically significant? (35 pts) f. What is forecasted attendance if winning percentage is 0.72, opponent's winning percentage is 0.72 and it's a Conference game? (10 pts)