PUAD 630 Analytical Techniques in Public Administration Project

User Generated

Uhffnz002

Mathematics

PUAD 630

PUAD

Description

Unformatted Attachment Preview

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 B Machine Hours 1539 1284 1490 1355 1500 1777 1716 1045 1364 1516 1623 1376 1327 1178 1491 1667 1769 1104 1196 1794 1379 1448 1505 1420 1475 1118 1433 1589 1585 1493 1124 1536 1678 1723 1413 1390 C Production Runs 31 29 27 22 35 30 41 29 47 21 37 37 49 50 37 41 34 44 46 29 38 32 32 42 27 34 58 26 32 33 36 28 41 35 30 54 D Overhead 99798 87804 93681 82262 106968 107925 117287 76868 106001 88738 105830 88730 100624 98857 102622 108059 110054 91892 98693 110530 96883 99593 94564 105752 93224 75398 113137 85609 98498 101803 88371 102419 117183 107828 88032 117943 E F G H Dataset for prediction Month Machine Hours Production Runs 37 1430 35 38 1560 45 39 1520 40 I A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 Generic foot size 9.034 13.396 13.932 16.015 11.73 5.062 12.885 9.771 9.14 13.639 14.351 14.435 16.8 17.194 8.433 16.497 7.405 4.682 7.83 14.101 12.095 18.692 21.311 16.149 3.308 17.868 10.889 11.279 14.154 16.985 10.944 15.435 12.346 13.038 10.025 13.84 15.844 7.227 13.801 10.796 16.965 9.283 12.986 15.771 8.225 15.082 13.736 10.896 15.345 11.985 16.916 15.125 10.441 15.022 15.708 10.325 13.802 13.874 8.303 17.509 9.623 15.053 14.001 3.026 11.415 14.396 17.615 15.561 16.459 9.281 17.266 16.7 8.861 13.76 7.724 12.083 12.745 13.638 12.998 10.422 14.252 17.452 10.19 16.069 11.941 12.513 8.156 15.297 13.399 15.63 15.191 15.037 7.333 17.241 12.322 16.5 11.018 10.223 9.178 14.474 B Left 9.118 13.249 14.169 16.125 11.839 5.4 12.687 9.752 9.023 13.989 14.118 14.346 16.804 17.451 8.606 16.444 7.418 4.647 8.184 14.195 12.007 18.462 21.32 16.04 3.187 17.85 10.989 11.511 14.267 16.382 10.975 15.566 12.076 13.383 10.196 14.353 15.915 6.873 14.106 10.771 16.612 9.356 12.81 15.895 8.295 14.906 13.911 11.233 15.036 12.19 16.945 14.966 10.406 14.931 16.039 10.408 13.724 13.694 8.292 17.453 9.915 15.4 13.806 3.013 11.107 14.234 17.641 15.481 16.88 9.41 17.33 16.484 8.913 13.764 7.437 11.667 12.826 13.532 13.244 10.577 14.062 17.328 10.192 16.263 11.629 12.672 7.916 15.221 13.753 15.778 15.27 15.514 7.644 17.286 12.11 16.339 10.872 10.242 9.066 14.85 C Right 8.551 13.245 14.049 16.07 11.712 5.048 12.794 9.886 9.234 13.659 14.46 14.477 16.749 17.479 8.32 16.764 7.411 4.549 7.973 14.316 12.139 18.864 21.341 16.063 2.918 17.88 10.614 11.376 14.425 17.078 10.978 15.642 12.365 12.997 9.927 13.614 15.658 6.925 13.983 10.897 16.806 9.313 12.698 15.743 7.932 15.086 13.554 11.269 15.11 11.987 17.112 15.375 10.33 14.721 15.81 10.545 13.605 13.863 8.54 17.408 9.564 15.152 14.251 2.759 11.683 14.301 17.447 15.665 15.948 9.336 17.155 16.528 8.953 13.688 7.9 12.485 12.654 14.089 12.809 10.503 14.377 17.532 10.117 16.124 11.945 12.571 8.091 15.439 13.825 15.617 14.91 14.99 7.832 17.154 12.187 16.49 10.931 9.839 9.76 14.072 D Height 60.376 78.538 77.023 78.286 65.912 51.539 73.981 69.619 64.502 71.543 73.624 82.811 84.491 82.56 60.108 79.987 50.302 47.43 59.065 82.306 66.17 89.991 105.921 86.64 41.638 89.09 70.824 66.332 75.851 92.242 70.155 85.065 69.445 78.39 69.392 75.273 79.088 62.149 78.04 60.435 82.778 64.042 75.709 76.735 57.638 80.091 73.157 61.151 86.079 69.753 83.604 83.688 66.455 80.7 78.032 59.618 78.331 77.849 52.752 87.533 63.995 78.411 77.371 40.705 65.695 78.778 91.412 83.668 83.123 59.39 86.887 82.372 61.783 73.419 56.096 69.813 72.777 73.27 68.138 63.847 77.522 84.692 65.86 84.431 65.656 71.196 57.472 79.271 73.967 77.627 75.403 77.973 54.057 90.134 71.706 80.119 69.192 66.262 59.217 75.308 Ex.3 Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Age Gender Own Home 73 0 0 22 0 1 51 1 1 48 1 1 57 1 0 29 0 0 33 0 0 55 0 1 62 1 1 37 1 1 63 1 0 31 1 1 34 1 1 45 1 0 53 0 1 49 0 1 55 0 1 49 1 1 43 0 0 23 1 0 27 0 1 69 1 1 42 0 0 71 0 0 30 1 0 43 1 0 24 0 1 32 0 1 76 0 1 38 1 1 32 0 1 41 1 1 38 0 0 29 0 1 53 1 1 47 0 1 28 1 0 22 1 1 36 0 1 68 0 0 26 1 1 65 1 1 56 1 1 Married 0 1 1 1 0 0 0 1 0 1 1 1 0 0 1 1 1 1 0 1 0 0 0 0 0 0 0 1 1 1 0 1 0 0 0 0 1 0 0 1 1 0 1 Page 3 Close 1 0 1 1 1 1 1 0 1 0 1 0 1 0 1 1 1 1 1 1 0 0 1 1 1 0 1 1 1 0 0 1 0 1 0 0 1 1 1 1 1 1 1 Salary $16,400 $108,100 $97,300 $26,800 $11,200 $42,800 $34,700 $80,000 $60,300 $62,300 $94,200 $73,800 $45,900 $52,600 $82,200 $76,700 $79,400 $66,900 $12,400 $52,600 $28,300 $53,900 $28,900 $15,900 $50,700 $17,800 $51,300 $74,400 $88,200 $79,000 $55,200 $95,800 $13,700 $41,300 $65,400 $29,600 $49,800 $73,700 $39,900 $36,600 $51,200 $59,400 $107,300 Children 1 3 1 0 0 0 0 0 0 0 1 0 2 1 1 2 3 0 1 1 0 0 0 0 3 1 0 0 0 1 0 3 2 1 1 3 0 1 0 0 0 0 2 Ex.3 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 44 32 41 74 27 35 59 51 52 55 28 67 55 60 34 75 43 75 24 74 36 52 53 30 68 37 27 44 58 50 28 41 59 21 53 30 55 40 74 24 56 70 40 69 1 1 1 0 0 0 0 0 1 0 0 1 0 1 1 0 0 0 0 0 1 1 0 0 1 1 1 0 1 0 0 0 0 1 0 0 0 0 0 1 1 0 0 1 1 1 1 0 1 1 0 0 1 0 1 1 1 1 1 1 0 0 1 1 1 0 0 1 1 0 1 1 0 0 0 0 0 1 0 1 0 1 0 0 1 1 1 0 1 1 1 1 1 0 0 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 1 0 0 1 1 1 1 1 1 0 0 0 1 1 1 1 0 0 1 0 1 0 0 0 0 1 1 1 1 1 1 0 1 0 0 1 1 1 1 1 0 1 1 1 0 1 1 0 0 1 0 1 1 0 0 1 1 1 1 1 1 0 1 1 0 1 Page 4 $90,700 $74,400 $15,400 $60,100 $81,700 $36,100 $47,000 $28,200 $56,700 $12,600 $21,500 $96,800 $22,000 $57,600 $65,300 $63,300 $38,200 $11,000 $24,000 $47,600 $87,000 $117,700 $30,100 $12,800 $63,200 $41,600 $75,500 $74,900 $72,200 $36,500 $73,000 $15,100 $19,800 $64,000 $79,400 $82,000 $63,500 $118,000 $13,300 $45,100 $45,900 $43,900 $110,000 $63,000 3 0 0 0 3 0 0 1 2 0 0 2 0 1 0 2 0 2 1 1 0 1 0 0 0 0 0 0 3 1 1 0 1 3 0 0 1 3 1 1 0 2 0 0 Ex.3 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 47 55 37 29 29 23 37 29 69 27 51 25 35 46 51 57 74 23 27 47 74 35 27 31 43 37 24 25 39 53 63 33 52 42 25 64 59 55 71 56 44 46 66 42 1 0 0 0 1 0 1 1 0 1 0 1 0 0 0 1 0 1 1 0 0 1 1 1 1 1 0 0 0 0 1 1 1 0 0 1 0 0 0 1 1 1 1 1 0 0 0 1 0 0 0 1 1 1 0 0 1 1 1 1 0 0 0 1 0 0 0 1 1 0 0 1 0 1 1 1 1 0 1 1 1 0 1 1 1 1 0 0 0 1 1 0 1 0 0 0 0 1 0 0 1 1 0 1 0 1 0 1 1 1 0 1 0 0 0 0 1 0 1 0 1 0 1 1 1 1 1 1 0 1 0 0 1 1 1 1 0 1 1 1 1 1 0 1 0 1 1 1 1 0 1 0 1 1 1 1 1 1 0 0 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 Page 5 $61,800 $53,300 $42,000 $25,900 $20,200 $46,600 $18,700 $45,700 $32,600 $96,100 $14,400 $54,200 $80,600 $48,900 $30,300 $124,900 $13,700 $60,300 $43,100 $128,700 $118,300 $36,500 $13,400 $101,700 $76,800 $21,900 $16,100 $64,100 $95,900 $58,200 $120,000 $68,400 $83,600 $13,400 $54,700 $41,300 $130,700 $39,500 $93,400 $83,100 $55,900 $71,200 $57,800 $59,100 0 0 3 2 1 0 0 0 3 0 1 0 0 3 0 0 1 1 1 0 1 0 0 1 1 0 0 2 0 0 3 0 2 1 0 0 3 0 2 2 1 1 0 2 Ex.3 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 46 24 23 40 55 30 61 40 55 48 23 64 29 35 32 67 47 26 25 54 58 34 26 49 26 32 51 42 44 24 67 43 36 30 76 22 51 26 44 53 22 70 53 33 0 1 0 1 1 0 0 1 1 0 1 1 0 1 1 1 0 0 1 1 1 1 1 0 1 0 1 1 1 0 0 1 0 0 1 1 1 0 0 0 0 1 1 1 0 0 1 0 0 0 0 1 0 0 0 1 1 1 1 1 0 0 0 1 0 0 1 0 1 1 0 1 0 0 1 0 0 0 0 1 0 1 1 0 0 1 0 0 0 0 0 1 0 1 1 0 0 0 0 1 1 0 1 1 0 0 0 1 0 0 1 0 1 1 0 1 0 1 1 1 0 0 0 1 0 0 1 0 1 1 1 0 0 0 0 1 1 0 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 0 1 1 1 1 0 1 1 0 1 1 0 1 1 0 1 1 1 Page 6 $23,100 $10,900 $47,500 $76,200 $14,200 $52,500 $43,300 $66,600 $55,100 $10,600 $56,300 $58,900 $102,500 $71,500 $73,300 $69,900 $12,100 $23,000 $39,500 $55,500 $45,600 $19,500 $70,400 $10,200 $83,700 $72,600 $40,500 $63,300 $14,800 $84,800 $85,500 $84,100 $26,600 $42,500 $15,300 $67,600 $15,200 $56,000 $84,800 $10,600 $88,400 $87,200 $106,700 $27,100 2 0 0 1 1 0 3 0 2 2 0 0 3 0 0 1 1 3 1 0 0 0 2 3 0 1 1 2 3 0 2 1 2 0 0 1 0 3 1 2 0 0 2 1 Ex.3 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 27 42 54 33 61 72 28 52 23 23 56 41 47 71 42 24 48 73 64 48 42 68 25 72 55 26 22 60 25 47 73 58 40 63 26 65 30 60 38 43 25 39 31 30 0 0 0 0 0 1 0 0 0 1 0 1 0 0 0 1 0 1 1 1 0 1 1 0 0 0 0 1 0 1 0 1 0 0 0 0 1 0 0 1 1 0 1 0 1 1 1 1 1 0 1 0 0 1 1 1 0 0 0 1 1 1 0 0 1 0 1 0 0 0 1 0 0 1 1 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 1 0 1 0 0 1 1 1 0 0 0 1 1 1 1 0 1 0 1 0 0 1 1 0 0 1 0 0 0 1 1 1 1 0 0 1 1 0 0 1 1 1 1 1 0 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 0 1 1 1 0 0 1 1 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 Page 7 $46,600 $49,100 $35,200 $35,200 $84,100 $25,800 $49,700 $13,200 $14,600 $109,900 $126,300 $100,600 $11,700 $36,400 $22,200 $106,400 $112,800 $95,900 $88,000 $44,500 $43,600 $20,800 $23,400 $46,600 $31,300 $33,200 $70,400 $17,000 $26,200 $108,900 $17,300 $51,900 $33,600 $61,000 $41,600 $54,200 $66,200 $72,200 $39,700 $36,900 $96,100 $11,700 $31,600 $82,800 2 2 0 0 0 0 2 1 3 2 1 3 0 2 2 0 0 0 2 0 0 0 0 0 1 1 0 0 1 0 0 0 0 1 0 1 0 0 3 0 3 0 1 0 Ex.3 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 58 23 50 22 58 54 36 45 66 71 54 47 69 65 43 24 44 62 42 51 27 45 53 32 38 35 56 38 36 67 50 27 43 61 47 43 62 45 28 42 25 35 54 65 0 1 1 0 0 0 0 0 0 1 1 1 0 1 1 1 1 0 1 0 1 1 1 1 1 1 1 0 0 1 1 0 1 0 1 1 0 1 0 1 0 0 0 1 0 0 0 1 0 1 0 1 0 0 1 1 1 1 0 0 1 0 0 0 1 1 1 1 1 1 0 0 1 0 1 0 0 0 1 1 1 0 0 1 0 1 0 1 1 1 1 1 1 1 0 0 1 0 1 1 0 0 1 0 1 1 1 0 1 0 1 1 0 0 0 0 0 1 0 0 0 0 1 1 1 1 0 0 0 1 1 0 1 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 0 1 0 1 1 0 1 1 1 0 1 1 1 1 1 0 1 0 0 1 1 0 1 1 0 1 0 1 Page 8 $40,900 $65,800 $39,700 $79,300 $40,500 $64,100 $42,000 $32,500 $68,600 $60,400 $130,600 $73,100 $23,800 $52,900 $53,600 $55,600 $52,000 $79,500 $64,600 $14,300 $100,000 $48,100 $107,300 $85,600 $62,700 $55,600 $54,700 $46,500 $35,900 $106,100 $49,200 $10,800 $45,200 $20,400 $95,800 $111,400 $49,200 $48,800 $14,000 $82,800 $12,900 $44,100 $72,900 $59,300 1 2 0 0 2 1 3 0 0 1 0 0 0 1 1 0 0 0 2 1 1 2 2 0 2 0 0 1 0 3 3 3 1 0 3 0 0 2 0 0 1 1 0 0 Ex.3 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 53 58 47 61 46 24 25 54 48 47 44 73 29 37 48 35 23 36 25 43 28 22 36 63 26 25 21 24 70 57 65 39 34 50 54 54 74 31 49 45 49 38 26 66 1 1 1 0 0 0 1 1 0 1 0 0 0 1 0 0 1 1 1 0 1 1 0 0 0 0 0 0 1 1 0 1 1 1 0 0 0 1 0 1 0 1 0 1 1 1 1 0 1 1 0 0 1 1 0 0 0 1 1 0 0 0 0 1 0 0 0 0 0 1 0 0 0 1 1 1 1 1 0 0 0 1 1 1 0 1 0 1 0 0 0 0 0 0 1 1 0 0 1 0 0 0 1 0 1 0 0 0 0 0 0 1 1 0 0 0 1 1 0 0 1 1 1 0 1 1 1 1 0 1 1 0 1 1 1 0 1 1 0 1 1 1 1 1 1 1 1 1 1 0 1 1 0 0 1 0 1 1 1 1 1 1 1 1 1 1 0 0 1 0 0 1 1 0 1 1 Page 9 $59,700 $40,200 $62,800 $22,600 $54,400 $33,400 $63,300 $87,400 $27,000 $65,300 $104,900 $20,100 $14,600 $48,100 $107,600 $58,600 $80,700 $40,200 $25,000 $46,600 $21,900 $13,900 $25,700 $72,200 $76,400 $20,300 $11,400 $17,000 $60,000 $107,400 $37,300 $68,900 $83,000 $97,400 $92,400 $44,800 $50,500 $65,400 $83,100 $117,500 $43,300 $103,900 $41,700 $44,800 1 2 3 0 3 1 3 2 2 3 3 0 1 0 2 1 3 0 0 3 2 0 2 0 0 1 2 0 0 0 0 2 2 1 1 1 0 3 1 2 3 1 1 0 Ex.3 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 52 54 75 29 62 45 25 34 50 72 36 71 29 58 24 49 21 28 43 21 25 41 55 27 54 27 71 37 49 30 52 36 34 45 21 25 39 37 42 51 57 43 37 42 1 0 0 1 1 0 1 0 1 1 1 0 0 1 1 1 0 1 1 1 0 1 1 1 1 0 0 1 1 1 1 1 0 0 0 0 1 1 0 1 0 1 1 1 1 0 0 0 1 0 0 1 1 0 1 1 0 1 0 1 0 1 0 0 0 1 1 0 0 0 1 0 1 1 1 0 1 1 0 0 1 1 1 1 1 0 1 0 0 0 1 0 1 0 1 0 1 0 0 1 0 1 1 0 0 1 0 0 1 1 0 0 0 0 1 0 1 0 0 1 1 0 0 1 1 0 1 1 0 0 1 1 Page 10 0 1 1 0 1 1 1 0 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 0 1 0 0 1 1 1 1 1 1 1 0 1 1 1 0 1 0 1 0 $45,000 $43,700 $23,600 $20,400 $123,000 $44,600 $55,500 $56,200 $96,300 $32,400 $60,200 $72,900 $19,300 $74,800 $34,300 $75,400 $11,400 $30,400 $41,200 $21,400 $60,600 $105,300 $63,700 $15,800 $56,900 $15,900 $37,500 $42,500 $97,500 $29,600 $55,600 $74,600 $68,500 $51,900 $17,200 $51,900 $70,200 $61,500 $70,900 $72,500 $33,200 $58,600 $54,700 $64,000 1 0 1 0 0 0 3 0 2 1 0 0 1 0 3 0 3 0 0 0 3 1 0 2 0 0 0 1 0 3 0 2 2 2 1 0 0 2 1 0 0 2 0 1 Ex.3 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 30 51 24 25 56 41 44 47 42 33 23 37 60 62 50 53 32 46 29 29 35 37 23 58 27 53 28 65 33 22 67 33 22 42 24 21 38 51 29 24 43 49 38 47 0 1 1 1 0 0 0 1 1 1 0 0 1 1 1 1 1 1 0 1 1 1 0 0 0 1 1 0 1 1 1 1 1 1 1 1 1 1 0 0 1 1 0 1 0 1 0 0 1 1 1 0 1 1 0 1 1 0 1 0 0 1 0 0 1 1 0 1 0 1 1 1 1 0 1 1 0 0 0 0 1 1 0 0 1 0 1 1 0 1 0 1 1 1 0 1 0 1 0 0 1 1 1 0 1 1 0 1 1 1 0 1 0 0 0 1 0 0 1 1 1 0 0 0 1 1 0 0 1 0 0 1 Page 11 0 1 1 1 1 1 0 0 0 0 1 1 0 0 1 0 1 0 1 1 1 1 0 1 0 1 1 1 1 1 1 1 0 0 1 1 1 0 0 1 1 0 1 0 $12,500 $122,700 $23,200 $41,600 $69,400 $109,800 $66,800 $87,100 $80,800 $122,100 $19,400 $43,300 $33,000 $66,300 $96,300 $55,800 $63,500 $82,400 $14,200 $41,500 $82,500 $85,600 $18,400 $62,600 $13,800 $60,300 $31,500 $111,500 $67,900 $29,200 $84,500 $84,700 $67,300 $51,100 $23,500 $21,300 $90,100 $84,300 $13,200 $22,100 $53,700 $38,700 $35,200 $113,300 1 1 1 3 0 1 3 2 2 0 1 1 0 0 1 1 2 2 0 0 0 1 1 0 3 0 3 0 0 0 0 3 3 0 0 1 0 2 0 2 1 1 2 1 Ex.3 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 37 70 32 26 21 38 35 44 35 46 39 44 47 45 28 34 41 44 67 50 23 22 69 48 39 65 72 55 50 40 62 62 38 40 21 36 40 27 35 59 43 38 62 35 1 0 0 0 0 0 1 1 0 1 1 1 0 0 1 1 1 1 1 1 0 0 0 0 1 0 1 0 1 0 1 0 0 1 0 1 1 0 0 0 0 1 0 1 0 1 1 0 0 1 1 0 1 1 1 1 1 0 1 1 1 0 1 1 1 0 1 1 1 1 1 0 0 1 1 1 1 1 0 0 1 0 0 1 1 1 1 0 1 1 0 0 0 0 1 0 1 0 1 0 0 0 0 1 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 1 0 1 0 1 1 0 1 1 1 1 1 1 Page 12 1 1 1 1 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 0 0 0 1 0 0 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 0 0 $105,600 $74,700 $60,200 $12,000 $16,700 $46,100 $103,700 $63,800 $65,400 $49,900 $64,300 $59,600 $45,100 $39,900 $33,400 $99,600 $58,400 $35,100 $53,400 $61,600 $21,400 $20,000 $32,700 $99,200 $109,600 $22,800 $76,900 $97,400 $43,700 $49,600 $71,300 $10,100 $35,800 $113,400 $23,200 $88,500 $96,900 $22,000 $81,400 $114,800 $79,900 $107,400 $78,800 $124,800 3 0 1 0 2 2 1 1 2 1 2 2 1 1 0 1 0 1 1 0 3 3 0 0 1 0 2 3 0 1 0 1 1 3 2 2 1 1 2 0 3 1 0 3 Ex.3 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 27 23 51 28 41 60 68 64 37 43 28 24 40 34 34 47 29 32 45 75 28 36 67 29 45 44 41 28 28 58 29 21 22 32 38 27 47 32 21 61 49 63 30 23 0 0 0 1 1 0 0 1 0 0 0 0 1 1 1 1 0 1 0 1 0 1 0 0 0 1 0 1 0 1 1 1 1 0 1 0 1 1 0 0 1 1 0 1 0 0 1 1 1 1 1 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 1 1 0 0 0 1 0 1 1 0 0 1 1 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 1 1 1 0 0 1 0 0 1 1 0 0 1 1 1 0 1 1 0 1 1 1 0 1 0 0 0 Page 13 1 0 1 1 0 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 0 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 $36,900 $12,800 $65,800 $20,900 $49,700 $25,500 $20,600 $84,300 $31,200 $50,500 $15,500 $12,900 $52,400 $97,600 $50,500 $55,900 $28,900 $108,300 $46,700 $102,700 $15,600 $39,000 $60,200 $17,300 $36,900 $64,800 $67,300 $15,400 $22,600 $54,600 $62,200 $56,300 $21,000 $66,900 $66,500 $13,600 $54,200 $102,400 $42,300 $14,900 $123,800 $58,700 $15,000 $14,100 1 1 1 0 0 0 0 0 3 1 1 1 0 2 0 1 0 2 0 0 0 0 0 0 1 2 1 0 3 0 0 0 0 2 3 1 1 1 0 0 2 0 2 0 Ex.3 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 29 55 62 43 38 53 72 51 28 73 45 42 46 35 27 41 49 28 29 69 22 49 24 31 30 48 33 74 49 31 23 53 29 68 63 29 24 45 51 42 72 44 68 33 0 1 0 1 1 0 0 1 0 1 1 1 0 1 1 1 1 1 1 0 1 0 0 1 1 1 0 1 1 0 1 1 0 0 1 0 0 0 1 0 0 1 0 0 0 1 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 0 1 0 1 1 0 0 1 0 0 0 1 0 1 0 1 1 0 0 0 1 0 0 0 1 1 0 1 1 0 1 1 0 1 0 1 1 1 1 1 1 1 0 1 1 1 0 1 1 0 0 1 0 0 0 1 1 1 1 1 1 0 1 0 1 1 1 1 0 1 Page 14 0 0 1 1 1 1 0 1 0 1 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 0 1 1 0 1 1 1 1 0 1 0 1 1 1 0 0 1 1 $17,300 $77,800 $65,900 $73,200 $88,100 $51,900 $47,500 $74,500 $27,900 $58,300 $81,200 $104,100 $87,200 $76,400 $64,300 $119,800 $56,300 $67,800 $66,700 $91,800 $17,700 $97,900 $76,200 $47,200 $21,700 $82,400 $35,600 $42,800 $72,000 $90,400 $37,200 $77,000 $71,200 $61,000 $37,000 $25,300 $53,700 $48,100 $96,300 $75,200 $81,500 $83,500 $30,900 $75,600 1 1 0 0 2 3 0 0 0 0 0 0 0 2 3 2 3 0 0 0 1 0 0 0 1 0 3 0 0 1 1 0 3 0 0 3 0 0 1 1 0 2 0 0 Ex.3 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 29 72 49 32 56 42 73 39 42 24 46 47 30 40 40 26 28 69 23 26 73 38 69 44 39 75 58 34 58 23 53 28 53 65 49 28 21 33 35 56 43 50 27 39 1 0 0 0 1 0 0 1 1 0 1 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 1 0 1 0 1 1 0 0 0 1 1 1 0 0 0 0 1 0 0 1 1 1 0 0 0 0 1 1 0 0 0 1 1 0 1 1 1 0 0 1 0 1 1 0 1 0 1 1 0 0 0 1 0 0 1 1 1 1 1 1 1 0 0 1 1 1 1 0 0 1 1 0 0 0 0 1 0 1 0 0 0 0 1 1 0 1 1 0 1 1 0 1 1 0 1 0 1 1 1 1 0 1 Page 15 0 1 1 1 1 0 0 1 1 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 0 0 1 0 1 1 1 1 0 1 1 1 1 0 1 $25,100 $41,700 $35,300 $35,300 $44,400 $44,200 $57,900 $97,100 $96,400 $23,100 $67,700 $53,900 $42,400 $52,700 $47,000 $14,800 $12,700 $96,200 $15,100 $43,700 $43,300 $36,700 $28,500 $32,100 $92,900 $40,100 $21,400 $72,200 $67,900 $21,100 $93,000 $40,900 $61,300 $110,700 $81,800 $19,100 $73,600 $62,500 $48,600 $69,800 $90,300 $74,500 $32,000 $68,200 0 0 0 0 0 0 0 0 1 2 0 1 1 2 1 1 3 0 0 1 0 1 0 2 1 0 0 0 0 1 3 2 2 0 1 0 1 3 0 0 0 2 1 1 Ex.3 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 30 31 41 30 21 39 44 54 22 74 27 36 46 46 22 50 34 52 74 25 30 22 32 40 39 50 59 47 43 25 47 30 61 27 42 68 33 55 26 67 60 68 70 29 0 0 0 0 0 0 1 1 1 1 0 0 1 0 0 1 0 1 1 1 0 1 0 0 1 0 0 1 0 0 1 1 0 1 0 1 0 1 1 1 0 1 0 0 1 0 0 0 0 0 0 1 0 1 0 1 1 1 0 1 1 1 1 0 0 0 0 1 1 0 1 1 0 1 1 0 0 0 1 0 1 1 0 1 1 1 1 0 0 0 1 0 0 1 1 1 0 1 0 1 0 1 0 1 1 0 1 0 0 1 1 1 1 0 1 1 0 1 0 1 0 0 0 0 1 1 1 0 1 1 1 0 Page 16 1 0 1 0 0 1 1 0 0 0 1 0 0 1 1 0 1 1 1 1 0 0 0 1 1 1 1 1 0 0 0 0 0 1 1 1 1 0 1 1 1 1 0 1 $21,600 $38,200 $91,000 $12,000 $18,200 $72,100 $38,400 $79,700 $17,700 $112,900 $17,800 $52,300 $60,200 $80,800 $21,900 $102,700 $90,500 $44,600 $85,300 $13,000 $32,400 $46,300 $120,800 $92,300 $102,300 $41,400 $22,400 $102,700 $44,100 $33,700 $39,100 $41,500 $17,900 $14,600 $46,300 $34,500 $76,600 $100,100 $49,300 $63,200 $42,800 $106,600 $74,900 $19,100 2 0 2 0 2 0 2 1 0 0 1 1 0 1 1 1 1 2 0 3 1 1 1 3 0 3 0 3 1 0 1 3 0 3 3 0 3 1 0 0 0 0 0 1 Ex.3 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 47 37 64 42 25 43 75 33 60 51 32 57 24 41 43 39 72 21 36 29 26 67 55 44 27 29 51 43 49 37 23 50 30 35 70 33 27 59 26 55 43 49 68 30 1 0 1 0 0 1 0 1 0 0 1 0 0 1 0 1 0 1 0 1 0 0 0 0 1 1 0 0 0 1 0 0 1 0 0 1 1 1 0 0 1 0 0 0 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 0 1 0 1 0 0 1 0 1 0 0 1 1 0 0 1 0 0 1 1 1 0 1 0 1 0 0 1 0 0 1 1 1 0 1 0 1 1 1 1 1 0 1 0 0 1 0 1 0 0 0 0 1 0 0 1 0 1 1 0 1 0 1 1 1 1 1 0 1 0 0 1 0 Page 17 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 0 1 1 0 1 0 1 1 1 1 0 0 1 0 1 1 0 1 1 1 1 0 1 1 1 $48,800 $105,300 $90,600 $105,500 $17,900 $99,300 $17,600 $76,700 $65,900 $63,700 $93,000 $33,600 $27,500 $84,100 $48,700 $45,900 $70,700 $13,800 $100,800 $25,700 $27,000 $51,900 $37,800 $74,700 $14,800 $17,400 $59,900 $67,800 $135,700 $63,000 $21,900 $114,100 $22,900 $82,700 $103,300 $113,800 $54,500 $54,600 $18,900 $83,300 $60,200 $53,700 $89,000 $12,500 1 1 0 1 3 1 0 1 0 3 1 2 3 3 2 0 0 1 1 0 1 0 2 1 1 0 1 1 1 0 2 1 1 1 0 0 1 0 1 1 0 2 0 3 Ex.3 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 46 32 49 55 32 56 60 26 72 55 31 35 27 44 58 34 50 29 23 64 23 51 49 49 28 72 26 47 50 33 27 46 30 49 71 46 22 47 37 36 52 68 56 29 1 0 1 0 0 1 1 0 0 0 1 0 0 1 1 1 1 0 0 0 1 1 0 1 0 1 0 0 0 1 0 0 0 1 0 1 1 0 1 1 1 0 0 1 1 1 0 1 1 1 0 0 1 1 1 0 0 0 0 0 0 0 0 1 0 1 1 1 0 1 0 1 0 1 1 1 0 1 1 1 1 1 0 1 0 0 1 1 0 1 1 0 0 1 0 0 1 1 1 0 1 0 1 0 1 0 0 1 0 1 1 1 0 1 0 1 0 1 0 0 1 1 0 0 0 0 0 1 0 1 1 0 Page 18 1 1 1 0 1 0 1 0 0 0 0 1 1 1 0 1 1 1 1 1 1 0 0 0 1 0 1 1 1 1 1 1 1 0 1 1 1 0 1 1 0 1 1 0 $50,600 $67,900 $62,800 $34,600 $43,500 $80,700 $29,000 $27,600 $12,600 $88,600 $61,400 $40,200 $69,700 $53,300 $66,200 $54,400 $68,700 $25,100 $20,300 $118,800 $17,600 $88,700 $84,900 $89,500 $11,900 $65,500 $17,600 $82,400 $40,400 $70,000 $44,700 $47,900 $63,200 $86,100 $14,600 $62,900 $23,200 $52,600 $53,900 $100,100 $50,000 $97,000 $35,000 $39,600 3 3 3 2 1 0 0 1 2 1 1 1 2 0 0 0 0 1 2 0 0 2 1 0 1 0 2 2 1 0 1 1 0 1 0 0 0 2 1 2 1 0 0 0 Ex.3 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 69 74 34 51 29 26 45 21 23 43 31 41 31 65 29 21 51 28 47 21 74 40 21 23 24 38 26 52 29 62 24 26 55 68 59 42 21 36 45 49 26 34 32 32 0 1 1 0 0 0 1 1 1 1 0 0 1 0 0 0 1 0 1 1 0 1 0 0 1 1 1 1 0 1 0 1 0 1 0 0 1 0 1 1 0 1 0 1 0 0 1 0 0 0 0 0 0 1 1 0 1 1 0 0 0 1 0 0 1 1 1 1 0 1 0 0 0 1 1 0 0 1 1 0 0 1 1 1 0 0 0 1 1 1 1 1 0 0 0 0 1 0 1 0 1 1 0 0 1 0 1 0 0 1 0 0 0 0 1 0 1 0 1 0 1 1 0 0 0 1 1 0 0 1 0 1 Page 19 1 1 1 0 1 0 1 1 0 1 1 1 0 0 1 1 1 0 0 1 0 1 1 1 1 1 1 0 1 0 0 1 0 1 0 0 1 1 1 0 1 1 0 1 $46,900 $81,800 $99,200 $75,800 $14,500 $19,700 $43,200 $14,400 $43,500 $55,500 $108,100 $33,200 $98,900 $81,400 $20,100 $12,000 $79,500 $27,900 $70,500 $21,200 $42,600 $118,500 $15,600 $27,200 $26,100 $55,900 $27,400 $59,000 $37,100 $62,000 $68,000 $15,000 $45,400 $56,600 $16,300 $45,600 $14,200 $72,200 $126,500 $70,200 $13,500 $118,800 $39,000 $140,700 0 0 3 1 1 2 0 0 1 3 1 1 0 0 1 0 0 1 1 0 0 1 1 2 1 0 1 0 2 0 0 3 3 0 0 0 0 2 2 0 0 0 3 3 Ex.3 748 749 750 21 58 72 1 0 0 0 0 1 1 1 1 Page 20 0 1 1 $51,600 $39,700 $90,500 0 0 0 Ex.3 Previous Customer 1 1 0 1 0 1 0 1 0 1 1 1 1 0 0 1 1 1 0 1 1 0 1 0 1 0 1 1 0 1 1 1 0 0 1 0 1 1 0 1 1 1 1 Previous Spent $246 $1,622 $0 $536 $0 $856 $0 $2,400 $0 $1,869 $1,413 $2,214 $459 $0 $0 $767 $397 $1,338 $0 $789 $849 $0 $578 $0 $254 $0 $1,026 $1,488 $0 $1,975 $1,656 $479 $0 $0 $1,635 $0 $996 $1,106 $0 $732 $1,024 $1,188 $1,073 Catalogs 12 18 12 12 6 12 18 6 24 24 18 24 12 18 12 6 6 12 12 12 24 12 12 18 6 18 24 18 24 18 18 12 24 18 12 12 12 12 6 6 12 18 18 Amount Spent $218 $2,632 $3,048 $435 $106 $759 $1,615 $1,985 $2,091 $2,644 $1,211 $3,120 $416 $1,773 $1,517 $534 $200 $1,220 $229 $1,052 $933 $1,186 $830 $406 $157 $589 $1,424 $2,479 $2,749 $2,279 $1,714 $678 $414 $932 $2,290 $774 $827 $1,274 $619 $833 $1,293 $1,699 $1,566 Page 21 Ex.3 1 1 1 0 1 1 0 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 1 0 1 1 0 1 1 0 1 1 1 1 0 1 1 1 0 1 1 1 1 1 $1,361 $2,232 $462 $0 $409 $722 $0 $423 $567 $378 $430 $1,936 $660 $0 $1,306 $633 $764 $0 $600 $714 $1,740 $1,766 $903 $0 $1,264 $1,248 $0 $1,498 $1,083 $0 $1,095 $453 $495 $320 $0 $1,640 $953 $590 $0 $1,128 $918 $439 $3,300 $1,260 24 6 6 18 24 12 6 6 18 6 18 18 12 6 18 24 6 18 6 12 24 12 12 12 24 24 18 12 18 18 6 6 24 12 6 18 18 12 6 12 24 6 24 24 Page 22 $2,265 $1,893 $297 $1,594 $879 $438 $963 $224 $536 $241 $445 $2,299 $736 $1,006 $1,443 $679 $526 $393 $357 $801 $1,594 $2,104 $530 $230 $1,932 $1,690 $2,450 $1,474 $1,811 $747 $490 $348 $991 $410 $1,175 $1,800 $1,023 $581 $236 $794 $1,645 $358 $5,564 $1,910 Ex.3 1 1 1 0 1 0 1 1 1 1 1 0 1 0 1 1 0 0 0 1 0 1 1 0 1 1 0 1 0 1 1 1 1 1 1 1 0 1 0 1 0 1 1 1 $1,236 $1,066 $210 $0 $505 $0 $374 $914 $163 $1,922 $360 $0 $2,418 $0 $606 $2,498 $0 $0 $0 $3,861 $0 $730 $268 $0 $1,152 $438 $0 $1,282 $0 $1,164 $1,800 $1,368 $836 $201 $1,094 $1,239 $0 $790 $0 $831 $0 $1,068 $1,156 $591 24 24 6 12 24 12 12 18 12 6 6 18 24 18 18 18 6 6 12 24 18 24 18 6 18 12 6 24 24 18 18 18 6 12 24 24 6 12 24 6 24 12 24 18 Page 23 $1,156 $1,598 $105 $449 $500 $546 $289 $724 $172 $1,588 $390 $1,405 $2,840 $915 $1,062 $4,109 $163 $1,252 $1,224 $3,995 $2,681 $1,140 $424 $941 $1,061 $276 $202 $1,595 $3,168 $981 $1,926 $1,155 $538 $143 $1,404 $1,985 $2,070 $1,006 $3,079 $586 $2,555 $638 $1,149 $580 Ex.3 1 1 1 0 0 1 1 1 0 1 1 0 1 0 0 0 1 1 0 1 1 0 0 0 1 0 0 0 0 1 1 1 1 1 1 1 0 1 0 0 1 1 1 1 $462 $327 $1,425 $0 $0 $1,575 $650 $1,332 $0 $106 $1,126 $0 $513 $0 $0 $0 $182 $115 $0 $1,110 $912 $0 $0 $0 $1,674 $0 $0 $0 $0 $1,696 $855 $2,103 $266 $850 $459 $1,014 $0 $840 $0 $0 $2,652 $1,744 $1,067 $407 6 24 6 24 24 24 24 18 6 12 6 18 12 6 12 18 6 6 6 18 18 24 12 6 24 18 18 6 12 18 18 24 24 24 24 18 12 6 12 24 18 18 6 12 Page 24 $466 $407 $847 $2,437 $400 $2,038 $716 $1,177 $826 $114 $873 $1,215 $548 $964 $1,694 $2,101 $90 $79 $412 $858 $1,388 $571 $1,127 $199 $3,344 $1,999 $1,073 $633 $436 $2,624 $895 $2,362 $245 $918 $645 $1,172 $324 $530 $1,826 $517 $3,632 $1,274 $607 $268 Ex.3 0 1 1 0 1 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 0 1 0 1 1 1 1 1 0 0 1 1 0 1 1 1 1 0 1 $0 $491 $704 $0 $2,523 $0 $497 $198 $73 $1,099 $1,895 $1,509 $351 $364 $222 $0 $2,256 $1,918 $880 $890 $872 $0 $468 $932 $470 $0 $2,112 $0 $393 $2,178 $346 $1,557 $672 $0 $0 $813 $1,986 $0 $199 $738 $481 $234 $0 $1,656 18 6 12 12 18 6 18 12 6 12 6 24 18 18 18 12 12 24 6 24 12 6 6 24 6 24 18 18 12 12 6 18 12 18 18 6 24 18 12 18 12 12 12 24 Page 25 $1,153 $474 $607 $827 $2,710 $451 $613 $227 $47 $870 $1,888 $2,838 $540 $506 $275 $1,757 $1,861 $2,585 $524 $1,175 $1,047 $260 $348 $906 $357 $1,639 $2,610 $581 $381 $1,841 $166 $1,492 $573 $1,611 $982 $486 $2,057 $3,278 $238 $721 $316 $193 $476 $3,010 Ex.3 1 1 1 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 1 1 0 1 0 1 1 1 1 $614 $658 $794 $0 $405 $962 $210 $650 $1,372 $906 $3,918 $1,462 $476 $0 $804 $1,112 $1,560 $1,590 $0 $0 $1,500 $962 $1,073 $1,712 $627 $1,668 $1,094 $698 $0 $531 $246 $23 $633 $0 $0 $2,019 $1,064 $0 $353 $0 $602 $884 $1,962 $1,416 18 18 18 12 18 18 18 24 18 6 18 6 6 24 24 6 18 12 24 18 24 18 24 24 12 18 24 24 12 12 12 6 18 24 12 12 12 12 12 6 6 24 18 12 Page 26 $962 $578 $1,011 $2,047 $622 $1,332 $232 $883 $1,342 $791 $3,442 $1,582 $438 $2,316 $973 $984 $2,545 $1,651 $2,935 $458 $2,247 $961 $1,194 $3,380 $704 $1,786 $1,355 $829 $962 $472 $210 $123 $699 $513 $2,581 $2,136 $1,078 $1,647 $229 $1,544 $167 $704 $2,075 $929 Ex.3 0 0 0 0 1 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 0 1 0 1 1 1 1 0 1 1 0 1 1 0 0 1 1 1 0 1 $0 $0 $0 $0 $340 $0 $0 $0 $94 $619 $975 $501 $166 $1,057 $1,773 $801 $438 $1,533 $726 $14 $0 $0 $318 $2,326 $0 $131 $0 $374 $1,163 $1,877 $720 $0 $1,153 $1,442 $0 $1,251 $1,013 $0 $0 $1,796 $117 $2,576 $0 $904 18 18 6 12 18 6 6 18 6 6 6 24 6 18 12 6 6 18 6 6 6 24 6 24 12 12 6 18 6 12 6 18 6 6 6 6 12 6 12 12 24 24 6 24 Page 27 $1,422 $1,197 $707 $865 $342 $617 $1,408 $2,729 $183 $193 $450 $576 $143 $1,640 $1,512 $624 $202 $1,634 $264 $158 $192 $570 $173 $3,069 $2,216 $304 $186 $659 $966 $1,485 $673 $2,784 $726 $880 $2,191 $666 $642 $836 $2,766 $927 $326 $2,666 $521 $1,417 Ex.3 0 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 0 1 1 0 1 0 0 1 1 1 1 0 1 0 0 1 0 0 0 0 0 1 1 0 1 0 1 0 $0 $1,069 $258 $886 $2,428 $1,165 $123 $1,715 $0 $169 $1,335 $1,828 $57 $1,573 $0 $2,121 $0 $606 $951 $0 $275 $0 $0 $115 $1,327 $568 $1,784 $0 $1,295 $0 $0 $846 $0 $0 $0 $0 $0 $794 $898 $0 $1,029 $0 $1,022 $0 18 12 6 18 24 18 12 18 18 12 12 6 24 18 12 24 12 6 12 12 12 18 6 12 24 18 18 6 18 12 12 18 12 12 12 6 6 24 12 24 24 6 18 6 Page 28 $902 $950 $161 $867 $3,671 $966 $216 $1,546 $3,916 $515 $1,365 $753 $308 $1,968 $1,297 $2,723 $312 $495 $841 $414 $307 $3,505 $1,351 $147 $1,857 $503 $1,578 $798 $2,837 $583 $952 $705 $1,500 $1,162 $329 $780 $1,583 $968 $794 $2,595 $1,037 $989 $848 $1,552 Ex.3 0 0 1 0 1 1 0 1 1 1 0 0 1 0 1 0 0 1 0 0 1 1 1 1 1 1 1 1 1 1 0 0 0 1 1 0 1 1 0 1 0 1 1 1 $0 $0 $306 $0 $1,624 $1,880 $0 $1,609 $1,201 $2,963 $0 $0 $1,345 $0 $1,603 $0 $0 $1,352 $0 $0 $1,673 $935 $930 $1,395 $330 $928 $105 $2,410 $1,347 $461 $0 $0 $0 $1,767 $461 $0 $1,755 $1,607 $0 $168 $0 $1,129 $57 $1,930 12 18 24 24 18 24 24 18 18 12 18 18 12 18 24 6 24 24 6 24 6 18 6 6 6 24 18 18 18 18 12 24 6 24 12 12 18 18 18 18 12 18 6 18 Page 29 $422 $4,984 $504 $1,634 $2,419 $2,258 $2,098 $1,688 $2,444 $2,408 $384 $1,021 $979 $2,243 $1,909 $821 $2,321 $2,035 $192 $1,213 $859 $2,436 $319 $565 $127 $1,263 $269 $2,510 $1,418 $737 $1,557 $2,705 $1,212 $1,984 $371 $329 $1,956 $1,648 $512 $280 $1,081 $1,009 $233 $5,151 Ex.3 1 1 0 1 1 1 1 1 1 0 1 1 1 1 0 1 1 1 1 0 0 1 1 1 1 0 1 1 0 1 1 1 0 1 0 1 1 1 0 1 1 1 1 1 $1,046 $1,782 $0 $313 $85 $408 $2,324 $1,311 $632 $0 $655 $1,239 $741 $380 $0 $1,882 $1,004 $466 $747 $0 $0 $35 $1,027 $2,247 $1,591 $0 $1,571 $1,307 $0 $879 $1,518 $58 $0 $1,551 $0 $1,059 $1,718 $285 $0 $2,763 $234 $1,697 $2,586 $1,634 6 12 12 24 12 12 24 24 24 24 6 18 12 12 12 6 12 6 12 18 6 6 24 24 12 12 24 6 18 12 18 6 24 18 24 24 12 12 6 18 12 24 18 18 Page 30 $304 $1,699 $1,748 $344 $108 $418 $2,339 $1,622 $938 $1,631 $661 $1,217 $448 $586 $567 $871 $829 $421 $886 $1,666 $326 $182 $1,252 $5,503 $2,318 $452 $3,230 $213 $1,344 $844 $1,543 $93 $1,355 $1,790 $788 $1,104 $1,420 $472 $1,014 $3,596 $295 $1,821 $3,398 $2,537 Ex.3 0 0 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 0 1 0 0 0 1 1 1 1 1 1 0 1 1 0 1 1 1 1 1 1 0 0 0 0 0 1 $0 $0 $1,369 $225 $1,880 $696 $309 $1,700 $0 $509 $269 $90 $0 $1,585 $946 $1,123 $976 $0 $927 $0 $0 $0 $1,893 $442 $452 $714 $2,146 $185 $0 $1,584 $1,281 $0 $929 $766 $383 $48 $794 $1,769 $0 $0 $0 $0 $0 $250 18 24 12 24 24 18 6 24 24 12 6 6 18 12 12 12 24 12 24 18 12 6 18 12 6 12 18 6 6 24 24 24 24 12 12 6 6 18 6 12 18 24 12 12 Page 31 $1,480 $365 $869 $550 $2,844 $636 $201 $2,842 $1,087 $940 $210 $107 $857 $1,162 $1,029 $909 $905 $2,224 $983 $2,381 $468 $643 $2,328 $345 $371 $574 $1,513 $172 $521 $2,163 $1,348 $1,608 $646 $769 $286 $183 $757 $1,237 $856 $275 $3,537 $1,479 $341 $328 Ex.3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 0 1 1 1 0 1 1 1 0 $677 $2,137 $1,052 $1,246 $1,262 $36 $1,184 $1,356 $1,146 $1,122 $1,460 $2,191 $2,011 $1,221 $378 $1,538 $50 $1,457 $0 $0 $130 $2,001 $1,391 $924 $0 $2,219 $390 $947 $1,719 $2,030 $645 $1,453 $455 $0 $1,138 $0 $2,191 $1,273 $1,358 $0 $2,103 $1,077 $525 $0 18 18 12 24 24 6 6 6 18 24 24 24 18 18 6 24 6 12 18 24 12 24 12 18 18 18 18 12 12 18 6 12 12 18 12 6 24 12 12 24 18 24 18 12 Page 32 $381 $1,813 $777 $2,177 $1,078 $158 $755 $1,481 $1,184 $1,472 $1,856 $2,636 $3,604 $881 $239 $2,090 $321 $1,084 $1,310 $2,452 $268 $2,149 $979 $1,587 $774 $1,779 $865 $922 $1,475 $2,924 $247 $2,104 $392 $1,850 $850 $510 $2,491 $782 $1,081 $2,702 $3,655 $2,098 $862 $1,541 Ex.3 1 1 1 0 1 1 1 0 1 1 1 1 0 1 1 1 1 1 1 0 0 0 1 1 0 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 1 1 0 0 $916 $892 $984 $0 $717 $1,362 $1,731 $0 $1,739 $392 $1,814 $977 $0 $489 $715 $64 $49 $1,373 $82 $0 $0 $0 $972 $67 $0 $1,703 $781 $1,195 $2,563 $367 $1,663 $169 $1,436 $2,210 $1,245 $0 $1,486 $0 $760 $1,708 $1,552 $749 $0 $0 12 18 24 18 18 24 12 12 24 12 12 18 18 18 12 6 12 12 6 12 12 6 24 24 6 12 18 24 24 6 6 18 24 12 18 6 6 6 24 24 24 12 24 6 Page 33 $592 $1,398 $1,093 $1,369 $886 $2,524 $1,693 $1,473 $1,822 $457 $2,226 $2,177 $1,166 $855 $584 $209 $87 $1,457 $274 $927 $1,584 $529 $621 $405 $1,705 $1,384 $498 $2,492 $2,925 $470 $1,046 $576 $1,241 $2,458 $1,838 $176 $647 $921 $1,583 $2,764 $1,944 $824 $1,320 $818 Ex.3 0 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 0 1 1 1 1 1 1 1 0 0 1 0 1 0 1 0 0 1 0 1 0 1 1 1 0 1 $0 $1,595 $1,104 $894 $526 $1,349 $223 $1,634 $1,062 $2,402 $18 $1,023 $1,319 $0 $0 $2,025 $1,590 $144 $0 $43 $1,003 $1,338 $2,375 $669 $2,002 $80 $0 $0 $1,428 $0 $1,145 $0 $988 $0 $0 $878 $0 $2,050 $0 $1,106 $857 $1,765 $0 $36 12 24 6 6 12 24 6 24 18 24 6 18 12 18 12 18 6 6 12 6 24 18 24 18 24 6 24 12 18 6 12 24 6 6 6 24 24 24 24 24 6 12 12 18 Page 34 $491 $1,476 $708 $264 $322 $3,052 $188 $3,384 $742 $6,217 $216 $2,034 $1,955 $1,598 $576 $3,785 $1,116 $236 $2,523 $43 $920 $1,357 $5,830 $655 $2,438 $223 $947 $1,473 $1,659 $614 $1,001 $1,314 $446 $307 $1,138 $639 $2,904 $3,491 $1,692 $1,507 $685 $1,877 $1,804 $403 Ex.3 1 0 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0 1 0 1 0 0 0 1 1 1 1 0 0 1 1 0 1 1 1 1 1 0 1 0 $751 $0 $2,081 $1,624 $39 $1,510 $254 $1,271 $1,195 $580 $1,486 $628 $0 $0 $356 $783 $1,486 $695 $1,661 $1,030 $0 $1,420 $0 $1,469 $0 $0 $0 $999 $2,069 $1,567 $545 $0 $0 $1,224 $2,140 $0 $277 $1,027 $456 $926 $2,096 $0 $1,627 $0 24 24 24 6 6 12 6 24 24 12 24 12 12 6 12 12 24 12 24 18 24 12 12 6 12 12 6 6 24 18 24 24 12 18 24 12 18 24 6 24 24 12 12 12 Page 35 $1,271 $3,360 $3,167 $1,781 $62 $1,504 $224 $1,431 $1,436 $364 $2,644 $805 $571 $1,352 $528 $716 $2,150 $368 $1,789 $907 $1,012 $1,148 $1,185 $704 $376 $332 $613 $680 $2,746 $2,107 $486 $1,976 $814 $1,753 $3,378 $3,273 $1,001 $1,246 $184 $2,574 $2,304 $1,194 $1,487 $206 Ex.3 0 1 1 1 1 0 1 1 1 1 1 0 1 1 0 1 1 0 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 0 1 1 0 0 0 1 0 $0 $842 $22 $579 $446 $0 $289 $841 $496 $1,838 $1,144 $0 $797 $1,148 $0 $1,156 $1,490 $0 $89 $2,340 $0 $1,510 $1,824 $2,333 $120 $1,958 $103 $660 $462 $1,162 $920 $722 $1,355 $0 $404 $0 $0 $714 $727 $0 $0 $0 $935 $0 6 12 6 18 12 18 6 24 12 18 24 12 6 18 6 6 24 6 12 18 6 24 24 24 6 24 18 18 24 24 6 24 24 12 24 24 24 12 6 6 6 24 6 12 Page 36 $713 $356 $177 $748 $500 $3,034 $482 $893 $164 $2,563 $1,575 $881 $584 $1,720 $1,024 $1,150 $2,763 $421 $180 $2,176 $273 $2,693 $3,072 $5,209 $143 $1,931 $163 $657 $630 $1,974 $502 $662 $1,512 $1,255 $468 $2,561 $534 $1,307 $735 $1,597 $1,079 $2,599 $473 $1,085 Ex.3 1 1 0 1 1 1 0 0 1 1 1 0 0 1 1 1 1 0 0 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 $780 $1,703 $0 $1,887 $19 $396 $0 $0 $1,218 $184 $2,219 $0 $0 $2,354 $2 $12 $910 $0 $0 $0 $1,311 $1,450 $111 $73 $0 $815 $56 $1,870 $48 $1,613 $1,901 $32 $781 $0 $482 $2,009 $123 $851 $1,875 $2,095 $293 $2,348 $508 $2,059 6 6 12 12 6 6 24 24 12 18 12 6 18 24 12 6 18 12 24 12 24 24 6 18 6 12 6 24 24 24 24 6 24 24 6 12 6 18 18 12 18 12 6 12 Page 37 $703 $919 $2,796 $1,830 $183 $330 $917 $615 $808 $427 $1,133 $320 $3,126 $3,001 $271 $140 $1,763 $576 $2,145 $417 $1,790 $3,063 $136 $446 $494 $964 $278 $3,044 $653 $3,293 $3,688 $38 $1,203 $1,607 $317 $1,322 $250 $715 $2,000 $1,702 $296 $2,631 $292 $1,001 Ex.3 0 1 1 $0 $480 $2,093 12 12 6 Page 38 $1,082 $573 $863 Employee 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Education 3 1 1 2 3 3 3 3 1 3 3 2 2 2 3 3 3 2 3 2 3 2 1 2 3 3 2 1 1 2 1 1 3 2 2 1 3 2 1 3 3 1 5 3 1 Grade 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Years1 3 14 12 8 3 3 4 8 4 9 9 8 9 10 4 3 6 8 5 4 4 3 5 3 3 3 16 13 12 4 7 11 3 18 14 19 3 2 11 3 5 15 7 12 18 Years2 1 1 0 7 0 0 0 2 0 0 2 8 0 6 0 0 0 9 6 3 2 3 0 4 1 1 6 0 6 7 4 0 8 2 0 0 2 4 0 2 1 0 0 1 0 Age 26 38 35 40 28 24 27 33 62 31 34 37 37 58 33 27 30 37 44 29 36 28 45 33 24 27 60 48 40 33 35 44 43 46 42 47 25 30 40 26 32 51 35 37 44 Gender Male Female Female Female Male Female Female Male Female Female Female Female Female Female Female Female Female Female Female Female Female Male Female Male Male Male Female Female Female Female Female Female Male Female Female Female Female Female Female Male Female Female Female Female Female PC Job No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No Yes No No No No No Yes No No Salary $32,000 $39,100 $33,200 $30,600 $29,000 $30,500 $30,000 $27,000 $34,000 $29,500 $26,800 $31,300 $31,200 $34,700 $30,000 $31,000 $27,000 $29,600 $32,600 $29,600 $29,500 $31,000 $28,500 $26,700 $30,750 $29,500 $42,200 $37,600 $34,000 $33,000 $28,760 $35,400 $31,000 $38,800 $34,300 $35,000 $34,600 $28,500 $29,500 $30,500 $34,200 $43,600 $33,500 $33,000 $45,300 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 1 1 3 1 2 1 1 2 1 3 3 2 1 1 3 2 2 3 5 3 2 1 3 1 3 1 1 5 3 2 2 5 3 2 5 3 5 1 2 5 1 2 5 5 5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 17 10 5 15 2 3 4 7 8 15 9 16 8 9 18 3 6 4 5 4 7 11 5 17 3 5 9 3 4 16 9 3 4 8 8 6 4 3 12 3 8 6 3 4 3 15 15 3 0 10 0 0 3 10 0 0 1 0 0 0 0 0 8 3 0 1 4 4 8 4 5 1 9 0 3 0 0 10 0 0 0 0 0 4 9 18 5 0 7 1 0 2 1 0 53 40 51 42 53 58 44 31 64 47 37 46 55 39 51 37 30 26 41 34 57 53 32 44 25 31 50 47 35 43 46 35 22 58 40 30 29 31 52 33 49 34 26 28 35 47 51 Male Female Male Female Female Male Female Female Female Female Female Female Female Female Female Female Male Female Female Female Male Female Female Female Male Female Female Female Male Female Female Male Male Female Female Female Female Female Male Male Female Female Male Male Female Female Female No No No No No No Yes No No No Yes No No No No No No No Yes Yes No No Yes No No No No Yes No No No No No No No No No Yes No No No No No No No Yes No $38,800 $29,900 $31,200 $34,000 $30,450 $35,500 $34,000 $29,100 $29,650 $29,200 $29,800 $33,500 $34,000 $29,600 $34,000 $37,250 $33,000 $28,600 $36,000 $37,300 $29,900 $31,500 $41,400 $32,740 $33,500 $32,000 $30,800 $42,000 $34,000 $32,500 $31,700 $36,500 $33,000 $31,200 $34,000 $33,000 $33,900 $39,000 $34,920 $39,000 $34,000 $31,900 $37,000 $34,000 $36,400 $38,200 $35,300 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 3 3 4 5 4 3 1 3 1 2 3 2 5 3 5 3 3 2 3 4 3 3 5 5 3 4 3 3 2 2 3 5 2 3 2 5 3 5 5 3 1 1 5 2 5 3 4 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 12 2 8 5 5 11 4 9 14 4 15 7 5 7 7 4 10 5 11 9 4 5 4 5 6 6 5 9 5 3 4 7 8 12 3 4 3 3 8 21 16 5 25 6 21 6 2 0 2 0 0 0 0 3 0 0 5 5 3 0 2 0 12 0 5 4 7 8 6 0 0 0 0 0 0 4 2 0 5 2 6 1 0 0 5 0 0 6 0 10 1 9 5 26 33 27 34 29 27 43 36 38 60 43 48 32 31 29 35 37 43 33 58 44 37 48 26 25 38 41 29 59 29 27 30 34 35 50 33 26 36 33 47 51 42 31 62 46 60 43 Male Female Male Female Female Male Female Female Female Female Female Female Female Male Female Female Female Female Female Female Female Female Female Male Female Female Female Male Female Male Female Female Female Female Female Female Female Female Female Female Female Female Male Female Male Female Male No No No Yes No No No No No No Yes No No No No No No No No Yes No Yes No No No No No No No No Yes No No No No No No No Yes No No No No No No No No $34,500 $30,500 $30,000 $37,300 $40,200 $35,500 $35,000 $38,000 $35,300 $34,100 $43,200 $36,100 $34,600 $36,000 $36,200 $37,500 $41,000 $35,600 $39,800 $41,300 $42,500 $45,800 $34,900 $41,500 $38,000 $35,000 $40,000 $36,000 $33,700 $36,300 $38,000 $39,500 $36,300 $32,500 $37,000 $32,600 $36,000 $35,000 $43,600 $33,800 $35,300 $42,400 $39,500 $43,500 $42,000 $40,300 $44,000 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 1 3 5 5 4 5 5 5 5 5 5 5 5 1 5 5 5 2 3 5 1 3 5 3 3 3 5 1 5 3 3 2 3 2 5 5 5 5 3 5 5 3 5 5 5 5 5 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 25 13 6 7 8 5 5 4 6 6 5 7 5 13 6 7 6 15 17 4 23 5 3 19 26 6 15 12 9 14 16 16 11 13 7 8 8 6 17 8 8 8 16 6 7 8 12 2 1 5 0 3 3 3 1 3 0 4 3 1 9 0 0 2 4 0 0 0 4 12 8 0 4 0 4 0 1 0 1 0 2 0 0 0 10 4 2 0 5 5 2 0 4 2 53 38 39 35 40 32 33 30 37 30 32 37 29 50 29 32 31 47 44 27 55 52 50 59 47 43 41 39 39 40 49 53 37 40 34 37 31 41 46 37 33 35 49 33 31 49 40 Female Female Female Female Female Female Male Male Male Male Female Female Male Female Male Female Male Female Female Male Male Male Female Female Female Male Female Female Female Female Female Female Female Female Male Female Male Male Female Male Male Female Female Male Male Male Female No No No No No No No No No No No No No No No No No No No No No No No Yes No No No Yes No Yes No No No No No No No No No No No No No No No No No $40,660 $39,700 $45,000 $43,900 $38,000 $39,020 $44,500 $41,000 $44,000 $44,000 $42,500 $40,260 $44,500 $35,500 $42,500 $44,000 $45,000 $44,400 $38,000 $41,800 $45,500 $42,500 $44,000 $54,300 $44,800 $47,000 $43,800 $48,000 $42,700 $48,500 $42,000 $45,500 $44,500 $51,200 $47,500 $44,500 $47,000 $47,000 $43,100 $49,000 $48,500 $45,000 $52,500 $47,500 $48,000 $46,500 $61,500 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 5 5 4 5 5 5 3 5 5 3 5 5 5 5 5 4 5 3 5 5 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 6 6 6 6 6 6 9 12 16 11 9 16 24 17 14 13 19 12 20 20 22 21 39 34 36 32 35 33 2 2 0 1 6 7 3 1 0 0 4 0 0 1 0 0 0 0 0 0 0 0 37 46 43 36 37 40 54 57 49 41 59 51 45 56 57 53 65 60 61 62 59 62 Female Female Female Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female No No No No No No No No No No No No No No No No No No No No No No $50,000 $61,800 $43,000 $47,000 $58,500 $55,000 $57,000 $57,000 $60,000 $60,000 $59,000 $60,000 $65,000 $52,000 $58,000 $60,000 $74,000 $95,000 $97,000 $88,000 $94,000 $30,000 PUAD 630 Analytical Techniques in Public Administration Regression Part 2. Statistical Inference. Class Examples Replicate the class examples exactly as demonstrated in the class lecture. Pay equal attention to the accuracy of the analytical techniques you use to solve the problem and your interpretation of the results. Be sure to include textboxes/comments of your interpretation and conclusions for every piece of output generated. Submit your worked data in a single MS Excel Workbook. Create separate (appropriately labeled) worksheets within a single workbook for each example. Regression Part 2 PUAD 630 Class Examples Page | 2 Example 1. Bendrix has collected data for overhead costs, machine hours and the number of production runs corresponding to 36 months of production. Estimate the regression for overhead costs at Bendrix as a function of both machine hours and production runs. A. Interpret the point estimates and comment on the accuracy of the point estimates. B. Comment on if and why each explanatory variable should/should not be included in the regression equation. C. Run the usual multiple regression and check the graph of residuals versus fitted values. Check for lag 1 autocorrelation in two ways: with the DW statistic and by examining the time series graph of the residuals. D. Suppose Bendrix expects the values of Machine Hours and Production Runs for the next three months to be 1430, 1560, 1520, and 35, 45, 40, respectively. Predict Overhead at Bendrix for the next three months, given the anticipated values of Machine Hours and Production Runs. Example 2. Simulation is used to generate a hypothetical data set of heights and left and right foot lengths where height is approximately 31.8 plus 3.2 times foot length (all expressed in inches). Estimate a regression when both Right and Left are entered in the equation for Height and check for multicollinearity in your model. Regression Part 2 PUAD 630 Class Examples Page | 3 Example 3. The data include 750 customers who purchased mail-order products from a HyTex catalog. For each customer, data is available for:  Age of the customer  Gender  Whether they own their home  Whether they are married  Whether they live reasonably close to a shopping area that sells similar merchandise  Combined annual salary of customer and spouse (if any)  Number of children living with customer  Whether they purchased from HyTex during the previous year  Total amount of purchases made from HyTex during the previous year  Number of catalogs sent to the customer this year  Total amount of purchases made from HyTex this year A. Estimate a regression equation for Amount Spent based on all of these variables. B. Choose either the forward, backward, or stepwise procedure and interpret a regression equation for Amount Spent based on the included variables. Example 4. The data set includes the following variables for each of the 208 bank employees:  Education (categorical)  Grade (categorical)  Years1 (numerical. years with this bank)  Years2 (numerical. years of previous work experience)  Age (numerical)  Gender (categorical with two values)  PCJob (categorical yes/no for if employee's current job is primarily computer-related)  Salary (numerical) A. Run a regression analysis with Salary as the dependent variable, and Education, Years1, and Gender as explanatory variables. Also include an interaction variable to see whether the effect of Years1 is different across the two genders. Examine the data for any outliers using boxplots and scatterplots of the residuals versus the fitted values. B. If outliers are identified, rerun the regression without the outlier(s) and interpret the results. Comment on the effect of including/excluding the outlier(s). Regression Part 2 PUAD 630 Class Examples Page | 4
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

See attached 👍

13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74

A

B

C

Month
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

Machine Hours
1539
1284
1490
1355
1500
1777
1716
1045
1364
1516
1623
1376
1327
1178
1491
1667
1769
1104
1196
1794
1379
1448
1505
1420
1475
1118
1433
1589
1585
1493
1124
1536
1678
1723
1413
1390

Production Runs
31
29
27
22
35
30
41
29
47
21
37
37
49
50
37
41
34
44
46
29
38
32
32
42
27
34
58
26
32
33
36
28
41
35
30
54

D

Overhead
99798
87804
93681
82262
106968
107925
117287
76868
106001
88738
105830
88730
100624
98857
102622
108059
110054
91892
98693
110530
96883
99593
94564
105752
93224
75398
113137
85609
98498
101803
88371
102419
117183
107828
88032
117943

E

F

G

Dataset for prediction
Month
Machine Hours
37
38
39

H

I

Production Runs
1430
1560
1520

J

K

L

M

N

O

P

Q

predicted
35
45
40

97180.3549
111676.2659
105516.7204

SUMMARY OUTPU...


Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags