Page 1 of 1

A study of home energy consumption in the Twin Cities resulted in the data found in “energy.csv”. a) Fit the simple line

Posted: Thu Apr 28, 2022 7:58 am
by answerhappygod
A study of home energy consumption in the Twin Cities resulted
in the data found in “energy.csv”.
a) Fit the simple linear regression of Carbon on Size. Identify
“s” and “R2.” For now, assume all assumptions are met.
b) Fit the multiple linear regression of Carbon on all the other
variables, including Size (a total of four explanatory variables).
Report the improvement in the “s” and “R2” statistics achieved by
including the additional variables beyond just using Size. Again,
assume all assumptions are met.
c) Comment on the statistical significance of each variable
included in the more complete model (t-test on its coefficient)
from part c). Comment on how much the estimated coefficient (slope)
for Size changed when comparing the models in parts b) and c). What
does that tell you?
d) A house (in the Twin Cities) currently has two occupants, is
2400 square feet in size, and has a programmable thermostat that
set at 68° during the daytime in the winter. Using the more
complete model, predict the carbon equivalents of energy usage for
the house and generate an 80% prediction interval.
A Study Of Home Energy Consumption In The Twin Cities Resulted In The Data Found In Energy Csv A Fit The Simple Line 1
A Study Of Home Energy Consumption In The Twin Cities Resulted In The Data Found In Energy Csv A Fit The Simple Line 1 (111.4 KiB) Viewed 39 times
Size 4 2 2 1 1918 1522 1515 1488 2535 TempSet 65 68 65 68 68 68 4 ProgTherm 0 0 0 0 1 0 1 1 1 4 2 1046 1056 4 4 72 68 1028 2 998 937 1290 72 70 68 68 68 68 3 3 4 2 2 4 4 3 3 4 4 3 1506 1148 2549 2153 1509 72 64 2434 68 0 1 1 1 1 0 0 1 0 1 1 1 0 0 0 0 0 1 0 2 4 4 1156 2435 2612 3579 1550 1338 3 1 Carbon NoOcc 2951.604 3630.474 2824.343 3332.267 4601.381 1878.998 3271.188 3199.658 2273.924 2854.861 4558.26 4025.572 2677.167 4324.907 4801.228 3363.272 5793.042 1995.312 3694.437 3448.628 4607.539 3294.486 4196.33 2285.945 5949.632 2554.66 1611.779 2119.037 3520.928 2217.916 6367.979 5273.712 3229.698 2333.852 2215.262 3716.882 6413.206 3160.237 2179.145 2875.312 2765.384 4066.368 2588.593 2846.515 2376.915 4169.603 4520.051 3711.795 2 67 68 67 66 62 68 68 68 63 72 60 67 1 488 2058 2 2 1 770 936 1129 1478 2 5 1 62 5 901 1960 2421 5 1 852 1103 2 1 2 865 1652 1176 1595 4 68 65 70 62 70 68 67 69 62 59 67 70 70 1 0 1 0 0 0 1 1 1 1 0 0 0 1 1 1 0 0 0 0 0 1 0 0 1 1 5 991 2 1 1295 2 2 1526 1224 1289 1516 70 1 2 2 1 1 2 2 1027 1817 65 68 70 67 2364 2311 3 1

3 5 4 4 3 3 4 4 764 1682 899 986 1329 1376 1720 2827 759 1847 68 64 68 67 65 60 64 69 68 68 68 62 1 0 1 1 0 0 1 1 1 1 3 5 3 4 5 1 2 1 61 2190 2081 1493 1093 1092 1155 2 68 68 3 68 3 2 1 0 0 0 0 0 0 0 1 1 0 1 0 0 1805 3 68 70 66 62 2 1 4 2098 1663 1293 1728 745 1719 2400 70 2 65 70 0 1787.628 3385.39 2844.468 2299.331 3430.497 4520.676 3089.582 5100.422 2053.305 4024.689 3116.689 3817.093 2492.545 2803.003 3524.625 3955.022 5334.444 4734.059 3084.136 1815.435 4434.176 2374.871 4171.968 4667.798 3366.458 3710.834 1811.276 1872.032 3299.578 2530.15 2598.017 3526.698 1896.244 1246.472 2399.551 4724.807 3761.082 2940.138 3152.188 2555.779 3490.164 2832.206 3031.708 4395.185 2985.257 2207.883 3504.527 4623.977 2339.471 2 3 1 2 2 1214 68 68 68 1013 837 1 0 0 1 0 1 65 2359 1100 768 55 68 68 67 70 4 4 7 7 1 4 4 2 2 2 2 2 5 5 2 1246 1324 2557 1256 1266 0 0 1 1 1 0 0 0 0 1 1 1 1 0 2 1912 1275 1235 2151 4 1 3 1719 2 66 65 62 68 70 65 68 67 68 68 70 64 66 68 68 70 71 2 2 4 2407 947 1405 2181 1798 1008 1247 1059 972 4 1 0 0 1 1 1 1 1 1 1 1 4 2 2

72 68 68 67 68 73 1 1 1 0 1 1 1 1 1 1 68 1 0 1 2 2 2 4 2 3 2 2 2 2 2 2 3 5 2 3 2 2 2 2 2 1 1 0 1 0 1 1 1 1 1 0 1 0 0 1 2504.194 2715.234 2780.243 2510.495 2508.935 3325.971 2503.795 2954.158 2966.122 3143.551 4955.448 2271.492 2339.406 4206.976 2698.464 2515.061 2921.214 4278.734 2909.334 3595.362 3931.739 4230.208 2607.096 2887.668 3147.181 3023.155 2860.361 3432.543 4020.547 3799.399 3574.661 3357.685 2954.387 2267.353 2896.324 2373.396 3192.28 3063.605 2425.645 2275.34 6360.229 3220.431 3328.784 3313.435 2800.539 3319.681 4270.927 4289.604 3732.731 70 68 68 70 68 69 68 68 68 68 70 70 67 68 70 68 68 64 68 62 2 1125 1036 1932 863 1598 1135 2124 959 912 1227 1255 1052 2027 2281 2545 978 946 2173 761 1909 1409 1822 1143 1045 973 1644 1314 1434 2062 1589 2092 1678 1004 1159 954 1340 2218 1273 1493 1341 1987 3059 1515 1532 1588 1112 1677 1127 1891 5 888乃B%88888888%D8四888a8888B%88%8%88%82%B2% 1 1 4 4 2 69 0 1 0 1 4 4 4 1 1 68 68 69 70 70 68 76 68 72 1 1 4 4 1 1 2 3 1 1 0 0 1 1 1 68 70 68 69 1 1 1 1 1 2 3 2 4 3 3 2 2 70 68 71 72 65 67 72 70 1 1 1 1 1 4 1

68 65 1 1 1 2 2 1 3 3 2 2 4 70 72 70 74 1 0 0 0 1 0 2 1 2 2 4 2 3 3 5 2 3 1 0 1 1 1 1205 1314 1090 785 2133 2134 1692 1182 2459 1167 2001 2489 2839 1834 1607 1771 936 1853 1531 1129 1138 1794 1706 1716 1235 64 70 67 73 65 68 66 66 68 68 70 67 70 67 65 71 0 1 1 0 0 0 0 0 1 2 2783.144 2902.523 3164.636 2882.222 3863.208 3633.296 2690.48 3894.593 2753.163 2687.336 3380.469 4440.664 4540.625 2095.353 2779.788 4123.845 3175.241 4167.217 5352.985 1698.71 3229.429 4362.594 4275.656 3927.01 2827.816 4049.933 1356.778 2430.995 3948.639 5460.764 2067.186 2928.975 3660.035 2137.09 3578.691 1882.808 2964.173 3035.287 1290.492 2980.808 2769.108 3698.596 2570.388 3336.46 1448.531 3852.844 4116.155 5289.246 3130.909 2 1 2 3 4 8B%BB叫叫%B888888%切四切困n82&%8B%8888n8858288828888 1 1 0 1 2 2 2 68 72 68 70 70 66 70 70 60 63 68 68 71 1732 1010 1808 1523 2052 1437 1235 1281 983 1444 1 1 1 1 1 0 5 2 3 0 4 4 0 0 1 2 2 2 66 69 1 1 1 4 980 1419 1919 1005 995 67 oo 1 5 0 0 1 1 1 5 943 72 68 68 65 72 4 2 2 2 4 2 2 2 2 958 1216 1094 875 2362 2235 2748 1387 1 0 1 1 65 69 68 70 68 O O O O 1 0 0

1 4 5 5 1 6 0 2 0 2 4 1 0 0 1 1 3 3 2 4 4 0 01 1 1 oo loo 1 1 oooo 1 1 o 1o1oo 2 2 0 0 0 2 1 1 1972 1514 2181 699 984 808 1275 1473 1693 983 1343 766 1387 1068 1758 1548 996 1326 1001 1261 1408 1758 1051 2447 1320 1810 2883 2201 1084 1786 2219 62 71 70 65 68 69 71 68 65 68 67 68 68 58 72 64 68 72 71 70 70 68 68 67 68 70 66 68 66 64 70 2 0 2 1 0 4 0 1946.69 3204.981 5622.587 1648.635 3085.269 3927.938 2846.591 2910.457 2287.588 2980.618 3259.657 3058.948 2845.278 2432.296 3923.343 3727.386 2808.94 3653.932 2441.129 2499.5 3014.998 2401.517 2714.439 2426.546 2628.795 3435.659 3909.967 3830.745 2564.264 2380.406 3581.306 6748.389 2617.797 2599.161 4459.692 2229.659 5161.25 4072.23 3753.829 2270.81 3020.267 3987.398 3761.013 2929.967 3072.383 3555.461 3825.32 2728.288 4010.422 2 1 2 0 1 2 1 an889n888888RMBRnB%88m8888MB888288888B2%B8%8 2 3 4 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3101 68 1 2 3 2 2 4 4 3 5 4 5 1384 2183 2197 1 1 2 68 65 72 68 68 68 68 65 70 70 72 67 70 70 66 70 1 1 2 1590 1644 1531 2057 1252 1257 2461 1645 1398 1977 3735 2150 1458 2953 2 1 1 1 4 2 2 2 1 1 2 1 1 2 3 1 4 68 1

2 1 2 4 2 2 2 1 5 70 68 68 69 72 70 72 68 66 68 1oo1101 10 1 1 ooo 3 2 2 68 2 2 0 0 0 0 3 1 1 4 2 ooo 0 2 1 1 1 3 2 2 68 67 65 68 69 72 68 66 70 65 55 73 73 64 1 1 2 2255.07 2598.219 3021.226 4521.35 2751.748 3083.396 2642.081 6430.378 2654.083 2035.508 2959.894 4167.699 2961.539 2314.013 1699.341 4549.229 4537.633 2510.58 1940.133 3496.514 3629.747 2929.368 3631.169 4392.575 2891.063 5040.837 4761.021 2833.869 4328.84 3778.366 3578.184 2988.624 3293.148 5878.672 2461.096 6533.465 3107.675 3527.962 3495.658 1593.793 3216.169 2118.302 3135.75 2394.881 3135.974 3761.541 3371.865 3822.582 2924.82 4 979 1188 1270 1632 1121 905 1525 1224 1839 1005 1102 1850 1005 992 1026 1965 1238 1142 1488 2093 985 1976 1864 1431 1965 2605 1575 1059 1176 1089 1948 1955 1517 1054 1212 2346 1315 1143 1074 983 1343 956 810 946 1682 1129 1087 1282 1465 2 2 w8892228888888928B%BBB8%B928888888B%2B%BB%9288 70 4 72 1 1 1 0 1 0 1 1 1 1 69 2 2 2 3 5 4 3 1 0 2 4 2 3 3 72 68 68 68 68 58 68 70 68 70 72 65 76 68 70 73 70 70 72 68 2 1 0 1 1 1 01 1 0 1 1 ooooo looo1 2 0 2 2 2 0 1 0 0 5 2 68

2 979 1011 2 2. 1 1 1 1 0 0 4 4 1 1 1269 1001 903 1143 912 960 1 0 2 1 1 1 2 1 1 1133 957 1041 1034 2 3 68 68 72 68 66 70 70 68 70 68 71 62 68 67 66 68 70 70 68 74 72 70 72 70 5 1 1 0 0 1 2 4 4 3 2 1 1 1 2 0 1 1 1 3393.071 2461.456 2730.785 4264.153 1912.879 2917.319 2807.491 1717.048 2479.34 2303.256 1873.66 2200.114 6758.112 2536.028 2606.017 2088.466 4880.305 1951.68 2096.946 2365.684 3292.316 2708.482 2588.907 4348.964 2374.424 3923.647 2084.206 3811.347 1864.97 2628.051 2965.917 2447.752 2721.495 2794.792 2605.056 4905.417 2762.014 5219.159 3776.963 4789.468 1982.623 3208.965 4161.562 2886.303 4224 2472.363 3184.131 2862.887 2790.714 2 1 2 2 2 8 1 2 3 6 4 2 0 1 0 68 2591 1421 1257 837 1317 1053 985 941 1395 1059 1246 2377 1469 1513 1541 1388 916 1051 1053 1063 974 1105 1242 1395 1076 2193 1977 70 66 0 1 1 1 0 1 1 1 0 3 2 4 3 2 2 3 72 68 68 72 68 72 68 68 70 70 68 70 68 63 70 68 70 72 67 70 68 68 1 1 0 0 1 0 1 1 1 1 4 4 5 1268 1602 2 2 3 2 2 2 1079 1430 3 3 1233 1087 976 1533 1165 1115 1 1 0 1 1 1 1 3 4 2

0 1 6 1 70 71 68 70 70 0 N 5 2456.639 4167.219 3040.281 2998.357 3443.795 2785.332 3558.628 2832.776 4111.584 3019.263 2111.626 5 1 4 1071 1488 932 1395 1276 1196 1232 1809 1746 1804 1358 67 0 1 0 1 1 1 0 0 1 1 1 2. 2 N N 72 68 72 68 66 2