Question 196145: Im lost compeletly on this please help!
It might be expected that baseball teams with better batting averages also score more homerunes. Lets examine that thought! The regression table below, produce by excel shows the result analysis using major league baseball data from the 2007 season. The independent varaible (X)is team batting average and the dependent variable (y)is homeruns per game.
Regression Statistics
Multiple R 0.0427
R Square 0.0018
Adjusted R Square -0.0338
Standard Error 0.1903
Observations 30
ANOVA df SS MS F Significance F
Regression 1 0.0019 0.001852002 0.0511 0.8228
Residual 28 1.0145 0.036232252
Total 29 1.0164
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 0.8337 0.8227 1.0134 0.3196 -0.8515 2.5189
X 0.6936 3.0678 0.2261 0.8228 -5.5905 6.9777
a)Write the fitted regression equation
b)State the degrees of freedom for a two-tailed test for zero slope, and use the TINV function to find the critical value at α = .05.
c)Conclusion about slope
d)Interpret the 95% confidence limits for slope
e)Verify that F= square of t
f)Describe the fit of this regression
Answer by stanbon(75887)   (Show Source):
You can put this solution on YOUR website! It might be expected that baseball teams with better batting averages also score more homerunes. Lets examine that thought! The regression table below, produce by excel shows the result analysis using major league baseball data from the 2007 season. The independent varaible (X)is team batting average and the dependent variable (y)is homeruns per game.
Regression Statistics
Multiple R 0.0427
R Square 0.0018
Adjusted R Square -0.0338
Standard Error 0.1903
Observations 30
ANOVA df SS MS F Significance F
Regression 1 0.0019 0.001852002 0.0511 0.8228
Residual 28 1.0145 0.036232252
Total 29 1.0164
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 0.8337 0.8227 1.0134 0.3196 -0.8515 2.5189
X 0.6936 3.0678 0.2261 0.8228 -5.5905 6.9777
a)Write the fitted regression equation
Y = 0.6936X + 0.8337
----------------------------------------
b)State the degrees of freedom for a two-tailed test for zero slope, and use the TINV function to find the critical value at alpha = .05
df = 29
Critical value t = 2.045 and t = -2.045
--------------------------------------------------
c)Conclusion about slope
p-value is 0.82 so fail to reject Ho which said the slope ws zero;
there was no slope of any consequence detected by the test.
--------------------------------------------------
d)Interpret the 95% confidence limits for slope
With 95% confidence it says the slope is between -5.... and +6....
Comment: Your posting may be missing so "power-of-10" data
as the CI makes no sense.
----------------------------------------------------------
e)Verify that F= square of t
F is 0.0511 ; t^2 = 0.2261^2 = 0.0511
----------------------------------------------------------
f)Describe the fit of this regression
Since R^2 = 0.0018 the fit is certainly not linear.
==========================================================
Cheers,
Stan H.
|
|
|
