### Create an Account

Home / Questions / Hello pjjain i have a couple of assignments for you to look at Thanks I also attached mod...

# Hello pjjain i have a couple of assignments for you to look at Thanks I also attached module 7 that you helped me with already Document Preview: Homework Assignment 9 Name

Hello pjjain, i have a couple of assignments for you to look at. Thanks! I also attached module 7 that you helped me with already

Document Preview:

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 2014 baseball season. The analyst collected several variables: Wins, ERA, Runs Scored, Hits and Saves from 27 professional baseball teams. The data is shows below. Regression Statistics Multiple R 0.9232 Observations 27 ANOVA df Regression Residual Total Variable Intercept ERA Runs Scored Hits Saves SS MS F ?? ?? ?? 469.348 ?? 746.297 ?? ?? ?? Significance F 0.000145539 Coefficien t 72.456 -10.234 Standard Error 14.417 3.3201 T value 5.02573 ?? P value 0.00002 0.0007 Lower 95% ?? -17.1194 Upper 95% ?? -3.348 0.0723 -0.0174 2.215 0.0086 0.01132 1.218 8.40698 ?? ?? 0.00123 0.0457 0.06234 0.05446 -0.04087 ?? 0.09013 0.00607 ?? 1) Fill in the tables with the missing values? (You should have 14 different values you need to find) 2) What is the coefficient of determination? 3) What is the adjusted r2? 4) What is the standard error of the estimated regression line? 5) What is the estimated regression equation? 6) Use the estimated regression equation to predict Wins when ERA 6.6, Runs Score is 925, Hits Allowed is 1523 and Saves are 33. 7) Calculate the residual for the observed described in number 6), if the original Wins for that observation were 109. 8) What is the hypothesis scenario? 9) Is there evidence of a significant relationship between the OVERALL Wins and the independent variables? Use alpha = .05. (State the p-value and the conclusion) 10) Which of the independent variables are significant predictors of Wins? Which ones do you want to include in your model? Use alpha = .05

Aug 05 2020 View more View Less