Explore BrainMass

Explore BrainMass

    Write Regression Equation, State Degrees of Freedom, Compute

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    ? Write the regression equation
    ? State degrees of freedom and compute critical value
    ? Conclusion about slope
    ? Interpret confidence limits for slope
    ? Verify that F = square of t
    ? Describe fit of regression

    It might be expected that baseball teams with better batting averages also score more homeruns. Let's examine that thought. The regression table below, produced by Excel's Analysis ToolPak, shows the result of a regression analysis using Major League Baseball data from the 2007 season. The independent variable (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

    df SS MS F Significance F
    Regression 1 0.0019 0.002 0.0511 0.8228
    Residual 28 1.0145 0.036
    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

    © BrainMass Inc. brainmass.com June 3, 2020, 11:42 pm ad1c9bdddf

    Solution Summary

    A Complete, Neat and Step-by-step Solution is provided in the attached file.