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

a.What has been the sample size for the above?
b.Perform a t test and determine whether or not X and Y are related. Let $\alpha$ = 0.05.
c.Perform an F test and determine whether or not X and Y are related. Let $\alpha$ = 0.05.
d. Compute the coefficient of determination.e. Interpret the meaning of the value of the coefficient of determination that you found in d. Be very specific.

Question

Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable).
  
a.What has been the sample size for the above?
b.Perform a t test and determine whether or not X and Y are related. Let $\alpha$ = 0.05.
c.Perform an F test and determine whether or not X and Y are related. Let $\alpha$ = 0.05.
d. Compute the coefficient of determination.e. Interpret the meaning of the value of the coefficient of determination that you found in d. Be very specific.

Quizplus · Accepted Answer

The Answer of Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable).
  
a.What has been the sample size for the above?
b.Perform a t test and determine whether or not X and Y are related. Let $\alpha$ = 0.05.
c.Perform an F test and determine whether or not X and Y are related. Let $\alpha$ = 0.05.
d. Compute the coefficient of determination.e. Interpret the meaning of the value of the coefficient of determination that you found in d. Be very specific.

Shown Below Is a Portion of an Excel Output for Regression