mba 522 16 12-5 in 5th edition

mba 522 16 12-5 in 5th edition - 1234 2909.8889 4.55555556...

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

View Full Document Right Arrow Icon
A B C D E F G H I J K X- Xbar Y - Ybar (X- Xbar)^2 4 1595 0.7222222 360.55556 260.40123 0.52160494 1695.76829 10154.24881 130000.3086 212819.6929536 4 1399 0.7222222 164.55556 118.84568 0.52160494 1695.76829 88071.41954 27078.53086 212819.6929536 4 1890 0.7222222 655.55556 473.45679 0.52160494 1695.76829 37725.95613 429753.0864 212819.6929536 3 795 -0.277778 -439.4444 122.0679 0.07716049 1057.0122 68650.39039 193111.4198 31482.20309964 2.5 600 -0.777778 -634.4444 493.45679 0.60493827 737.634146 18943.15824 402519.7531 246820.4723012 4 1995 0.7222222 760.55556 549.29012 0.52160494 1695.76829 89539.61466 578444.7531 212819.6929536 3 1205 -0.277778 -29.44444 8.1790123 0.07716049 1057.0122 21900.39039 866.9753086 31482.20309964 2 583 -1.277778 -651.4444 832.40123 1.63271605 418.256098 27140.55339 424379.8642 666163.4175884 3 1048 -0.277778 -186.4444 51.790123 0.07716049 1057.0122 81.21966092 34761.53086 31482.20309964 3.277778
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1234 2909.8889 4.55555556 362206.9512 2220916.222 1858709.271003 Totals Xbar Ybar b1 = 638.7561 which is summation of col F divided by summation of col G b0 = -859.256 which is: Y bar - b1*Xbar r^2 = 0.836911 which is SSR/SST SUMMARY OUTPUT Regression Statistics Multiple R 0.914828 R Square 0.836911 Adjusted R Sq0.813613 Standard Erro 227.4727 Observations 9 ANOVA df SS MS F ignificance F Regression 1 ### 1858709 35.921356 0.0005458 Residual 7 ### 51743.85 Total 8 ### Coefficientsndard E t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept-859.256 357.47 -2.403741 0.047206 -1704.529 -13.982902 -1704.52929 -13.98290214 638.7561 106.58 5.9934428 0.0005458 386.74432 890.767874 386.744321 890.7678742 capacity X price Y X - Xbar* Y - Ybar Y-hat predicted SSE (Y - Yhat)^2 SST (Y-Ybar)^2 SSR (Yhat - Ybar)^2 capacity X...
View Full Document

Ask a homework question - tutors are online