Analyzing the Impact of Various Variables on Baseball Team Wins Using Multiple Regression Analysis
Statistical study utilizing regression models to determine factors affecting baseball team performance
Anna Wilson
Contributor
4.4
46
30 days ago
Preview (2 of 5)
Sign in to access the full document!
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
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
Preview Mode
Sign in to access the full document!
100%
Study Now!
XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat
Document Details
Subject
Statistics