4. Part of an Excel output relating X (one independent Variable) and Y (dependen

Question

4. Part of an Excel output relating X (one independent Variable) and Y (dependent variable) is shown below. Fill in all the blanks marked with “?”

Summary Output_____

Regression Statistics

Multiple R                 0.1347

R Square                        ?

Adjusted R Square    XXXX    

Standard Error         3.3838

Observations                 ?

ANOVA_____________________________________________________________

_________________df_______SS__________MS________F________Significance F                           

Regression              ?           2.7500              ?                ?                    0.632

Residual                  ?             ?                 11.45              

Total                     14             ?    

                                  Coefficients           Standard Error         tStat      P-value

Intercept                         8.6                        2.2197                     ?         0.0019

x                                    0.25                       0.5101                     ?         0.632                           

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

Explanation / Answer

Regression Statistics Multiple R 0.1347 R Square 0.01814409 Adjusted R Square XXXX Standard Error 3.3838 Observations 15 ANOVA_____________________________________________________________ _________________df_______SS__________MS________F________Significance F Regression 1 2.7500 2.75 0.2402 0.632 Residual 13 148.85 11.45 Total 14 151.6 Coefficients Standard Error tStat P-value Intercept 8.6 2.2197 3.8744 0.0019 x 0.25 0.5101 0.4901 0.632 a. What has been the sample size for this problem? Sample size for this problem is 15.

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.