mba 522 15 12-2 in 5th edition

mba 522 15 12-2 in 5th edition - t Stat P-value Lower...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Problem 12-2 X Y X-Xbar Y-Ybar colD*colE Col. D^2 3 55 -8 20 -160 64 59 16 400 576 12 40 1 5 5 1 32 64 25 9 6 55 -5 20 -100 25 50 25 400 225 20 10 9 -25 -225 81 8 4 625 729 14 15 3 -20 -60 9 26 121 400 81 11 35 Xbar Ybar -540 180 230 1850 1620 <-- Summation row b1= -3 Yhat = 68 + (-3)X = 68 -3x SUMMARY OUTPUT b0 68 Regression Statistics r^2= 0.875676 is coeff. Of determination Multiple R 0.9357754408 is correlation coefficient r= 0.935775 is correl. Coefficient R Square 0.8756756757 is coefficient of determination r= -0.94 b/c the slope is negative. Adjusted R Square 0.8342342342 used with mutliple regression (chapter 13) Standard Error 8.7559503577 is standard deviation of regression line Observations 5 is sample size ANOVA df SS MS F ignificance F Regression 1 1620 1620 21.1304347826 0.019349 Residual 3 230 76.6666667 Total 4 1850 Coefficients Standard Erro
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 68 8.17743055 8.31557047 0.0036444696 41.97577 94.02423 41.97577 94.02423 X-3 0.65263001-4.5967853 0.0193489269-5.07696-0.92304-5.07696-0.92304 Predicted Y Yhat SSE (Y-Yhat)^2 SST (Y-Ybar)^2 SSR (Yhat - Ybar)^2 SSR(SumSquared due to regression). The bigger SSR, the higher the r^2. r^2 says what % of variablity in Y is explained by X SSE (Error is residual or difference between actual Y and estimated Y) SST This is bo This is slope or b1 When X increases 1, estimate of Y goes DOWN 3....
View Full Document

This note was uploaded on 11/13/2011 for the course MBA 522 taught by Professor Nabavi during the Spring '08 term at Bellevue.

Ask a homework question - tutors are online