do test only use techniqes found in files
roberto pulpo
RegressionQUAN4640oct15.xlsxcost of living
| Cost of Living Adjustments | ||||||||||||||||
| SUMMARY OUTPUT | ||||||||||||||||
| City | Comparative Salary | Groceries | Housing | Utilities | Transportation | Healthcare | ||||||||||
| Atlanta | $60,482.00 | 15% | 25% | -10% | 6% | 5% | Regression Statistics | |||||||||
| Austin | $57,530.00 | -8% | 13% | -1% | -1% | 6% | Multiple R | 0.6437661767 | ||||||||
| Boston | $85,904.00 | 16% | 141% | 43% | 11% | 33% | R Square | 0.4144348902 | ||||||||
| Charleston | $60,904.00 | 18% | 22% | 11% | -7% | 10% | Adjusted R Square | 0.3889755376 | ||||||||
| Charlotte | $58,012.00 | 11% | 5% | 2% | -2% | 6% | Standard Error | 15089.7921917621 | ||||||||
| Chicago | $70,000.00 | 23% | 73% | 1% | 18% | 2% | Observations | 25 | ||||||||
| Columbus | $54,578.00 | 1% | -1% | -5% | -6% | -1% | ||||||||||
| Dallas | $58,072.00 | 12% | -4% | -3% | 1% | 5% | ANOVA | |||||||||
| DC | $87,892.00 | 20% | 214% | -6% | 13% | -3% | df | SS | MS | F | Significance F | |||||
| Denver | $65,843.00 | 7% | 64% | -8% | 1% | 11% | Regression | 1 | 3706597875.25702 | 3706597875.25702 | 16.2782964961 | 0.0005161621 | ||||
| Detroit | $57,590.00 | -2% | 15% | 0% | 6% | -1% | Residual | 23 | 5237142052.98298 | 227701828.390564 | ||||||
| Indianapolis | $55,120.00 | 3% | 4% | -11% | -6% | 1% | Total | 24 | 8943739928.24 | |||||||
| Los Angeles | $83,795.00 | 16% | 168% | 10% | 29% | 13% | ||||||||||
| Lousiville | $55,602.00 | 1% | 2% | -13% | 5% | -8% | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||
| Minneapolis | $65,060.00 | 16% | 43% | -10% | 10% | 8% | Intercept | 60838.6813090909 | 3884.1062214087 | 15.6634957545 | 0 | 52803.7954144978 | 68873.567203684 | 52803.7954144978 | 68873.567203684 | |
| New Orleans | $57,530.00 | 10% | 24% | -17% | -5% | 1% | Healthcare | 129800.509090909 | 32171.5450494098 | 4.034637096 | 0.0005161621 | 63248.5975855083 | 196352.42059631 | 63248.5975855083 | 196352.42059631 | |
| New York | $136,024.00 | 37% | 479% | 26% | 30% | 19% | ||||||||||
| Philadelphia | $72,048.00 | 26% | 72% | 17% | 10% | 3% | ||||||||||
| Phoenix | $57,651.00 | 7% | 21% | -8% | 2% | 1% | ||||||||||
| Pittsburgh | $59,578.00 | 9% | 21% | -3% | 14% | -1% | ||||||||||
| Portland | $77,349.00 | 25% | 108% | -18% | 19% | 15% | ||||||||||
| San Diego | $86,446.00 | 18% | 187% | 18% | 27% | 15% | Healthcare | Comparative Salary | ||||||||
| San Francisco | $105,241.00 | 38% | 304% | 3% | 26% | 22% | 5% | $60,482.00 | ||||||||
| Seattle | $83,253.00 | 33% | 133% | 2% | 21% | 24% | 6% | $57,530.00 | ||||||||
| St. Louis | $56,084.00 | 14% | -9% | 13% | 1% | 4% | 33% | $85,904.00 | ||||||||
| 10% | $60,904.00 | |||||||||||||||
| Source: CNN Money Cost of Living Calculator, December 2015 | 6% | $58,012.00 | ||||||||||||||
| 2% | $70,000.00 | |||||||||||||||
| -1% | $54,578.00 | |||||||||||||||
| 5% | $58,072.00 | |||||||||||||||
| -3% | $87,892.00 | |||||||||||||||
| 11% | $65,843.00 | |||||||||||||||
| -1% | $57,590.00 | |||||||||||||||
| 1% | $55,120.00 | |||||||||||||||
| 13% | $83,795.00 | |||||||||||||||
| -8% | $55,602.00 | |||||||||||||||
| 8% | $65,060.00 | |||||||||||||||
| 1% | $57,530.00 | |||||||||||||||
| 19% | $136,024.00 | |||||||||||||||
| 3% | $72,048.00 | |||||||||||||||
| 1% | $57,651.00 | |||||||||||||||
| -1% | $59,578.00 | |||||||||||||||
| 15% | $77,349.00 | |||||||||||||||
| 15% | $86,446.00 | |||||||||||||||
| 22% | $105,241.00 | |||||||||||||||
| 24% | $83,253.00 | |||||||||||||||
| 4% | $56,084.00 |
Comparative Salary
0.05 0.06 0.33 0.1 0.06 0.02 -0.01 0.05 -0.03 0.11 -0.01 0.01 0.13 -0.08 0.08 0.01 0.19 0.03 0.01 -0.01 0.15 0.15 0.22 0.24 0.04 60482 57530 85904 60904 58012 70000 54578 58072 87892 65843 57590 55120 83795 55602 65060 57530 136024 72048 57651 59578 77349 86446 105241 83253 56084
Sheet1
| Cost of Living Adjustments | ||||||||||||||||
| SUMMARY OUTPUT | ||||||||||||||||
| City | Comparative Salary | Groceries | Housing | Utilities | Transportation | Healthcare | ||||||||||
| Atlanta | $60,482.00 | 15% | 25% | -10% | 6% | 5% | Regression Statistics | |||||||||
| Austin | $57,530.00 | -8% | 13% | -1% | -1% | 6% | Multiple R | 0.998025184 | ||||||||
| Boston | $85,904.00 | 16% | 141% | 43% | 11% | 33% | R Square | 0.9960542678 | ||||||||
| Charleston | $60,904.00 | 18% | 22% | 11% | -7% | 10% | Adjusted R Square | 0.9950159173 | ||||||||
| Charlotte | $58,012.00 | 11% | 5% | 2% | -2% | 6% | Standard Error | 1362.845366934 | ||||||||
| Chicago | $70,000.00 | 23% | 73% | 1% | 18% | 2% | Observations | 25 | ||||||||
| Columbus | $54,578.00 | 1% | -1% | -5% | -6% | -1% | ||||||||||
| Dallas | $58,072.00 | 12% | -4% | -3% | 1% | 5% | ANOVA | |||||||||
| DC | $87,892.00 | 20% | 214% | -6% | 13% | -3% | df | SS | MS | F | Significance F | |||||
| Denver | $65,843.00 | 7% | 64% | -8% | 1% | 11% | Regression | 5 | 8908450325.8507 | 1781690065.17014 | 959.2658728425 | 3.837650193985E-22 | ||||
| Detroit | $57,590.00 | -2% | 15% | 0% | 6% | -1% | Residual | 19 | 35289602.3892953 | 1857347.49417343 | ||||||
| Indianapolis | $55,120.00 | 3% | 4% | -11% | -6% | 1% | Total | 24 | 8943739928.24 | |||||||
| Los Angeles | $83,795.00 | 16% | 168% | 10% | 29% | 13% | ||||||||||
| Lousiville | $55,602.00 | 1% | 2% | -13% | 5% | -8% | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||
| Minneapolis | $65,060.00 | 16% | 43% | -10% | 10% | 8% | Intercept | 55278.317534797 | 468.4932700248 | 117.9917003543 | 1.08261510020617E-28 | 54297.7498513067 | 56258.8852182874 | 54297.7498513067 | 56258.8852182874 | |
| New Orleans | $57,530.00 | 10% | 24% | -17% | -5% | 1% | Groceries | 12020.5601780845 | 3897.0214513455 | 3.0845506827 | 0.006101555 | 3864.0005398731 | 20177.1198162959 | 3864.0005398731 | 20177.1198162959 | |
| New York | $136,024.00 | 37% | 479% | 26% | 30% | 19% | Housing | 14337.2828739575 | 447.2691918129 | 32.0551541139 | 5.2596298772508E-18 | 13401.1376966973 | 15273.4280512177 | 13401.1376966973 | 15273.4280512177 | |
| Philadelphia | $72,048.00 | 26% | 72% | 17% | 10% | 3% | Utilities | 6711.1804883449 | 2546.4601700435 | 2.6354939957 | 0.0163000501 | 1381.3780988512 | 12040.9828778386 | 1381.3780988512 | 12040.9828778386 | |
| Phoenix | $57,651.00 | 7% | 21% | -8% | 2% | 1% | Transportation | 5162.1708690189 | 4067.2572595337 | 1.2692019559 | 0.2196967649 | -3350.6964106519 | 13675.0381486897 | -3350.6964106519 | 13675.0381486897 | |
| Pittsburgh | $59,578.00 | 9% | 21% | -3% | 14% | -1% | Healthcare | 12307.6802822955 | 4295.8523096989 | 2.8650147619 | 0.00991102 | 3316.3580639101 | 21299.0025006808 | 3316.3580639101 | 21299.0025006808 | |
| Portland | $77,349.00 | 25% | 108% | -18% | 19% | 15% | ||||||||||
| San Diego | $86,446.00 | 18% | 187% | 18% | 27% | 15% | ||||||||||
| San Francisco | $105,241.00 | 38% | 304% | 3% | 26% | 22% | ||||||||||
| Seattle | $83,253.00 | 33% | 133% | 2% | 21% | 24% | ||||||||||
| St. Louis | $56,084.00 | 14% | -9% | 13% | 1% | 4% | ||||||||||
| City | Comparative Salary | Groceries | Housing | Utilities | Healthcare | |||||||||||
| Atlanta | $60,482.00 | 15% | 25% | -10% | 5% | SUMMARY OUTPUT | ||||||||||
| Austin | $57,530.00 | -8% | 13% | -1% | 6% | |||||||||||
| Boston | $85,904.00 | 16% | 141% | 43% | 33% | Regression Statistics | ||||||||||
| Charleston | $60,904.00 | 18% | 22% | 11% | 10% | Multiple R | 0.9978575738 | |||||||||
| Charlotte | $58,012.00 | 11% | 5% | 2% | 6% | R Square | 0.9957197375 | |||||||||
| Chicago | $70,000.00 | 23% | 73% | 1% | 2% | Adjusted R Square | 0.994863685 | |||||||||
| Columbus | $54,578.00 | 1% | -1% | -5% | -1% | Standard Error | 1383.5019776421 | |||||||||
| Dallas | $58,072.00 | 12% | -4% | -3% | 5% | Observations | 25 | |||||||||
| DC | $87,892.00 | 20% | 214% | -6% | -3% | |||||||||||
| Denver | $65,843.00 | 7% | 64% | -8% | 11% | ANOVA | ||||||||||
| Detroit | $57,590.00 | -2% | 15% | 0% | -1% | df | SS | MS | F | Significance F | ||||||
| Indianapolis | $55,120.00 | 3% | 4% | -11% | 1% | Regression | 4 | 8905458373.7972 | 2226364593.4493 | 1163.1526597366 | 2.26153600648683E-23 | |||||
| Los Angeles | $83,795.00 | 16% | 168% | 10% | 13% | Residual | 20 | 38281554.4427943 | 1914077.72213971 | |||||||
| Lousiville | $55,602.00 | 1% | 2% | -13% | -8% | Total | 24 | 8943739928.24 | ||||||||
| Minneapolis | $65,060.00 | 16% | 43% | -10% | 8% | |||||||||||
| New Orleans | $57,530.00 | 10% | 24% | -17% | 1% | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| New York | $136,024.00 | 37% | 479% | 26% | 19% | Intercept | 55269.5886595433 | 475.5429617954 | 116.2241755211 | 8.79499834046437E-30 | 54277.6234236335 | 56261.5538954532 | 54277.6234236335 | 56261.5538954532 | ||
| Philadelphia | $72,048.00 | 26% | 72% | 17% | 3% | Groceries | 13301.4789062152 | 3821.1225544678 | 3.4810395942 | 0.0023562874 | 5330.7569300722 | 21272.2008823581 | 5330.7569300722 | 21272.2008823581 | ||
| Phoenix | $57,651.00 | 7% | 21% | -8% | 1% | Housing | 14641.4026026387 | 383.3940515907 | 38.1889143608 | 3.63987453273878E-20 | 13841.6566251212 | 15441.1485801561 | 13841.6566251212 | 15441.1485801561 | ||
| Pittsburgh | $59,578.00 | 9% | 21% | -3% | -1% | Utilities | 6589.8572115533 | 2583.2348077527 | 2.5510097618 | 0.0190352653 | 1201.3238268762 | 11978.3905962304 | 1201.3238268762 | 11978.3905962304 | ||
| Portland | $77,349.00 | 25% | 108% | -18% | 15% | Healthcare | 12635.1718709531 | 4353.0906178809 | 2.9025749703 | 0.0088032699 | 3554.7839594175 | 21715.5597824886 | 3554.7839594175 | 21715.5597824886 | ||
| San Diego | $86,446.00 | 18% | 187% | 18% | 15% | |||||||||||
| San Francisco | $105,241.00 | 38% | 304% | 3% | 22% | |||||||||||
| Seattle | $83,253.00 | 33% | 133% | 2% | 24% | |||||||||||
| St. Louis | $56,084.00 | 14% | -9% | 13% | 4% |
comp salary = 55269.6 + 13301.5(groceries) +14641.4(housing) +6589.9(utilities) + 12635.2(healthcare)
housing
| Size m² | Bedrooms | Age | Distance to City km | Garage Spaces | Price $1000s | ||||||||||
| 120 | 3 | 10 | 5.4 | 2 | 310 | SUMMARY OUTPUT | |||||||||
| 85 | 2 | 15 | 8.1 | 1 | 210 | ||||||||||
| 150 | 4 | 5 | 3.2 | 2 | 420 | Regression Statistics | |||||||||
| 95 | 2 | 20 | 10.3 | 1 | 195 | Multiple R | 0.9980285741 | ||||||||
| 200 | 5 | 2 | 2.8 | 3 | 580 | R Square | 0.9960610348 | ||||||||
| 175 | 4 | 8 | 4 | 2 | 470 | Adjusted R Square | 0.9946542615 | ||||||||
| 110 | 3 | 12 | 6.7 | 2 | 290 | Standard Error | 9.3882892113 | ||||||||
| 90 | 2 | 18 | 9.5 | 1 | 205 | Observations | 20 | ||||||||
| 160 | 4 | 4 | 3.5 | 2 | 440 | ||||||||||
| 130 | 3 | 6 | 5 | 2 | 350 | ANOVA | |||||||||
| 105 | 3 | 14 | 7.2 | 1 | 270 | df | SS | MS | F | Significance F | |||||
| 180 | 5 | 3 | 2.5 | 3 | 520 | Regression | 5 | 312036.040359581 | 62407.2080719162 | 708.0465879013 | 2.60598673276221E-16 | ||||
| 140 | 4 | 9 | 4.5 | 2 | 390 | Residual | 14 | 1233.9596404193 | 88.1399743157 | ||||||
| 100 | 3 | 11 | 6 | 2 | 280 | Total | 19 | 313270 | |||||||
| 170 | 4 | 7 | 3.8 | 2 | 450 | ||||||||||
| 125 | 3 | 10 | 5.3 | 2 | 320 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||
| 85 | 2 | 19 | 10.1 | 1 | 190 | Intercept | -37.7062781754 | 36.7752941052 | -1.0253154759 | 0.3226050357 | -116.5814394165 | 41.1688830656 | -116.5814394165 | 41.1688830656 | |
| 155 | 4 | 6 | 3.9 | 2 | 430 | Size m² | 2.0943326323 | 0.2061005486 | 10.1617033373 | 0.0000000766 | 1.6522909194 | 2.5363743453 | 1.6522909194 | 2.5363743453 | |
| 95 | 2 | 16 | 8.7 | 1 | 220 | Bedrooms | 33.463634219 | 10.1230775622 | 3.3056779436 | 0.0052031694 | 11.7517922227 | 55.1754762152 | 11.7517922227 | 55.1754762152 | |
| 200 | 5 | 1 | 2.1 | 3 | 600 | Age | -5.8179946324 | 2.2733407357 | -2.5592268422 | 0.022707264 | -10.6938255795 | -0.9421636854 | -10.6938255795 | -0.9421636854 | |
| Distance to City km | 8.5974071323 | 5.2742991948 | 1.6300567743 | 0.1253742108 | -2.7148395688 | 19.9096538333 | -2.7148395688 | 19.9096538333 | |||||||
| Garage Spaces | 6.2825093877 | 8.7064423964 | 0.7215931722 | 0.4824230068 | -12.3909523631 | 24.9559711386 | -12.3909523631 | 24.9559711386 | |||||||
| Size m² | Bedrooms | Age | Distance to City km | Price $1000s | SUMMARY OUTPUT | ||||||||||
| 120 | 3 | 10 | 5.4 | 310 | |||||||||||
| 85 | 2 | 15 | 8.1 | 210 | Regression Statistics | ||||||||||
| 150 | 4 | 5 | 3.2 | 420 | Multiple R | 0.9979551765 | |||||||||
| 95 | 2 | 20 | 10.3 | 195 | R Square | 0.9959145343 | |||||||||
| 200 | 5 | 2 | 2.8 | 580 | Adjusted R Square | 0.9948250768 | |||||||||
| 175 | 4 | 8 | 4 | 470 | Standard Error | 9.2370768635 | |||||||||
| 110 | 3 | 12 | 6.7 | 290 | Observations | 20 | |||||||||
| 90 | 2 | 18 | 9.5 | 205 | |||||||||||
| 160 | 4 | 4 | 3.5 | 440 | ANOVA | ||||||||||
| 130 | 3 | 6 | 5 | 350 | df | SS | MS | F | Significance F | ||||||
| 105 | 3 | 14 | 7.2 | 270 | Regression | 4 | 311990.146165268 | 77997.5365413171 | 914.1380182409 | 1.02840053678901E-17 | |||||
| 180 | 5 | 3 | 2.5 | 520 | Residual | 15 | 1279.8538347318 | 85.3235889821 | |||||||
| 140 | 4 | 9 | 4.5 | 390 | Total | 19 | 313270 | ||||||||
| 100 | 3 | 11 | 6 | 280 | |||||||||||
| 170 | 4 | 7 | 3.8 | 450 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| 125 | 3 | 10 | 5.3 | 320 | Intercept | -31.6767088633 | 35.2365907344 | -0.8989720119 | 0.3828720088 | -106.7817241711 | 43.4283064446 | -106.7817241711 | 43.4283064446 | ||
| 85 | 2 | 19 | 10.1 | 190 | Size m² | 2.0765755119 | 0.2013303672 | 10.3142687335 | 0.0000000332 | 1.6474499921 | 2.5057010317 | 1.6474499921 | 2.5057010317 | ||
| 155 | 4 | 6 | 3.9 | 430 | Bedrooms | 36.3683675608 | 9.1386969711 | 3.9796009952 | 0.001208445 | 16.8896960546 | 55.8470390669 | 16.8896960546 | 55.8470390669 | ||
| 95 | 2 | 16 | 8.7 | 220 | Age | -6.4601305907 | 2.058238511 | -3.138669574 | 0.0067612174 | -10.8471621296 | -2.0730990517 | -10.8471621296 | -2.0730990517 | ||
| 200 | 5 | 1 | 2.1 | 600 | Distance to City km | 9.4012658053 | 5.0722763415 | 1.8534608867 | 0.0835889346 | -1.4100352977 | 20.2125669083 | -1.4100352977 | 20.2125669083 | ||
| Size m² | Bedrooms | Age | Price $1000s | SUMMARY OUTPUT | |||||||||||
| 120 | 3 | 10 | 310 | ||||||||||||
| 85 | 2 | 15 | 210 | Regression Statistics | |||||||||||
| 150 | 4 | 5 | 420 | Multiple R | 0.9974862787 | ||||||||||
| 95 | 2 | 20 | 195 | R Square | 0.9949788763 | ||||||||||
| 200 | 5 | 2 | 580 | Adjusted R Square | 0.9940374156 | ||||||||||
| 175 | 4 | 8 | 470 | Standard Error | 9.9151633639 | ||||||||||
| 110 | 3 | 12 | 290 | Observations | 20 | ||||||||||
| 90 | 2 | 18 | 205 | ||||||||||||
| 160 | 4 | 4 | 440 | ANOVA | |||||||||||
| 130 | 3 | 6 | 350 | df | SS | MS | F | Significance F | |||||||
| 105 | 3 | 14 | 270 | Regression | 3 | 311697.032567489 | 103899.01085583 | 1056.8458947938 | 1.34580943579312E-18 | ||||||
| 180 | 5 | 3 | 520 | Residual | 16 | 1572.9674325107 | 98.3104645319 | ||||||||
| 140 | 4 | 9 | 390 | Total | 19 | 313270 | |||||||||
| 100 | 3 | 11 | 280 | ||||||||||||
| 170 | 4 | 7 | 450 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||
| 125 | 3 | 10 | 320 | Intercept | 4.9760560467 | 31.3051917144 | 0.158953061 | 0.8756949501 | -61.3879857619 | 71.3400978552 | -61.3879857619 | 71.3400978552 | |||
| 85 | 2 | 19 | 190 | Size m² | 2.1412159537 | 0.2128427653 | 10.0600833253 | 0.0000000253 | 1.6900094477 | 2.5924224597 | 1.6900094477 | 2.5924224597 | |||
| 155 | 4 | 6 | 430 | Bedrooms | 28.9609855773 | 8.8218082011 | 3.2828854263 | 0.0046851839 | 10.2595876231 | 47.6623835315 | 10.2595876231 | 47.6623835315 | |||
| 95 | 2 | 16 | 220 | Age | -3.1477232194 | 1.09595594 | -2.8721256984 | 0.0110623395 | -5.4710460243 | -0.8244004146 | -5.4710460243 | -0.8244004146 | |||
| 200 | 5 | 1 | 600 | ||||||||||||
| Size m² | Bedrooms | Age | Price $1000s | ||||||||||||
| 100 | 5 | 13 | 322.9821774511 |
energy use
| ID | X1 (Hours Used/Day) | X2 (Machine Age in Years) | X3 (Motor Power kW) | X4 (Maintenance/Month) | X5 (Ambient Temp °C) | Y (Energy Use kWh) | SUMMARY OUTPUT | |||||||||
| 1 | 8 | 3 | 75 | 2 | 22.5 | 1820 | ||||||||||
| 2 | 5.5 | 8 | 60 | 1 | 25 | 1350 | Regression Statistics | |||||||||
| 3 | 9 | 2 | 90 | 3 | 21 | 2100 | Multiple R | 0.9971031791 | ||||||||
| 4 | 6 | 10 | 50 | 1 | 26.5 | 1250 | R Square | 0.9942147497 | ||||||||
| 5 | 10 | 1 | 100 | 4 | 20 | 2400 | Adjusted R Square | 0.9921485889 | ||||||||
| 6 | 7.5 | 4 | 80 | 2 | 23 | 1750 | Standard Error | 38.9333775293 | ||||||||
| 7 | 6.5 | 9 | 55 | 1 | 27 | 1280 | Observations | 20 | ||||||||
| 8 | 8.5 | 2 | 85 | 3 | 22 | 1950 | ||||||||||
| 9 | 5 | 7 | 45 | 1 | 28.5 | 1100 | ANOVA | |||||||||
| 10 | 9.5 | 3 | 95 | 4 | 21.5 | 2200 | df | SS | MS | F | Significance F | |||||
| 11 | 6 | 6 | 65 | 2 | 24 | 1450 | Regression | 5 | 3646953.68959831 | 729390.737919661 | 481.1894335262 | 0 | ||||
| 12 | 10 | 1 | 110 | 4 | 20 | 2500 | Residual | 14 | 21221.3104016929 | 1515.8078858352 | ||||||
| 13 | 7 | 5 | 70 | 2 | 23.5 | 1600 | Total | 19 | 3668175 | |||||||
| 14 | 8 | 4 | 85 | 3 | 22 | 1900 | ||||||||||
| 15 | 5.5 | 9 | 50 | 1 | 26 | 1200 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||
| 16 | 9 | 2 | 95 | 4 | 21 | 2150 | Intercept | 518.530690041 | 499.8345059858 | 1.0374047486 | 0.3171340686 | -553.5077045592 | 1590.5690846413 | -553.5077045592 | 1590.5690846413 | |
| 17 | 6.5 | 7 | 60 | 2 | 25.5 | 1400 | X1 (Hours Used/Day) | 99.6210667268 | 23.3326959296 | 4.269590922 | 0.0007780285 | 49.5774111037 | 149.6647223499 | 49.5774111037 | 149.6647223499 | |
| 18 | 10 | 1 | 105 | 4 | 19.5 | 2450 | X2 (Machine Age in Years) | -5.5539297022 | 9.1182022354 | -0.6091035885 | 0.5522124434 | -25.1105284743 | 14.0026690699 | -25.1105284743 | 14.0026690699 | |
| 19 | 7.5 | 5 | 75 | 2 | 23 | 1700 | X3 (Motor Power kW) | 10.5671326243 | 3.0851047542 | 3.4252103141 | 0.0041019583 | 3.9502410167 | 17.1840242319 | 3.9502410167 | 17.1840242319 | |
| 20 | 8.5 | 3 | 90 | 3 | 22 | 2000 | X4 (Maintenance/Month) | 19.210315921 | 27.8685313061 | 0.6893192795 | 0.5018881956 | -40.5617390361 | 78.9823708781 | -40.5617390361 | 78.9823708781 | |
| X5 (Ambient Temp °C) | -14.7058807601 | 15.1744397584 | -0.9691218255 | 0.3489300232 | -47.2518171505 | 17.8400556303 | -47.2518171505 | 17.8400556303 | ||||||||
| X1 (Hours Used/Day) | X3 (Motor Power kW) | X4 (Maintenance/Month) | X5 (Ambient Temp °C) | Y (Energy Use kWh) | SUMMARY OUTPUT | |||||||||||
| 8 | 75 | 2 | 22.5 | 1820 | ||||||||||||
| 5.5 | 60 | 1 | 25 | 1350 | Regression Statistics | |||||||||||
| 9 | 90 | 3 | 21 | 2100 | Multiple R | 0.9970262974 | ||||||||||
| 6 | 50 | 1 | 26.5 | 1250 | R Square | 0.9940614376 | ||||||||||
| 10 | 100 | 4 | 20 | 2400 | Adjusted R Square | 0.992477821 | ||||||||||
| 7.5 | 80 | 2 | 23 | 1750 | Standard Error | 38.1083420554 | ||||||||||
| 6.5 | 55 | 1 | 27 | 1280 | Observations | 20 | ||||||||||
| 8.5 | 85 | 3 | 22 | 1950 | ||||||||||||
| 5 | 45 | 1 | 28.5 | 1100 | ANOVA | |||||||||||
| 9.5 | 95 | 4 | 21.5 | 2200 | df | SS | MS | F | Significance F | |||||||
| 6 | 65 | 2 | 24 | 1450 | Regression | 4 | 3646391.31398686 | 911597.828496714 | 627.7159622664 | 1.69725537811259E-16 | ||||||
| 10 | 110 | 4 | 20 | 2500 | Residual | 15 | 21783.6860131444 | 1452.2457342096 | ||||||||
| 7 | 70 | 2 | 23.5 | 1600 | Total | 19 | 3668175 | |||||||||
| 8 | 85 | 3 | 22 | 1900 | ||||||||||||
| 5.5 | 50 | 1 | 26 | 1200 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||
| 9 | 95 | 4 | 21 | 2150 | Intercept | 503.261316301 | 488.626826539 | 1.029950238 | 0.3193556717 | -538.2221110739 | 1544.7447436759 | -538.2221110739 | 1544.7447436759 | |||
| 6.5 | 60 | 2 | 25.5 | 1400 | X1 (Hours Used/Day) | 100.1874787868 | 22.8201087518 | 4.3903155711 | 0.0005270329 | 51.547568358 | 148.8273892155 | 51.547568358 | 148.8273892155 | |||
| 10 | 105 | 4 | 19.5 | 2450 | X3 (Motor Power kW) | 10.925631769 | 2.9642660317 | 3.6857797688 | 0.0022023132 | 4.6074482828 | 17.2438152551 | 4.6074482828 | 17.2438152551 | |||
| 7.5 | 75 | 2 | 23 | 1700 | X4 (Maintenance/Month) | 21.2499614305 | 27.0803385817 | 0.7847007291 | 0.4448460203 | -36.4704139332 | 78.9703367941 | -36.4704139332 | 78.9703367941 | |||
| 8.5 | 90 | 3 | 22 | 2000 | X5 (Ambient Temp °C) | -16.7437440217 | 14.4873683078 | -1.1557477981 | 0.2658622523 | -47.6228386177 | 14.1353505742 | -47.6228386177 | 14.1353505742 | |||
| X1 (Hours Used/Day) | X3 (Motor Power kW) | X5 (Ambient Temp °C) | Y (Energy Use kWh) | SUMMARY OUTPUT | ||||||||||||
| 8 | 75 | 22.5 | 1820 | |||||||||||||
| 5.5 | 60 | 25 | 1350 | Regression Statistics | ||||||||||||
| 9 | 90 | 21 | 2100 | Multiple R | 0.9969040363 | |||||||||||
| 6 | 50 | 26.5 | 1250 | R Square | 0.9938176576 | |||||||||||
| 10 | 100 | 20 | 2400 | Adjusted R Square | 0.9926584684 | |||||||||||
| 7.5 | 80 | 23 | 1750 | Standard Error | 37.6479696709 | |||||||||||
| 6.5 | 55 | 27 | 1280 | Observations | 20 | |||||||||||
| 8.5 | 85 | 22 | 1950 | |||||||||||||
| 5 | 45 | 28.5 | 1100 | ANOVA | ||||||||||||
| 9.5 | 95 | 21.5 | 2200 | df | SS | MS | F | Significance F | ||||||||
| 6 | 65 | 24 | 1450 | Regression | 3 | 3645497.08607451 | 1215165.69535817 | 857.3386066111 | 7.10518449021577E-18 | |||||||
| 10 | 110 | 20 | 2500 | Residual | 16 | 22677.9139254944 | 1417.3696203434 | |||||||||
| 7 | 70 | 23.5 | 1600 | Total | 19 | 3668175 | ||||||||||
| 8 | 85 | 22 | 1900 | |||||||||||||
| 5.5 | 50 | 26 | 1200 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||||
| 9 | 95 | 21 | 2150 | Intercept | 401.9453938122 | 465.5666137804 | 0.8633466875 | 0.4007038816 | -585.0117378812 | 1388.9025255057 | -585.0117378812 | 1388.9025255057 | ||||
| 6.5 | 60 | 25.5 | 1400 | X1 (Hours Used/Day) | 104.6311994623 | 21.8392391967 | 4.7909727312 | 0.0001999745 | 58.3340805583 | 150.9283183663 | 58.3340805583 | 150.9283183663 | ||||
| 10 | 105 | 19.5 | 2450 | X3 (Motor Power kW) | 11.9688046113 | 2.6174451633 | 4.5727050099 | 0.0003128699 | 6.4200687392 | 17.5175404834 | 6.4200687392 | 17.5175404834 | ||||
| 7.5 | 75 | 23 | 1700 | X5 (Ambient Temp °C) | -15.0631199462 | 14.1550885301 | -1.0641487628 | 0.3030584005 | -45.0705671321 | 14.9443272396 | -45.0705671321 | 14.9443272396 | ||||
| 8.5 | 90 | 22 | 2000 | |||||||||||||
| X1 (Hours Used/Day) | X3 (Motor Power kW) | Y (Energy Use kWh) | SUMMARY OUTPUT | |||||||||||||
| 8 | 75 | 1820 | ||||||||||||||
| 5.5 | 60 | 1350 | Regression Statistics | |||||||||||||
| 9 | 90 | 2100 | Multiple R | 0.9966845526 | ||||||||||||
| 6 | 50 | 1250 | R Square | 0.9933800974 | ||||||||||||
| 10 | 100 | 2400 | Adjusted R Square | 0.9926012854 | ||||||||||||
| 7.5 | 80 | 1750 | Standard Error | 37.7943048365 | ||||||||||||
| 6.5 | 55 | 1280 | Observations | 20 | ||||||||||||
| 8.5 | 85 | 1950 | ||||||||||||||
| 5 | 45 | 1100 | ANOVA | |||||||||||||
| 9.5 | 95 | 2200 | df | SS | MS | F | Significance F | |||||||||
| 6 | 65 | 1450 | Regression | 2 | 3643892.03887272 | 1821946.01943636 | 1275.5068118782 | 3.00081058265815E-19 | ||||||||
| 10 | 110 | 2500 | Residual | 17 | 24282.96112728 | 1428.4094780753 | ||||||||||
| 7 | 70 | 1600 | Total | 19 | 3668175 | |||||||||||
| 8 | 85 | 1900 | ||||||||||||||
| 5.5 | 50 | 1200 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||||
| 9 | 95 | 2150 | Intercept | -90.8987695588 | 47.7091292701 | -1.9052699336 | 0.0738025035 | -191.5562336977 | 9.75869458 | -191.5562336977 | 9.75869458 | |||||
| 6.5 | 60 | 1400 | X1 (Hours Used/Day) | 103.1766706048 | 21.8811452104 | 4.7153231521 | 0.0001996116 | 57.0114895791 | 149.3418516306 | 57.0114895791 | 149.3418516306 | |||||
| 10 | 105 | 2450 | X3 (Motor Power kW) | 13.9807509437 | 1.8171223928 | 7.6938961288 | 0.0000006183 | 10.1469578125 | 17.8145440749 | 10.1469578125 | 17.8145440749 | |||||
| 7.5 | 75 | 1700 | ||||||||||||||
| 8.5 | 90 | 2000 |
Sheet2
test topics
in-class: payoff matrices (profit or cost) --decision rules --regret matrix and rules at-home: --exponential utility function and decisions --decision trees
