Purchase Solution

Write Regression Equation, State Degrees of Freedom, Compute

Not what you're looking for?

Ask Custom Question

Instructions:
? 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

ANOVA
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

Purchase this Solution

Solution Summary

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

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.