Analyzing the Impact of Various Variables on Baseball Team Wins Using Multiple Regression Analysis

Preview 2 of 5 pages

See the first 2 pages exactly as they appear in the document.

Page 1
Read page 1 as text
Analyzing the Impact of Various Variables on Baseball Team Wins Using Multiple Regression Analysis Homework Assignment #9 Name: __________________________ All calculations should be done in Word using Equation Editor and all charts and graphs should be done in Excel. Use the output below to answer the following questions. A baseball analyst would like to develop a model to predict the number of wins during the 2011 baseball season. The analyst collected several variables: Wins, ERA, Runs Scored, Hits Allowed, Walks Allowed, Errors and Saves from 30 professional baseball teams. The data is shows below. Regression Statistics Multiple R 0.9504 Observations 30 ANOVA df SS MS F Significance F Regression 4 2611.92 652.98 58.3122 .000000000259 Residual 25 279.95 11.198 Total 29 2891.87 Variable Coefficient Standard Error T value P value Lower 95% Upper 95% Intercept 74.7771 16.7626 4.4610 .00002 ?? ?? ERA - 12.3206 3.2066 ?? .0007 - 18.9247 - 5.7166 Runs Scored .08433 .0079 10.6414 .00000009 .0680 .1007 Hits Allowed .0107 .0163 ?? .5176 ?? ?? Saves .2731 .1203 ?? .0321 .0254 .5208 1) Fill in the tables with the missing values? (You should have 13 different values you need to find) Total Degree of freedom = n - 1 = 29 Residual Degree of freedom = Total Degree of freedom – Residual Degree of freedom = 29 - 4=25 Residual SS = Total SS – Regression SS = 2891.87 - 2611.92 = 279.95
Page 2

3 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.