Explore BrainMass

Regression Analysis

6. Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable).


Source df SS
Regression 1 110
Residual 8 74
Total 9 184

Coefficients Standard Error t-stat
Intercept 39.222 5.943
x -0.5556 0.1611

a. What has been the sample size for the above problem?

b. Perform a t test and determine whether or not X and Y are related. Let alpha = 0.05.

c. Compute the coefficient of determination and interpret its meaning. Be very specific.

Show all steps so i can compare to my work.


Solution Summary

The solution provides step by step method for the calculation of testing of hypothesis of population slope. Formula for the calculation and Interpretations of the results are also included.