mba 522 17 12-11-C

mba 522 17 12-11-C - %arrive 0epart X Xbar X Y 24 22 3 20...

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

View Full Document Right Arrow Icon
X- Xbar Y-Ybar (X-Xbar)^2 Atlanta 24 22 3 1.6154 4.84615385 9 Charlotte 20 20 -1 -0.385 0.38461538 1 Chicago 30 29 9 8.6154 77.5384615 81 Cincinnati 20 19 -1 -1.385 1.38461538 1 Dallas 20 22 -1 1.6154 -1.6153846 1 Denver 23 23 2 2.6154 5.23076923 4 Detroit 18 19 -3 -1.385 4.15384615 9 Houston 20 16 -1 -4.385 4.38461538 1 Minneapolis 18 18 -3 -2.385 7.15384615 9 Phoenix 21 22 0 1.6154 0 0 Pittsburgh 25 22 4 1.6154 6.46153846 16 Salt Lake City 18 17 -3 -3.385 10.1538462 9 St. Louis 16 16 -5 -4.385 21.9230769 25 21 20.3846 0 2E-014 142 166 meanX meanY b1=slope: 0.8554 b0=intercept: 2.4208 Yhat=2.42 + 0.86X Yhat=2.42 + 0.86 (%arrive) Excel verifies the above. Using Excel's regression tool pak, we get the following. SUMMARY OUTPUT Regression Statistics Multiple R 0.8967 R Square 0.804 Adjusted R Square 0.7862 Standard Error 1.6406 Observations 13 ANOVA df SS MS F Significance F Regression 1 121.47 121.47 45.13 3.296E-005 Residual 11 29.607 2.6915 Total 12 151.077 Coefficien tandard Er t Stat P-value Lower 95% Upper 95%Lower 95.0%
Background image of page 1
This is the end of the preview. Sign up to access the rest of the 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