SUMMARY OUTPUT _________________________________________________ Regression Stat
ID: 3264353 • Letter: S
Question
SUMMARY OUTPUT _________________________________________________ Regression Statistics ____________________________________________ Multiple R 0.744152817 R Square a Adjusted R Square b Standard Error 16.50688387 Observations 50 __________________________________________________________________________________________ ANOVA _________________________________________________________________________________________ df SS MS F Significance F Regression c f g h 1.75489E-0 Residual d 12261.47468 i Total e 27477.52 _________________________________________________________________________________________ Coefficients StandardError t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -0.06890345 9.84254853 -0.00700057 0.99444534 -19.8928138 19.755006 -19.8928138 19.7550069 Age 1.72515290 0.26509485 6.50768148 5.4911E -08 1.19122445 2.2590813 1.1912244 2.259081362 Head -15.0857438 5.12089660 -2.94591846 0.00503999 -25.3997598 -4.7717286 -25.399759 -4.77172867 Manager -28.6724871 8.1166889 -3.53253490 0.00064386 -45.0203375 -12.324636 -45.0203375 12.32463635 Sales -17.4212921 6.2358485 -2.79373240 0.00762356 -29.980939 -4.8616484 -29.9809359 -4.861648466 __________________________________________________________________________________________________________ Question 1 a= ______ Round to 2 decimal places Question 2 c=______ Question 3 d=________ Question 4 e=_______ Question 5 f=_______ round to 2 decimal places Question 6 g=______ round to 2 decimal places Question 7 h=______ round to 2 decimal places Question 8 i=_______ round to 2 decimal places
Explanation / Answer
Answers to the questions:
a = Rsquare = .744152817^2 = .5537
b = 1- (1-R^2)(N-1)/(N-p-1) = 1- (1-.5537)(50)(50-4-1) = .50411 ( p is no. of variables)
c = p = 4
d = N-p-1 = 50-4-1 = 45
e = N-1 = 50-1=49
f = 27477-12261.475 = 15215.525 ( SSreg =SSt-SSres)
g = MSreg = SSreg/c = 27477/4 = 6869.25
i = MSres = SSres/d = 12261.474/45 = 272.47
h = g/i = 6869.25/272.47 = 25.21
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.