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.6
40
5 months ago
Preview (2 of 5 Pages)
100%
Purchase to unlock
Page 1
Loading page ...
Analyzing the Impact of Various Variables on Baseball Team Wins UsingMultiple Regression AnalysisHomework Assignment #9Name: __________________________All calculations should be done in Word using Equation Editor and all charts and graphsshould be donein 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 baseballseason. 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 StatisticsMultiple R0.9504Observations30ANOVAdfSSMSFSignificance FRegression42611.92652.9858.3122.000000000259Residual25279.9511.198Total292891.87VariableCoefficientStandardErrorT valueP valueLower 95%Upper 95%Intercept74.777116.76264.4610.00002????ERA-12.32063.2066??.0007-18.9247-5.7166Runs Scored.08433.007910.6414.00000009.0680.1007Hits Allowed.0107.0163??.5176????Saves.2731.1203??.0321.0254.52081)Fill in the tables with the missing values?(You should have 13different values you need to find)Total Degree of freedom = n-1 = 29Residual Degree of freedom = Total Degree of freedom–Residual Degree of freedom = 29-4=25Residual SS = Total SS–Regression SS = 2891.87-2611.92 =279.95
Page 2
Preview Mode
This document has 5 pages. Sign in to access the full document!