Question: please answer and show how to do this is excel. i pfovided the chart that's why theres alot of screenshots 4. The Excel data file

please answer and show how to do this is excel. i pfovided the chart that's why theres alot of screenshots

the chart that's why theres alot of screenshots 4. The Excel data

file titled ANOVA Examination Data provides 715 observations on variables X1, X2,

and X3. Answer each question below using Excel. You must turn in

your output. (10 points) a. Conduct a test at the 0.05 level

to see if the variance of X2 and X3 are equal. (5

points) b. Conduct a simple ANOVA test to see whether the means

of X1, X2, and X3 are equal. Conduct this test at the

0.05 level. How do the means differ? (5 points) bservation xi X2

X3 1 2.82 28.50 142.20 2 2.70 28.60 139.30 3 2.80 28.60

138.40 4 2.95 28.60 139.70 5 2.84 28.70 138.70 6 3.21 28.90

139.40 7 3.20 28.80 140.30 8 3.38 28.90 140.00 9 4,04 28.90

140.40 10 4.05 28.80 140.70 11 4.15 28.80 141.80 12 449 28.80

143.60 13 435 28 SC 143.30 14 3.96 28.50 139.80 15 3.31

28.80 138.50 16 3.23 28.80 139.70 17 3.29 28.80 137.60 18 2.46

28.80 137.90 19 2.30 28.70 138 90 20 2.30 28.70 139.40 140.50

21 2.45 28.80 22 2.30 28.80 34120 23 2.37 28.80 142.30 24

2.25 28.70 144.50 25 2.24 28.70 14450 26 2,42 28.70 141.00 27

2.39 28.70 140,10 25 2.29 28.70 1420 28 2.29 28.70 142.40 29

2.29 28.70 140.60 30 2.33 28.70 141.20 31 2.24 28.80 141.50 32

239 28.90 14140 33 2.28 29.00 143.10 34 2.30 29.10 144.40 35

2.48 29.20 146.30 36 2.60 29 30 149.20 37 2.72 29.40 148.90

38 2.73 29.50 145.60 39 2.72 29.60 144.60 40 2.73 29.80 146.20

41 2.69 29.80 144.50 42 2.73 29.80 144.80 43 2.92 29.90 145.00

4. The Excel data file titled ANOVA Examination Data provides 715 observations on variables X1, X2, and X3. Answer each question below using Excel. You must turn in your output. (10 points) a. Conduct a test at the 0.05 level to see if the variance of X2 and X3 are equal. (5 points) b. Conduct a simple ANOVA test to see whether the means of X1, X2, and X3 are equal. Conduct this test at the 0.05 level. How do the means differ? (5 points) bservation xi X2 X3 1 2.82 28.50 142.20 2 2.70 28.60 139.30 3 2.80 28.60 138.40 4 2.95 28.60 139.70 5 2.84 28.70 138.70 6 3.21 28.90 139.40 7 3.20 28.80 140.30 8 3.38 28.90 140.00 9 4,04 28.90 140.40 10 4.05 28.80 140.70 11 4.15 28.80 141.80 12 449 28.80 143.60 13 435 28 SC 143.30 14 3.96 28.50 139.80 15 3.31 28.80 138.50 16 3.23 28.80 139.70 17 3.29 28.80 137.60 18 2.46 28.80 137.90 19 2.30 28.70 138 90 20 2.30 28.70 139.40 140.50 21 2.45 28.80 22 2.30 28.80 34120 23 2.37 28.80 142.30 24 2.25 28.70 144.50 25 2.24 28.70 14450 26 2,42 28.70 141.00 27 2.39 28.70 140,10 25 2.29 28.70 1420 28 2.29 28.70 142.40 29 2.29 28.70 140.60 30 2.33 28.70 141.20 31 2.24 28.80 141.50 32 239 28.90 14140 33 2.28 29.00 143.10 34 2.30 29.10 144.40 35 2.48 29.20 146.30 36 2.60 29 30 149.20 37 2.72 29.40 148.90 38 2.73 29.50 145.60 39 2.72 29.60 144.60 40 2.73 29.80 146.20 41 2.69 29.80 144.50 42 2.73 29.80 144.80 43 2.92 29.90 145.00 44 2.82 30.00 4. 45 2.78 30.00 145.50 46 2.74 30.10 147.00 47 2.83 30.20 148.80 48 2.87 30.30 151.90 49 2.91 30.40 152.10 0 2.92 30.60 148.70 51 2.89 30.70 147.50 52 2.90 31.00 250.00 147 90 53 293 31.00 54 2.99 31.20 148,70 SS 3.18 - 149.90 56 3.32 127) 149.50 57 338 31.70 15100 3.45 3150 152 80 59 3.52 32.00 255.20 352 32.00 155.20 3.52 32.20 15750 3.52 32.30 157.90 3.53 32.40 153.90 63 3.54 32.60 153.10 3.47 32.70 155.20 3.48 32.90 152.70 3.48 33.20 153.90 3.46 33.20 155.50 3.50 33.40 155.50 3.53 33.60 157.80 357 33.80 159.70 $ 32 2 3 23 53 3 z 3.64 33.80 161.60 384 33.90 164.90 3.81 34.00 165 30 393 34 20 360.30 75 3.93 3430 159.90 76 3.93 34 40 162.60 3.89 3450 158.70 3.80 34.70 160 50 3.84 34.90 161.80 3.84 35.10 161 20 81 3.92 35.30 16390 82 403 35.60 366.50 4.09 35 80 168 20 84 438 36.00 17260 85 4.59 36.20 173.80 86 36 40 168.50 87 4.59 36 50 168.70 562 36.70 72.10 89 4.64 3700 168.00 90 4.50 37.00 170.00 480 37.20 91 169.20 92 496 37.40 168.30 37.50 171.10 93 537 37.70 171.60 94 535 95 17290 532 37.80 96 176.90 4.96 38.00 97 4.72 38.20 176,60 98 456 38.40 171.60 99 4.26 38.50 172.90 100 3.84 38.60 174.70 101 3.60 38.80 172.30 102 354 38.90 175 60 177.20 103 421 39.00 104 4.27 39.20 177.20 105 442 39.40 179.80 106 456 39.60 181.90 107 4.73 39.70 183 80 108 4.97 40.00 188.40 109 5.00 40.50 189.20 110 4.98 40.30 183.00 111 5.17 40.60 183.50 112 538 40.90 18730 113 5.66 41.00 184.60 114 552 4140 188.20 315 5.31 41.00 389 SO 5.09 116 41.SO 189.50 117 5.19 42.20 19190 118 5.35 42.40 194.20 119 545 42.70 197.50 120 596 43.00 202 80 121 6.14 203.10 43.10 122 6.12 43.40 19730 124 6.11 43.80 20150 125 6.04 43.90 197.40 126 6.44 44.20 200.20 127 7.00 44.50 201.20 128 6.98 44.70 199.50 129 7.09 44.90 201.20 130 7.00 45.20 202.90 131 7.24 45.50 205.00 132 7.82 45.70 209.30 133 787 46.00 210.80 134 7.13 46.10 202.00 135 6.63 46.30 203 50 136 6.51 46.50 208.10 137 6.84 46.90 204.30 138 6.68 47.20 206.90 139 6.45 47.40 208.10 140 6:41 47.60 208.00 141 6.12 47.90 210.80 142 591 48.10 212.30 143 5.25 48 30 214.50 144 4.87 48.60 220.10 145 4.44 48.90 220.40 146 3.70 49.20 214.30 147 338 49.40 21640 148 3.86 49.70 22140 149 4.14 50.00 218.80 150 4.75 50.40 222.90 151 5.40 50.90 225.10 152 4.94 5120 223.60 153 5140 22540 154 446 226 60 51.50 51 50 155 2280 155 4.22 51.80 228.80 156 4.01 52.00 234.50 157 3.38 5230 235.00 158 3.20 52.60 228.90 Mi 159 3.73 50 53.00 231.70 160 3.71 53.10 236.90 161 3.69 53.40 232.20 162 3.91 53.70 236.10 163 3.98 54.00 239.10 164 402 ero 5440 238.70 165 4.66 34.80 241.30 166 4.74 55.30 244.20 167 4.28 55.70 247.70 168 5.07 56.20 256,10 169 541 5660 256:40 170 580 56.90 24840 171 6.09 5720 248 80 172 6.26 57 NO 254.00 123 6.36 5810 250 80 174 7.19 58 50 2560 175 801 58 SO 258.10 176 8.67 59.10 255.00 172 8.29 59 60 256.50 178 7.22 59.90 25x30 179 783 6030 202.70 180 745 BOS 270.20 151 7.77 61.30 26860 182 7.12 61.80 183 796 26.10 26350 6210 184 833 63.00 2650 185 26530 156 63.00 63.70 64.10 7.90 755 167 268.30 270.10 188 8.96 64.70 268.10 189 8.06 65.20 269.70 190 7.46 65.80 271.70 191 7.47 66.50 275.70 192 7.15 67.00 281.80 193 6.26 67.40 278.50 194 5.50 67.80 269.90 195 5.49 68.40 272.90 196 5.61 68.50 277.70 197 5.23 69.10 27440 198 5.34 70.00 282.30 199 6.13 70.50 284.40 200 6.44 71.00 282.70 201 6.42 71.20 28430 202 5.96 71.70 284.90) 203 5.48 72.30 289.90 204 544 72.80 295 30 205 4.87 73.20 293.20 206 4.88 73.90 285.30 207 5.00 74.70 287.70 208 4.86 75.50 296.10 209 5.20 76.10 291-30 210 541 7600 295.60 211 5.23 77.10 298,40 212 5.14 77.60 297.10 213 5.ON 78.10 298.60 30290 214 4.92 78.60 215 4.75 79.10 305.70 216 4:35 29 50 314.30 217 4.62 80.20 313.60 213 4.67 1 304.90 219 4.00 8130 308.20 220 454 82.10 318.60 221 4.96 82.50 311.60 222 5.02 83.10 317.70 223 5.19 83.90 32220 224 5.49 84.50 320.20 225 5.81 85.20 323.70 226 6.16 85.90 327.90 227 6.10 86.60 331.40 228 6.07 87.40 340.00 229 6.44 88.00 33930 230 6.45 88.70 327.90 231 6.29 89.40 330.80 232 6.29 90.00 34340 233 641 90.80 338,20 234 6.73 9150 345.20 235 7.01 92.00 349,50 236 7.08 92.70 34750 237 7.85 93 60 352.70 238 7.99 9440 354.90 35850 239 864 95.20 240 9.08 96.00 367.90 241 9.35 96.80 363.30 242 9.32 97.40 357.70 243 9.48 98.00 356.10 244 9.46 37130 98.50 99.50 245 9.61 36220 246 906 100 30 371.90 247 9.30 1020 37840 245 9:52 202.10 376.90 249 10.26 103.10 380.50 2.50 11.70 103.90 352/60 251 11.79 104.30 384.40 252 12.04 104.80 393.20 253 12.00 106.00 390 40 254 12.86 106.70 380 80 255 15.20 10750 382.20 256 13.20 107.70 386.70 257 8.58 108.70 377 80 258 7.07 109.60 387.30 259 8.06 110.50 39460 260 9.13 111.70 398.30 261 10.27 112.40 404.70 262 11.62 113.40 410.70 263 13.73 15.49 11490 11530 415.80 419.50 264 265 15.02 115.30 416.40 266 14.79 405 50 OS 267 116.20 117.00 117.90 13.36 33.69 412.20 268 431.00 269 16.30 418.50 118.30 118.70 270 14.73 1495 422.80 427.70 221 119.50 272 1531 119.90 120.10 425.90 42700 273 14.70 274 1354 120.50 429.70 275 10.86 435.10 121.40 122.50 276 10.85 447.00 277 12:28 123.20 448.40 228 13 123.90 432.40 279 1268 435.60 09 12440 125.50 280 12.70 25110 281 12.09 126.20 340.90 282 1242 127.40 46.20 203 1105 449 50 32810 199.00 OR R US DIT 283 11.35 128.10 449.50 284 8.68 129.00 449.80 285 7.92 129.90 456.20 286 7.71 130.90 465.70 287 8.07 131.60 474 40 288 7.94 132.50 485.80 289 786 133.60 482.80 290 8.11 135.00 474 20 291 8.35 136.40 482.70 92 8.21 137.40 498.60 293 8.19 138.70 493.90 294 8.79 139.60 50350 295 91 140.60 510.50 296 9.34 141.40 508.20 297 9.00 142.70 511:40 298 8.64 144.10 517-20 299 8.76 145.30 521.80 300 9.00 146.20 53330 301 8.90 530.20 302 909 148.00 516.30 303 9.52 149.10 523.20 304 9.69 150.10 539.90 305 150.20 530.70 306 9.87 151.90 5410 307 10.12 152.70 34330 308 3047 153 50 539.00 309 1037 36 54250 310 9.74 154.70 542.20 311 8.61 312 8.06 156.10 366.60 313 7.76 156 80 561.10 312 8.06 156.10 564.60 313 7.76 156.80 561.10 314 8.27 157.90 551.90 315 8.52 158.50 558.00 316 795 159.30 575.10 317 7.48 160.40 569.30 318 6.95 161.70 585.20 319 708 162.80 592.00 320 7.14 164.20 594.90 321 7.10 165.10 602.00 322 7.16 166.10 605.30 323 7.24 167.00 614.90 324 7.10 167.70 633.30 325 7.07 168.40 626 60 326 7.06 169.40 612.80 327 6.56 370.70 624.30 328 6.06 17140 647.00 329 6.15 172.70 645.70 330 6.21 173.60 662.80 331 5.83 274.70 673.40 332 553 375.90 678.40 333 5.21 176.80 684.50 334 5.18 178.20 692.20 335 535 179.20 708,80 336 5.53 180.40 739.80 337 543 181.90 737.10 338 5.59 183.30 717410 339 5.59 184.00 723.10 340 5.64 185.30 752.00 341 5.66 18650 739 30 342 5.67 187.60 763 0 343 49 188.20 746.20 3444 604 190.00 744,20 344 6.04 190.00 744.20 345 6.40 191.40 744.50 346 6.13 193.10 753.20 347 5.69 195.20 755.50 348 5.77 196,70 765.40 349 5.81 197.90 764,20 350 5.66 198.90 744.50 351 5.70 200.20 751.60 352 5.91 201.80 777.90 353 6.26 203.20 763.40 354 6.46 204.60 778.50 355 6.73 206.10 785.50 356 7.06 207.10 781.00 357 7.24 208.60 739.70 358 7.35 209.70 780.80 359 7.76 210.70 786.90 360 8.07 212.00 803.10 361 8.27 212.90 792.10 362 8.53 213.50 775.60 363 8.82 214.70 774.60 364 8.65 215.30 790.20 766,10 365 8.43 216.30 366 8.15 217.20 80 367 ss 218.00 780.70 368 7.90 218.50 776.50 369 775 219.10 777.20 370 7.64 219.80 783.20 371 7.69 220.50 790.20 372 7.63 222.30 810.50 373 264 223.90 800.70 374 7.74 225.50 786.70 373 7.90 227 50 79450 376 7.77 229.40 816.20 377 7.74 231.20 795 50 378 7.73 233.30 809.00 379 7.62 235.50 811.00 380 745 238.40 812.70 381 7.36 241.40 817.10 382 7.17 243.50 816.10 383 7.06 245.00 824.60 384 6.74 246 50 842.70 385 6.22 250.60 831.70 386 5.94 253.50 822.10 387 591 255.70 833.70 388 5.65 255.70 851.90 389 5.46 256.50 840.30 390 557 257.60 856.70 391 5.58 259.10 860.90 392 5.33 260.90 863.20 393 5.22 262.10 865.40 394 4.99 263.70 874.00 395 4.56 265.50 892 30 396 4.07 267.10 915.60 397 3.80 268.60 916.40 398 3.84 270.20 915.10 399 404 27150 929.60 400 3.75 273.10 953.70 401 3.60 274.50 942.90 402 3.66 276.30 951.00 403 3.21 239,20 962.00 404 3.13 282.00 970.10 2.91 284.90 982.20 406 2.56 287.30 10000 407 3.13 . 1 10210 407 3.13 289.50 1021.40 408 3.22 292.10 1045.60 409 3.00 294.20 1039.80 410 2.93 296.10 1021.90 411 2.95 298.30 1030 SO 412 2.87 301.00 1057.40 413 2.96 303.80 1056 80 414 3.07 306.40 1071.80 415 3.04 309.40 1083.10 416 3.02 311.90 1088.10 417 2.95 314.90 1098.80 418 3.02 317.30 111160 419 3.10 319.10 1129.00 420 3.06 321.60 115330 421 2.98 324.90 114120 422 3.25 328.10 1123.80 423 3.30 331.10 1131.10 424 3.68 333.70 1152 20 425 336.80 1132.00 426 4.14 339.80 1141.80 427 15090 428 4.48 345.40 1144.30 429 4.62 347.70 1146.40 430 4.95 350 30 1149.90 431 5.29 353.00 1156.20 432 5.60 5.71 35. 357.40 1174.50 1159 50 434 5.77 358 50 3135 30 435 5.73 362 20 1139.30 436 5165 5. Sta 116030 437 3.67 1234.00 438 547 367.90 114100 439 368 20 115.70 440 5.40 368.80 1139.30 441 5.28 369.80 1138.40 442 5.28 370.90 1132.90 443 5.36 371.50 1138.60 444 5.14 372.80 1152.70 445 5.00 373 30 1130.20 446 4.83 372.40 1105.80 447 4.96 374.90 1118.00 448 4.95 376.10 1131 80 449 5.02 377.70 1105.90 450 5.09 380.20 1115.00 451 5.15 383.10 1110.70 452 S.OS 385.70 1097.70 453 5.09 387.90 1091.70 454 4.99 389.90 1078 40 455 5.03 392.20 1087.40 456 4.91 394 60 1105.80 457 5.03 396.80 1087.90 458 5.01 398 80 1066 80 459 5.14 401.50 1069.20 460 5.16 403.30 1074.50 461 5.05 406.20 1054.70 462 4.93 408 50 1064.30 463 5.05 410.80 1065.80 464 5.14 413.20 1069.10 465 4.95 415.50 1059 50 466 4.97 418.20 1057.60 467 5.14 421.80 1074.10 468 5.16 625.30 109350 469 50 427.50 1060.20 420 5.09 450.00 1066 30 471 503 431.90 1075 90 492 8770 471 5.03 43190 1075.90 472 4.95 433.80 1087.70 473 5.00 436.10 1070.80 474 4.98 438.70 1075.20 475 4.96 442.20 1074.20 476 4.90 44480 1069.30 477 4.61 449.80 1070.60 1077.40 478 3.96 453.70 479 4.41 45720 1098.00 480 4.39 460.40 1121.20 481 4.34 463.40 1103.90 482 4.44 467.40 1085.20 483 4.44 471.60 1097.50 484 4.29 475.70 1113.60 485 4.50 480.00) 3096.40 486 4.57 48340 1098.20 487 4.55 487.10 -1097 20 488 4.72 490.50 1092.80 489 4.68 49450 1086.20 490 4.86 499.20 1095.10 491 507 505.30 1113.00 492 5.20 517.90 1148.20 493 532 524.90 11 26.90 494 335 518.00 1097.40 495 569 516,90 1108.90 496 5.66 517.90 1125.70 497 5.79 519.10 1100.40 498 5.69 521.20 1101.80 1102 80 499 5.96 522.60 500 609 522.80 109450 501 6.00 524.10 3088.80 502 6.11 3 526,20 503 1092 20 1192.10 6.17 528 30 Vio 5.77 $31.30 504 1111.70 SOS 5.15 534.10 1100.40 506 488 536.70 1089 80 507 4.42 1111. 20 539.30 542.70 1126.70 SOS 387 509 362 545.80 1114.70 510 349 548.70 1126 30 554 40 351 1139.70 511 512 3.36 562.40 114450 264 513 1193.60 56780 $14 2.16 571.60 1159.20 515 187 575.80 1169.00 516 1.69 1208.50 1191.80 517 581.20 586.60 591.30 595.40 1178.30 518 1.65 1.72 1.79 1.71 1.73 519 1196.50 520 599.50 1196.90 521 604.90 522 1.70 610.20 1186.00 1994.70 1200 40 523 1.68 615 40 524 1.62 616.90 118230 525 163 618.20 1185.80 526 158 620.00 1196.60 527 1.23 622.50 1205-30 528 1.19 626.20 1245.50 529 1.17 630.10 122550 530 1.17 635.00 3225.50 531 1.13 639.40 1245.10 532 1.13 643.00 1259.50 533 3.07 645 80 1266.60 534 0.92 647.40 1284.70 535 0.90 54830 2287 90 532 1.13 643.00 1259 60 533 1.07 645.80 1266.60 534 0.92 647.40 1284.70 535 0.90 648 30 1287.90 536 095 650.20 1292.20 537 0.94 652.70 1286.20 538 0.92 657.40 1288.80 539 0.93 660.00 1293.90 540 0.90 662.50 133250 541 0.88 663.80 1303 80 542 0.93 665.40 1306.70 543 0.94 666.90 1337.90 544 0.94 669.80 134320 545 1.02 673.10 1333.40 546 1.27 677.60 1347.70 547 1.33 685.40 1338.80 548 1.48 686.80 1352.60 549 1.65 690.40 13-49.10 550 1.76 693.50 1351.40 551 207 697 80 137) DO 552 2.19 697 80 1401 50 353 2.33 698.90 1361 50 554 254 200.40 1355.00 555 2.74 702.00 556 2.78 1381.70 1369 40 203.40 557 284 704.60 1369.50 558 2.92 708.20 1384 30 559 3.22 710.60 236540 560 3:44 73340 1376.90 561 342 717.20 1363.50 562 3.71 718.40 1365.40 563 3.85 720:50 1375 60 564 389 724.60 1393:20 565 4.24 729.30 1375.50 566 4.43 733.20 1362.00 567 1394.70 451 735.60 568 4.60 738 20 1393.60 569 4.72 741.30 1392.10 570 4.79 740.80 1379.00 571 495 740.80 1368.60 572 4.96 742.10 1370.60 573 481 742.60 134740 574 4.92 743.70 1360.30 575 4.94 746,60 136850 576 485 750.20 1387.70 4.98 750.70 1369.00 578 503 750.00 1347.50 579 494 750.80 1378 40 580 4.87 753.70 1392.30 581 4.73 755.30 1385.60 582 4.61 755.70 1370.80 583 4.82 758.10 1368.60 584 4.20 759.00 1372.80 3.89 760.20 1356.30 586 390 762.90 1369.40 587 3.27 762.70 1370.50 588 3.00 760.60 1394 90 589 2.75 758.30 1375.90 590 2.12 757.40 1365.90 591 1.26 759.20 3401.10 592 1.29 758.20 1406.60 593 1.73 762.40 3396.50 594 1.86 768 50 1407.30 595 160 774.80 1417.70 596 1.72 776.80 3401.30 597 1.13 780.90 144130 598 0.67 796.70 1462160 665 0.19 806 40 1513.70 009 0.03 816.20 1632.30 109 0.13 829.50 1580.70 802 0.30 837.60 1$$2.00 E09 0.21 843.00 159490 804 0.16 847.20 1627.70 509 0.18 848.60 1619.90 606 0.18 852.30 1661.70 607 0.18 854.80 1657.70 608 0.17 858.30 1651 30 609 0.12 86140 1641.00 610 0.07 862.80 1664.30 611 0.05 862.00 1683.10 612 0.05 863.70 1724.40 E19 0.06 86430 1674.20 614 0.11 868.40 1685.20 615 0.15 87160 1729.50 616 0.16 876.00 2716.00 617 0.16 879.90 1908.20 618 0.12 88290 1732.30 619 0.16 88740 1718.40 620 0.16 893.10 1739.60 621 0.15 899.40 174140 622 0.13 907.40 176740 623 0.14 91500 1828.70 624 0.14 918.80 187140 625 0.15 923.30 1855.60 626 0.13 930.20 1858,30 627 0.10 938.180 1909 40 628 0.06 947.70 1918.00 629 001 956.80 1934 20 630 0.04 963 70 1954.10 630 004 963,70 1954,10 631 0.04 969.70 1994.50 632 0.02 976.50 2101.90 633 0.01 982.40 2099.10 634 0.02 986.30 2128.10 635 0.01 994.80 2164.40 636 0.01 1001.60 2208.10 637 0.03 10090 2209,20 638 0.09 1019.50 2194.50 639 0.08 1028.40 2246.00 640 0.08 1034.30 2268.60 641 0.09 1039.00 2248.40 642 0.09 1046,20 2221.00 643 0.10 105230 2314.80 644 0.10 1059.40 2334.00 645 0.11 1068.10 2358.00 646 0.10 2416.20 1077.00 1083.60 647 0.09 2415120 648 0.07 1090.70 2509,70 649 0.02 3097.20 2481.30 650 0.10 1100.00 2455.90 651 0.09 1103.90 2497.20 652 0.06 110930 2542.30 653 0.04 1116.40 2518.30 654 0.05 1123.10 2523.50 655 0.04 1131.00 2543.70 656 0.04 1137470 253740 657 0.02 1145.00 2555 50 658 0.05 OVISIT 2618.40 659 0.07 1154.50 2602 20 099 0.07 1160.70 2715.70 199 0.04 1165.20 27010 ww 11271 2760 662 0.05 1171.90 270620 663 ODS 1189.70 2323 30 664 0.03 1198.30 2809 0 0.03 1205.00 2782 20 666 0.04 1211.90 282480 667 0.03 1218.40 2841.20 668 0.03 1223.60 2790.20 669 0.02 1227.00 2834.60 670 0.02 1231.70 2865.00 671 0.02 1241.50 2861.10 672 0.03 125330 2992.00 673 0.03 1266.70 2941.10 674 0.02 1273.00 2979.60 675 0.03 1279.30 3023.90 676 0.02 1284.60 3035.40 677 0.02 1288.80 2975.90 678 0.02 1294.30 3020.70 679 003 1301.10 3038.40 680 0.07 1309.30 3023.30 681 0.02 1318.10 3016.30 682 0.02 132520 3011.30 683 0.12 1333.90 3056 20 684 0.23 2339.60 314.10 685 0.26 1346 30 309430 686 0.31 1352.30 3097 AD 687 0.29 1359.80 3181 20 688 0.22 1366.00 3236.50 589 0.27 3374.50 323730 690 0.22 1381.60 3250.10 691 0.30 2388.20 324840 692 0.30 3395.10 332200 693 0.29 1401.00 3300 50 083 UTZ 73339 300020 684 0.23 1339.60 3141.10 685 0.26 1346.30 309430 686 0.31 1352.30 3097 40 687 0.29 1359 80 3181.20 688 0.23 1366.00 323650 689 0.27 1374.50 323730 690 0.27 1381.60 3250.10 691 0.30 1388.20 3248.40 692 0.30 1395.10 3322.60 693 0.29 1401.00 3300.50 694 0.33 1407.50 3330.40 695 0.45 1415.30 3327.00 696 051 1421.30 3382.80 697 051 1431.90 3387.70 698 0.52 1434 80 3346.50 699 0.74 1446.70 3467.50 700 0.80 1457.60 3473.20 201 0.89 1467.60 3503.60 202 0.98 1477.00 3508 50 703 1.07 1485.40 3539.30 204 101 1493 80 3574.00 205 1.03 1503.20 3533.30 706 3.02 151230 3588.60 207 1.23 1518.10 3584 60 708 132 1525.80 3636.90 141 709 710 1534 20 363630 152 1540.20 711 1.70 1548.20 3558.20 3686.50 212 1.76 1558.00 3693 30 713 186 1569.00 3657:30 714 1.90 1580 30 3660 SO IS 4.10 1609.80 3980 AD 4. The Excel data file titled ANOVA Examination Data provides 715 observations on variables X1, X2, and X3. Answer each question below using Excel. You must turn in your output. (10 points) a. Conduct a test at the 0.05 level to see if the variance of X2 and X3 are equal. (5 points) b. Conduct a simple ANOVA test to see whether the means of X1, X2, and X3 are equal. Conduct this test at the 0.05 level. How do the means differ? (5 points) bservation xi X2 X3 1 2.82 28.50 142.20 2 2.70 28.60 139.30 3 2.80 28.60 138.40 4 2.95 28.60 139.70 5 2.84 28.70 138.70 6 3.21 28.90 139.40 7 3.20 28.80 140.30 8 3.38 28.90 140.00 9 4,04 28.90 140.40 10 4.05 28.80 140.70 11 4.15 28.80 141.80 12 449 28.80 143.60 13 435 28 SC 143.30 14 3.96 28.50 139.80 15 3.31 28.80 138.50 16 3.23 28.80 139.70 17 3.29 28.80 137.60 18 2.46 28.80 137.90 19 2.30 28.70 138 90 20 2.30 28.70 139.40 140.50 21 2.45 28.80 22 2.30 28.80 34120 23 2.37 28.80 142.30 24 2.25 28.70 144.50 25 2.24 28.70 14450 26 2,42 28.70 141.00 27 2.39 28.70 140,10 25 2.29 28.70 1420 28 2.29 28.70 142.40 29 2.29 28.70 140.60 30 2.33 28.70 141.20 31 2.24 28.80 141.50 32 239 28.90 14140 33 2.28 29.00 143.10 34 2.30 29.10 144.40 35 2.48 29.20 146.30 36 2.60 29 30 149.20 37 2.72 29.40 148.90 38 2.73 29.50 145.60 39 2.72 29.60 144.60 40 2.73 29.80 146.20 41 2.69 29.80 144.50 42 2.73 29.80 144.80 43 2.92 29.90 145.00 44 2.82 30.00 4. 45 2.78 30.00 145.50 46 2.74 30.10 147.00 47 2.83 30.20 148.80 48 2.87 30.30 151.90 49 2.91 30.40 152.10 0 2.92 30.60 148.70 51 2.89 30.70 147.50 52 2.90 31.00 250.00 147 90 53 293 31.00 54 2.99 31.20 148,70 SS 3.18 - 149.90 56 3.32 127) 149.50 57 338 31.70 15100 3.45 3150 152 80 59 3.52 32.00 255.20 352 32.00 155.20 3.52 32.20 15750 3.52 32.30 157.90 3.53 32.40 153.90 63 3.54 32.60 153.10 3.47 32.70 155.20 3.48 32.90 152.70 3.48 33.20 153.90 3.46 33.20 155.50 3.50 33.40 155.50 3.53 33.60 157.80 357 33.80 159.70 $ 32 2 3 23 53 3 z 3.64 33.80 161.60 384 33.90 164.90 3.81 34.00 165 30 393 34 20 360.30 75 3.93 3430 159.90 76 3.93 34 40 162.60 3.89 3450 158.70 3.80 34.70 160 50 3.84 34.90 161.80 3.84 35.10 161 20 81 3.92 35.30 16390 82 403 35.60 366.50 4.09 35 80 168 20 84 438 36.00 17260 85 4.59 36.20 173.80 86 36 40 168.50 87 4.59 36 50 168.70 562 36.70 72.10 89 4.64 3700 168.00 90 4.50 37.00 170.00 480 37.20 91 169.20 92 496 37.40 168.30 37.50 171.10 93 537 37.70 171.60 94 535 95 17290 532 37.80 96 176.90 4.96 38.00 97 4.72 38.20 176,60 98 456 38.40 171.60 99 4.26 38.50 172.90 100 3.84 38.60 174.70 101 3.60 38.80 172.30 102 354 38.90 175 60 177.20 103 421 39.00 104 4.27 39.20 177.20 105 442 39.40 179.80 106 456 39.60 181.90 107 4.73 39.70 183 80 108 4.97 40.00 188.40 109 5.00 40.50 189.20 110 4.98 40.30 183.00 111 5.17 40.60 183.50 112 538 40.90 18730 113 5.66 41.00 184.60 114 552 4140 188.20 315 5.31 41.00 389 SO 5.09 116 41.SO 189.50 117 5.19 42.20 19190 118 5.35 42.40 194.20 119 545 42.70 197.50 120 596 43.00 202 80 121 6.14 203.10 43.10 122 6.12 43.40 19730 124 6.11 43.80 20150 125 6.04 43.90 197.40 126 6.44 44.20 200.20 127 7.00 44.50 201.20 128 6.98 44.70 199.50 129 7.09 44.90 201.20 130 7.00 45.20 202.90 131 7.24 45.50 205.00 132 7.82 45.70 209.30 133 787 46.00 210.80 134 7.13 46.10 202.00 135 6.63 46.30 203 50 136 6.51 46.50 208.10 137 6.84 46.90 204.30 138 6.68 47.20 206.90 139 6.45 47.40 208.10 140 6:41 47.60 208.00 141 6.12 47.90 210.80 142 591 48.10 212.30 143 5.25 48 30 214.50 144 4.87 48.60 220.10 145 4.44 48.90 220.40 146 3.70 49.20 214.30 147 338 49.40 21640 148 3.86 49.70 22140 149 4.14 50.00 218.80 150 4.75 50.40 222.90 151 5.40 50.90 225.10 152 4.94 5120 223.60 153 5140 22540 154 446 226 60 51.50 51 50 155 2280 155 4.22 51.80 228.80 156 4.01 52.00 234.50 157 3.38 5230 235.00 158 3.20 52.60 228.90 Mi 159 3.73 50 53.00 231.70 160 3.71 53.10 236.90 161 3.69 53.40 232.20 162 3.91 53.70 236.10 163 3.98 54.00 239.10 164 402 ero 5440 238.70 165 4.66 34.80 241.30 166 4.74 55.30 244.20 167 4.28 55.70 247.70 168 5.07 56.20 256,10 169 541 5660 256:40 170 580 56.90 24840 171 6.09 5720 248 80 172 6.26 57 NO 254.00 123 6.36 5810 250 80 174 7.19 58 50 2560 175 801 58 SO 258.10 176 8.67 59.10 255.00 172 8.29 59 60 256.50 178 7.22 59.90 25x30 179 783 6030 202.70 180 745 BOS 270.20 151 7.77 61.30 26860 182 7.12 61.80 183 796 26.10 26350 6210 184 833 63.00 2650 185 26530 156 63.00 63.70 64.10 7.90 755 167 268.30 270.10 188 8.96 64.70 268.10 189 8.06 65.20 269.70 190 7.46 65.80 271.70 191 7.47 66.50 275.70 192 7.15 67.00 281.80 193 6.26 67.40 278.50 194 5.50 67.80 269.90 195 5.49 68.40 272.90 196 5.61 68.50 277.70 197 5.23 69.10 27440 198 5.34 70.00 282.30 199 6.13 70.50 284.40 200 6.44 71.00 282.70 201 6.42 71.20 28430 202 5.96 71.70 284.90) 203 5.48 72.30 289.90 204 544 72.80 295 30 205 4.87 73.20 293.20 206 4.88 73.90 285.30 207 5.00 74.70 287.70 208 4.86 75.50 296.10 209 5.20 76.10 291-30 210 541 7600 295.60 211 5.23 77.10 298,40 212 5.14 77.60 297.10 213 5.ON 78.10 298.60 30290 214 4.92 78.60 215 4.75 79.10 305.70 216 4:35 29 50 314.30 217 4.62 80.20 313.60 213 4.67 1 304.90 219 4.00 8130 308.20 220 454 82.10 318.60 221 4.96 82.50 311.60 222 5.02 83.10 317.70 223 5.19 83.90 32220 224 5.49 84.50 320.20 225 5.81 85.20 323.70 226 6.16 85.90 327.90 227 6.10 86.60 331.40 228 6.07 87.40 340.00 229 6.44 88.00 33930 230 6.45 88.70 327.90 231 6.29 89.40 330.80 232 6.29 90.00 34340 233 641 90.80 338,20 234 6.73 9150 345.20 235 7.01 92.00 349,50 236 7.08 92.70 34750 237 7.85 93 60 352.70 238 7.99 9440 354.90 35850 239 864 95.20 240 9.08 96.00 367.90 241 9.35 96.80 363.30 242 9.32 97.40 357.70 243 9.48 98.00 356.10 244 9.46 37130 98.50 99.50 245 9.61 36220 246 906 100 30 371.90 247 9.30 1020 37840 245 9:52 202.10 376.90 249 10.26 103.10 380.50 2.50 11.70 103.90 352/60 251 11.79 104.30 384.40 252 12.04 104.80 393.20 253 12.00 106.00 390 40 254 12.86 106.70 380 80 255 15.20 10750 382.20 256 13.20 107.70 386.70 257 8.58 108.70 377 80 258 7.07 109.60 387.30 259 8.06 110.50 39460 260 9.13 111.70 398.30 261 10.27 112.40 404.70 262 11.62 113.40 410.70 263 13.73 15.49 11490 11530 415.80 419.50 264 265 15.02 115.30 416.40 266 14.79 405 50 OS 267 116.20 117.00 117.90 13.36 33.69 412.20 268 431.00 269 16.30 418.50 118.30 118.70 270 14.73 1495 422.80 427.70 221 119.50 272 1531 119.90 120.10 425.90 42700 273 14.70 274 1354 120.50 429.70 275 10.86 435.10 121.40 122.50 276 10.85 447.00 277 12:28 123.20 448.40 228 13 123.90 432.40 279 1268 435.60 09 12440 125.50 280 12.70 25110 281 12.09 126.20 340.90 282 1242 127.40 46.20 203 1105 449 50 32810 199.00 OR R US DIT 283 11.35 128.10 449.50 284 8.68 129.00 449.80 285 7.92 129.90 456.20 286 7.71 130.90 465.70 287 8.07 131.60 474 40 288 7.94 132.50 485.80 289 786 133.60 482.80 290 8.11 135.00 474 20 291 8.35 136.40 482.70 92 8.21 137.40 498.60 293 8.19 138.70 493.90 294 8.79 139.60 50350 295 91 140.60 510.50 296 9.34 141.40 508.20 297 9.00 142.70 511:40 298 8.64 144.10 517-20 299 8.76 145.30 521.80 300 9.00 146.20 53330 301 8.90 530.20 302 909 148.00 516.30 303 9.52 149.10 523.20 304 9.69 150.10 539.90 305 150.20 530.70 306 9.87 151.90 5410 307 10.12 152.70 34330 308 3047 153 50 539.00 309 1037 36 54250 310 9.74 154.70 542.20 311 8.61 312 8.06 156.10 366.60 313 7.76 156 80 561.10 312 8.06 156.10 564.60 313 7.76 156.80 561.10 314 8.27 157.90 551.90 315 8.52 158.50 558.00 316 795 159.30 575.10 317 7.48 160.40 569.30 318 6.95 161.70 585.20 319 708 162.80 592.00 320 7.14 164.20 594.90 321 7.10 165.10 602.00 322 7.16 166.10 605.30 323 7.24 167.00 614.90 324 7.10 167.70 633.30 325 7.07 168.40 626 60 326 7.06 169.40 612.80 327 6.56 370.70 624.30 328 6.06 17140 647.00 329 6.15 172.70 645.70 330 6.21 173.60 662.80 331 5.83 274.70 673.40 332 553 375.90 678.40 333 5.21 176.80 684.50 334 5.18 178.20 692.20 335 535 179.20 708,80 336 5.53 180.40 739.80 337 543 181.90 737.10 338 5.59 183.30 717410 339 5.59 184.00 723.10 340 5.64 185.30 752.00 341 5.66 18650 739 30 342 5.67 187.60 763 0 343 49 188.20 746.20 3444 604 190.00 744,20 344 6.04 190.00 744.20 345 6.40 191.40 744.50 346 6.13 193.10 753.20 347 5.69 195.20 755.50 348 5.77 196,70 765.40 349 5.81 197.90 764,20 350 5.66 198.90 744.50 351 5.70 200.20 751.60 352 5.91 201.80 777.90 353 6.26 203.20 763.40 354 6.46 204.60 778.50 355 6.73 206.10 785.50 356 7.06 207.10 781.00 357 7.24 208.60 739.70 358 7.35 209.70 780.80 359 7.76 210.70 786.90 360 8.07 212.00 803.10 361 8.27 212.90 792.10 362 8.53 213.50 775.60 363 8.82 214.70 774.60 364 8.65 215.30 790.20 766,10 365 8.43 216.30 366 8.15 217.20 80 367 ss 218.00 780.70 368 7.90 218.50 776.50 369 775 219.10 777.20 370 7.64 219.80 783.20 371 7.69 220.50 790.20 372 7.63 222.30 810.50 373 264 223.90 800.70 374 7.74 225.50 786.70 373 7.90 227 50 79450 376 7.77 229.40 816.20 377 7.74 231.20 795 50 378 7.73 233.30 809.00 379 7.62 235.50 811.00 380 745 238.40 812.70 381 7.36 241.40 817.10 382 7.17 243.50 816.10 383 7.06 245.00 824.60 384 6.74 246 50 842.70 385 6.22 250.60 831.70 386 5.94 253.50 822.10 387 591 255.70 833.70 388 5.65 255.70 851.90 389 5.46 256.50 840.30 390 557 257.60 856.70 391 5.58 259.10 860.90 392 5.33 260.90 863.20 393 5.22 262.10 865.40 394 4.99 263.70 874.00 395 4.56 265.50 892 30 396 4.07 267.10 915.60 397 3.80 268.60 916.40 398 3.84 270.20 915.10 399 404 27150 929.60 400 3.75 273.10 953.70 401 3.60 274.50 942.90 402 3.66 276.30 951.00 403 3.21 239,20 962.00 404 3.13 282.00 970.10 2.91 284.90 982.20 406 2.56 287.30 10000 407 3.13 . 1 10210 407 3.13 289.50 1021.40 408 3.22 292.10 1045.60 409 3.00 294.20 1039.80 410 2.93 296.10 1021.90 411 2.95 298.30 1030 SO 412 2.87 301.00 1057.40 413 2.96 303.80 1056 80 414 3.07 306.40 1071.80 415 3.04 309.40 1083.10 416 3.02 311.90 1088.10 417 2.95 314.90 1098.80 418 3.02 317.30 111160 419 3.10 319.10 1129.00 420 3.06 321.60 115330 421 2.98 324.90 114120 422 3.25 328.10 1123.80 423 3.30 331.10 1131.10 424 3.68 333.70 1152 20 425 336.80 1132.00 426 4.14 339.80 1141.80 427 15090 428 4.48 345.40 1144.30 429 4.62 347.70 1146.40 430 4.95 350 30 1149.90 431 5.29 353.00 1156.20 432 5.60 5.71 35. 357.40 1174.50 1159 50 434 5.77 358 50 3135 30 435 5.73 362 20 1139.30 436 5165 5. Sta 116030 437 3.67 1234.00 438 547 367.90 114100 439 368 20 115.70 440 5.40 368.80 1139.30 441 5.28 369.80 1138.40 442 5.28 370.90 1132.90 443 5.36 371.50 1138.60 444 5.14 372.80 1152.70 445 5.00 373 30 1130.20 446 4.83 372.40 1105.80 447 4.96 374.90 1118.00 448 4.95 376.10 1131 80 449 5.02 377.70 1105.90 450 5.09 380.20 1115.00 451 5.15 383.10 1110.70 452 S.OS 385.70 1097.70 453 5.09 387.90 1091.70 454 4.99 389.90 1078 40 455 5.03 392.20 1087.40 456 4.91 394 60 1105.80 457 5.03 396.80 1087.90 458 5.01 398 80 1066 80 459 5.14 401.50 1069.20 460 5.16 403.30 1074.50 461 5.05 406.20 1054.70 462 4.93 408 50 1064.30 463 5.05 410.80 1065.80 464 5.14 413.20 1069.10 465 4.95 415.50 1059 50 466 4.97 418.20 1057.60 467 5.14 421.80 1074.10 468 5.16 625.30 109350 469 50 427.50 1060.20 420 5.09 450.00 1066 30 471 503 431.90 1075 90 492 8770 471 5.03 43190 1075.90 472 4.95 433.80 1087.70 473 5.00 436.10 1070.80 474 4.98 438.70 1075.20 475 4.96 442.20 1074.20 476 4.90 44480 1069.30 477 4.61 449.80 1070.60 1077.40 478 3.96 453.70 479 4.41 45720 1098.00 480 4.39 460.40 1121.20 481 4.34 463.40 1103.90 482 4.44 467.40 1085.20 483 4.44 471.60 1097.50 484 4.29 475.70 1113.60 485 4.50 480.00) 3096.40 486 4.57 48340 1098.20 487 4.55 487.10 -1097 20 488 4.72 490.50 1092.80 489 4.68 49450 1086.20 490 4.86 499.20 1095.10 491 507 505.30 1113.00 492 5.20 517.90 1148.20 493 532 524.90 11 26.90 494 335 518.00 1097.40 495 569 516,90 1108.90 496 5.66 517.90 1125.70 497 5.79 519.10 1100.40 498 5.69 521.20 1101.80 1102 80 499 5.96 522.60 500 609 522.80 109450 501 6.00 524.10 3088.80 502 6.11 3 526,20 503 1092 20 1192.10 6.17 528 30 Vio 5.77 $31.30 504 1111.70 SOS 5.15 534.10 1100.40 506 488 536.70 1089 80 507 4.42 1111. 20 539.30 542.70 1126.70 SOS 387 509 362 545.80 1114.70 510 349 548.70 1126 30 554 40 351 1139.70 511 512 3.36 562.40 114450 264 513 1193.60 56780 $14 2.16 571.60 1159.20 515 187 575.80 1169.00 516 1.69 1208.50 1191.80 517 581.20 586.60 591.30 595.40 1178.30 518 1.65 1.72 1.79 1.71 1.73 519 1196.50 520 599.50 1196.90 521 604.90 522 1.70 610.20 1186.00 1994.70 1200 40 523 1.68 615 40 524 1.62 616.90 118230 525 163 618.20 1185.80 526 158 620.00 1196.60 527 1.23 622.50 1205-30 528 1.19 626.20 1245.50 529 1.17 630.10 122550 530 1.17 635.00 3225.50 531 1.13 639.40 1245.10 532 1.13 643.00 1259.50 533 3.07 645 80 1266.60 534 0.92 647.40 1284.70 535 0.90 54830 2287 90 532 1.13 643.00 1259 60 533 1.07 645.80 1266.60 534 0.92 647.40 1284.70 535 0.90 648 30 1287.90 536 095 650.20 1292.20 537 0.94 652.70 1286.20 538 0.92 657.40 1288.80 539 0.93 660.00 1293.90 540 0.90 662.50 133250 541 0.88 663.80 1303 80 542 0.93 665.40 1306.70 543 0.94 666.90 1337.90 544 0.94 669.80 134320 545 1.02 673.10 1333.40 546 1.27 677.60 1347.70 547 1.33 685.40 1338.80 548 1.48 686.80 1352.60 549 1.65 690.40 13-49.10 550 1.76 693.50 1351.40 551 207 697 80 137) DO 552 2.19 697 80 1401 50 353 2.33 698.90 1361 50 554 254 200.40 1355.00 555 2.74 702.00 556 2.78 1381.70 1369 40 203.40 557 284 704.60 1369.50 558 2.92 708.20 1384 30 559 3.22 710.60 236540 560 3:44 73340 1376.90 561 342 717.20 1363.50 562 3.71 718.40 1365.40 563 3.85 720:50 1375 60 564 389 724.60 1393:20 565 4.24 729.30 1375.50 566 4.43 733.20 1362.00 567 1394.70 451 735.60 568 4.60 738 20 1393.60 569 4.72 741.30 1392.10 570 4.79 740.80 1379.00 571 495 740.80 1368.60 572 4.96 742.10 1370.60 573 481 742.60 134740 574 4.92 743.70 1360.30 575 4.94 746,60 136850 576 485 750.20 1387.70 4.98 750.70 1369.00 578 503 750.00 1347.50 579 494 750.80 1378 40 580 4.87 753.70 1392.30 581 4.73 755.30 1385.60 582 4.61 755.70 1370.80 583 4.82 758.10 1368.60 584 4.20 759.00 1372.80 3.89 760.20 1356.30 586 390 762.90 1369.40 587 3.27 762.70 1370.50 588 3.00 760.60 1394 90 589 2.75 758.30 1375.90 590 2.12 757.40 1365.90 591 1.26 759.20 3401.10 592 1.29 758.20 1406.60 593 1.73 762.40 3396.50 594 1.86 768 50 1407.30 595 160 774.80 1417.70 596 1.72 776.80 3401.30 597 1.13 780.90 144130 598 0.67 796.70 1462160 665 0.19 806 40 1513.70 009 0.03 816.20 1632.30 109 0.13 829.50 1580.70 802 0.30 837.60 1$$2.00 E09 0.21 843.00 159490 804 0.16 847.20 1627.70 509 0.18 848.60 1619.90 606 0.18 852.30 1661.70 607 0.18 854.80 1657.70 608 0.17 858.30 1651 30 609 0.12 86140 1641.00 610 0.07 862.80 1664.30 611 0.05 862.00 1683.10 612 0.05 863.70 1724.40 E19 0.06 86430 1674.20 614 0.11 868.40 1685.20 615 0.15 87160 1729.50 616 0.16 876.00 2716.00 617 0.16 879.90 1908.20 618 0.12 88290 1732.30 619 0.16 88740 1718.40 620 0.16 893.10 1739.60 621 0.15 899.40 174140 622 0.13 907.40 176740 623 0.14 91500 1828.70 624 0.14 918.80 187140 625 0.15 923.30 1855.60 626 0.13 930.20 1858,30 627 0.10 938.180 1909 40 628 0.06 947.70 1918.00 629 001 956.80 1934 20 630 0.04 963 70 1954.10 630 004 963,70 1954,10 631 0.04 969.70 1994.50 632 0.02 976.50 2101.90 633 0.01 982.40 2099.10 634 0.02 986.30 2128.10 635 0.01 994.80 2164.40 636 0.01 1001.60 2208.10 637 0.03 10090 2209,20 638 0.09 1019.50 2194.50 639 0.08 1028.40 2246.00 640 0.08 1034.30 2268.60 641 0.09 1039.00 2248.40 642 0.09 1046,20 2221.00 643 0.10 105230 2314.80 644 0.10 1059.40 2334.00 645 0.11 1068.10 2358.00 646 0.10 2416.20 1077.00 1083.60 647 0.09 2415120 648 0.07 1090.70 2509,70 649 0.02 3097.20 2481.30 650 0.10 1100.00 2455.90 651 0.09 1103.90 2497.20 652 0.06 110930 2542.30 653 0.04 1116.40 2518.30 654 0.05 1123.10 2523.50 655 0.04 1131.00 2543.70 656 0.04 1137470 253740 657 0.02 1145.00 2555 50 658 0.05 OVISIT 2618.40 659 0.07 1154.50 2602 20 099 0.07 1160.70 2715.70 199 0.04 1165.20 27010 ww 11271 2760 662 0.05 1171.90 270620 663 ODS 1189.70 2323 30 664 0.03 1198.30 2809 0 0.03 1205.00 2782 20 666 0.04 1211.90 282480 667 0.03 1218.40 2841.20 668 0.03 1223.60 2790.20 669 0.02 1227.00 2834.60 670 0.02 1231.70 2865.00 671 0.02 1241.50 2861.10 672 0.03 125330 2992.00 673 0.03 1266.70 2941.10 674 0.02 1273.00 2979.60 675 0.03 1279.30 3023.90 676 0.02 1284.60 3035.40 677 0.02 1288.80 2975.90 678 0.02 1294.30 3020.70 679 003 1301.10 3038.40 680 0.07 1309.30 3023.30 681 0.02 1318.10 3016.30 682 0.02 132520 3011.30 683 0.12 1333.90 3056 20 684 0.23 2339.60 314.10 685 0.26 1346 30 309430 686 0.31 1352.30 3097 AD 687 0.29 1359.80 3181 20 688 0.22 1366.00 3236.50 589 0.27 3374.50 323730 690 0.22 1381.60 3250.10 691 0.30 2388.20 324840 692 0.30 3395.10 332200 693 0.29 1401.00 3300 50 083 UTZ 73339 300020 684 0.23 1339.60 3141.10 685 0.26 1346.30 309430 686 0.31 1352.30 3097 40 687 0.29 1359 80 3181.20 688 0.23 1366.00 323650 689 0.27 1374.50 323730 690 0.27 1381.60 3250.10 691 0.30 1388.20 3248.40 692 0.30 1395.10 3322.60 693 0.29 1401.00 3300.50 694 0.33 1407.50 3330.40 695 0.45 1415.30 3327.00 696 051 1421.30 3382.80 697 051 1431.90 3387.70 698 0.52 1434 80 3346.50 699 0.74 1446.70 3467.50 700 0.80 1457.60 3473.20 201 0.89 1467.60 3503.60 202 0.98 1477.00 3508 50 703 1.07 1485.40 3539.30 204 101 1493 80 3574.00 205 1.03 1503.20 3533.30 706 3.02 151230 3588.60 207 1.23 1518.10 3584 60 708 132 1525.80 3636.90 141 709 710 1534 20 363630 152 1540.20 711 1.70 1548.20 3558.20 3686.50 212 1.76 1558.00 3693 30 713 186 1569.00 3657:30 714 1.90 1580 30 3660 SO IS 4.10 1609.80 3980 AD

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

1. Please show relevant Excel output screenshots and include necessary charts/diagrams. 2. Please answer the questions with complete sentences. 3. Please use Excel formula | Data Analysis to verify...

Hi, I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded...

Final Exam - MGMT 650 Fall 2016 Directions: Please answer all questions. There are 30 questions and the exam is worth 20% of your total grade. The questions are not equally weighted. The point value...

Please give the answer of question 2 Question 1. Provide short answers (i.e., no more than five lines on average with the font size of 12) for the following items. The grade for each item is 5...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

PLEASE HELP ME!! THIS IS AN EMERGENCY!!! CAN YOU PLEASE DO THIS AS SOON AS HUMANLY POSSIBLE.. New Perspectives Excel 2019 | Module 8: End of Module Project 2 Expo Events EXPLORE BUSINESS OPTIONS WITH...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

02 8 Points Open the file FatalWorklnjurie32019.xlsx and select the tab titled Fatal Work Injuries by Year, which contains the number of fatal work injuries and employment from 1992 through 2019. We...

Final Exam - HIMS 650 Fall 2015 SOLUTIONS Directions: Please answer all questions. There are 14 questions and the exam is worth 25% of your total grade. The questions are not equally weighted. The...

A lender has been fined, its licence has been suspended, and it is subject to an order by the regulator prohibiting further violations. What may the complainant seek as additional remedies in these...

If A and B are symmetric, show that AB is symmetric if and only if AB = BA.

Which one of the following is the greatest disadvantage of long margined positions? a ) the reduction in potential diversification c ) the possibility of magnified losses b ) the ability to borrow...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".