Practice Quiz 2 Problem 3 Solution

docx

School

Kennesaw State University *

*We aren’t endorsed by this school

Course

3300

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

2

Report

Uploaded by DukeMorningStingray14

1 Practice Quiz 2 Problem 3 Solution Problem 3 Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 110 Residual 8 74 Total 9 184 Coefficients Standard Error Intercept 39.222   5.943   x  -0.5556 0.1611 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 = 0.05. c. Perform an F test and determine whether or not X and Y are related. Let = 0.05. d. Compute the coefficient of determination. Answer: a through d Solution: Summary Output Regression Statistics Multiple R 0.7732 R Square 0.5978 Adjusted R Square 0.5476 Standard Error 3.0414 Observations 10 ANOVA df SS MS F Significance F Regression 1 110 110/1=110 =110/9.25=11.9 0.009=FDIST(11.9,1,8 ) Residual 8   74 74/8=9.25 Total 9 184 p-value =FDIST(F, numerator degrees of freedom df 1 , denominator degrees of freedom df 2 )
2 df 1 =k-1=2-1=1 df 2 =n T -k=10-2=8 Coefficients Standard Error t Stat P-value Intercept 39.222 5.942  6.600 0.000 x  -0.556 0.161 -3.448 0.009 ANOVA Source of Variation DF SS MS F Between Treatments df1=k-1 SSTR MSTR Within Treatments (Error) df2 =n-k SSE MSE Total n-1 F = MSTR MSE MSTR=SSTR/(k-1) MSE=SSE/n T -k Please, use equation: r 2 = SSR SST = 110/184=0.5978 Use ch.10 knowledge: n=10 (number of observations), p=2 (number of variables) MSR = SSR p
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help