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