Please use minitab for this

Data

The worksheet contains Florida voting numbers per county for the 2016 presidential election. a) Obtain comparative boxplots for votes received by Trump and votes received by Clinton. The two boxplots should be on the same graph (i.e., Simple with multiple Y's). Copy and paste the graph into your document. b) Statistically comment on the plots. Company Price InstOwn P/B Value Earnings County Trump Clinton YEAR STATE RATE DEATHS Date Positive Amdahl... 12.31 45.4 2.49 -2.49 Miami-D... 333666 623006 2018 AL 53.0 2682 8/16/2020 0 Auspex S... 11.00 66.1 2.22 0.85 Palm Bea... 270762 371411 2018 AK 56.4 400 8/16/2020 1 Compaq... 65.50 83.0 6.84 2.01 Hillsboro... 265928 306422 2018 AZ 55.4 4251 8/16/2020 0 Data Gen... 35.94 91.5 4.25 1.15 Broward... 258521 546956 2018 AR 48.6 1530 8/17/2020 1 Digi Inter... 15.00 33.4 2.04 -0.89 Pinellas... 238746 233327 2018 CA 33.7 14153 8/17/2020 5 Digital Eq... 43.00 58.8 1.92 -2.93 Duval Co... 210061 203627 2018 CO 52.3 3049 8/17/2020 O En Pointe... 14.25 11.8 3.47 0.80 Orange C... 195091 329579 2018 CT 53.1 2054 8/18/2020 5 Equitrac... 16.25 20.9 2.38 0.76 Lee Coun... 191141 124725 2018 DE 67.1 662 8/18/2020 7 Franklin... 12.88 30.8 1.41 0.82 Brevard... 181620 119525 2018 FL 53.1 12670 8/18/2020 2 Gateway... 39.13 36.0 6.45 1.74 Polk Cou... 157216 117182 2018 GA 41.7 4418 8/19/2020 3 Hewlett-... 61.50 50.2 4.35 2.64 Volusia C... 142763 108793 2018 HI 37.6 625 8/19/2020 6 Ingram M... 28.75 14.4 4.53 1.01 Pasco Co... 141943 89998 2018 ID 49.5 889 8/19/2020 6 Maxwell... 30.50 26.5 8.07 0.46 Sarasota... 124098 97676 2018 IL 44.3 6016 8/20/2020 0 MicroAge... 27.19 76.6 2.16 1.25 Seminole... 109265 105611 2018 IN 55.2 3782 8/20/2020 11 Micron El... 16.31 18.8 4.48 1.06 Marion C... 107710 61958 2018 IA 40.8 1480 8/20/2020 6 Network... 11.88 39.8 3.34 0.15 Collier C... 105297 60941 2018 KS 46.5 1465 8/21/2020 O Pomeroy... 33.00 56.9 3.29 1.81 Lake Cou... 101888 62597 2018 KY 66.8 3051 8/21/2020 5 Sequent... 28.19 57.0 2.65 0.36 Manatee... 101681 71066 2018 LA 58.8 2781 8/21/2020 8 Silicon Gr... 27.44 63.0 3.01 -0.44 St. Johns... 88633 43037 2018 ME 65.0 1000 8/22/2020 0 Southern... 15.13 41.9 2.46 0.99 Escambi... 88370 57114 2018 MD 35.0 2307 8/22/2020 5 Stratus C... 55.50 77.2 2.48 2.52 Clay Cou... 74898 27768 2018 MA 53.0 3971 8/22/2020 3 Sun Micr... 48.00 59.3 7.50 1.67 Okaloosa... 71788 23711 2018 MI 52.0 5555 8/23/2020 4 Tandem... 34.25 61.3 3.61 1.02 St. Lucie... 70248 66812 2018 MN 43.8 2792 8/23/2020 2 Tech Dat... 38.94 82.3 3.80 1.50 Santa Ro... 65126 18398 2018 MS 54.4 1692 8/24/2020 co Unisys C... 11.31 34.8 16.64 0.08 Bay Coun... 62010 21689 2018 MO 61.6 3975 8/24/2020 13 Company Price InstOwn P/B Value Earnings County Trump Clinton YEAR STATE RATE DEATHS Date Positive Unisys C... 11.31 34.8 16.64 0.08 Bay Coun... 62010 21689 2018 MO 61.6 3975 8/24/2020 13 Charlotte... 60196 33421 2018 MT 51.0 598 8/24/2020 3 Hernand... 59029 31818 2018 NE 38.5 806 8/25/2020 O Citrus Co... 54377 22765 2018 NV 48.4 1547 8/25/2020 21 Leon Cou... 53777 91936 2018 NH 66.0 959 8/25/2020 7 Martin C... 53182 30158 2018 NJ 50.1 4676 8/26/2020 1 Sumter C... 52722 22631 2018 NM 69.3 1514 8/26/2020 12 Osceola... 50252 85287 2018 NY 34.2 7415 8/26/2020 3 Indian Riv... 48564 28997 2018 NC 55.2 6007 8/27/2020 0 Alachua... 46584 75370 2018 ND 42.0 358 8/27/2020 12 Nassau C... 34221 10849 2018 OH 63.8 7755 8/27/2020 3 Flagler C... 33804 21985 2018 OK 62.5 2612 8/28/2020 2 Highland... 29509 14901 2018 OR 43.6 2075 8/28/2020 9 Walton C... 25695 6861 2018 PA 61.9 8585 8/28/2020 2 Monroe... 21885 18949 2018 RI 59.1 719 8/29/2020 O Putnam... 21873 9920 2018 SC 63.3 3369 8/29/2020 3 Columbia... 20359 7599 2018 SD 46.4 452 8/29/2020 3 Suwanne... 14281 3955 2018 TN 63.5 4483 8/30/2020 0 Jackson... 14231 6383 2018 TX 37.7 10646 8/30/2020 3 Levy Cou... 13758 5091 2018 UT 45.1 1284 8/30/2020 1 Wakulla... 10507 4348 2018 VT 63.1 444 8/31/2020 3 Baker Co... 10294 2112 2018 VA 43.7 3936 8/31/2020 1 Okeecho... 9342 3953 2018 WA 42.1 3396 8/31/2020 1 Bradford... 8913 2924 2018 WV 90.3 1707 9/1/2020 1 Washingt... 8630 2261 2018 WI 57.1 3786 9/1/2020 6 Holmes... 7476 852 2018 WY 57.1 353 9/1/2020 4 Tavlor Co 6923 2149 2017 AL 538 2703 9/2/2020 Company Price InstOwn P/B Value Earnings County Trump Clinton YEAR STATE RATE DEATHS Date Positive 2017 LA 58.8 2780 9/7/2020 1 2017 ME 68.0 990 9/8/2020 0 2017 MD 36.9 2408 9/8/2020 15 2017 MA 51.5 3821 9/8/2020 5 2017 MI 53.0 5623 9/9/2020 3 2017 MN 44.6 2788 9/9/2020 13 2017 MS 56.3 1738 9/9/2020 5 2017 MO 58.8 3776 9/10/2020 3 2017 MT 50.2 579 9/10/2020 7 2017 NE 38.5 811 9/10/2020 4 2017/NV 47.8 1496 9/11/2020 1 2017/NH 62.9 907 9/11/2020 17 2017 NJ 47.3 4482 9/11/2020 6 2017 NM 68.2 1460 9/12/2020 0 2017 NY 35.5 7687 9/12/2020 1 2017 NC 56.3 5985 9/12/2020 2 2017 ND 41.3 339 9/13/2020 0 2017 OH 75.1 8971 9/13/2020 10 2017 OK 62.5 2563 9/13/2020 4 2017 OR 44.7 2076 9/14/2020 2 2017 PA 70.2 9527 9/14/2020 9 2017 RI 60.0 718 9/14/2020 33 2017 SC 60.2 3147 9/15/2020 2 2017 SD 56.1 537 9/15/2020 7 2017 TN 63.0 4435 9/15/2020 4 2017 TX 38.8 10763 9/16/2020 0 2017 UT 442 1238 9/16/2020 10 The worksheet contains Florida voting numbers per county for the 2016 presidential election. a) Obtain comparative boxplots for votes received by Trump and votes received by Clinton. The two boxplots should be on the same graph (i.e., Simple with multiple Y's). Copy and paste the graph into your document. b) Statistically comment on the plots. Company Price InstOwn P/B Value Earnings County Trump Clinton YEAR STATE RATE DEATHS Date Positive Amdahl... 12.31 45.4 2.49 -2.49 Miami-D... 333666 623006 2018 AL 53.0 2682 8/16/2020 0 Auspex S... 11.00 66.1 2.22 0.85 Palm Bea... 270762 371411 2018 AK 56.4 400 8/16/2020 1 Compaq... 65.50 83.0 6.84 2.01 Hillsboro... 265928 306422 2018 AZ 55.4 4251 8/16/2020 0 Data Gen... 35.94 91.5 4.25 1.15 Broward... 258521 546956 2018 AR 48.6 1530 8/17/2020 1 Digi Inter... 15.00 33.4 2.04 -0.89 Pinellas... 238746 233327 2018 CA 33.7 14153 8/17/2020 5 Digital Eq... 43.00 58.8 1.92 -2.93 Duval Co... 210061 203627 2018 CO 52.3 3049 8/17/2020 O En Pointe... 14.25 11.8 3.47 0.80 Orange C... 195091 329579 2018 CT 53.1 2054 8/18/2020 5 Equitrac... 16.25 20.9 2.38 0.76 Lee Coun... 191141 124725 2018 DE 67.1 662 8/18/2020 7 Franklin... 12.88 30.8 1.41 0.82 Brevard... 181620 119525 2018 FL 53.1 12670 8/18/2020 2 Gateway... 39.13 36.0 6.45 1.74 Polk Cou... 157216 117182 2018 GA 41.7 4418 8/19/2020 3 Hewlett-... 61.50 50.2 4.35 2.64 Volusia C... 142763 108793 2018 HI 37.6 625 8/19/2020 6 Ingram M... 28.75 14.4 4.53 1.01 Pasco Co... 141943 89998 2018 ID 49.5 889 8/19/2020 6 Maxwell... 30.50 26.5 8.07 0.46 Sarasota... 124098 97676 2018 IL 44.3 6016 8/20/2020 0 MicroAge... 27.19 76.6 2.16 1.25 Seminole... 109265 105611 2018 IN 55.2 3782 8/20/2020 11 Micron El... 16.31 18.8 4.48 1.06 Marion C... 107710 61958 2018 IA 40.8 1480 8/20/2020 6 Network... 11.88 39.8 3.34 0.15 Collier C... 105297 60941 2018 KS 46.5 1465 8/21/2020 O Pomeroy... 33.00 56.9 3.29 1.81 Lake Cou... 101888 62597 2018 KY 66.8 3051 8/21/2020 5 Sequent... 28.19 57.0 2.65 0.36 Manatee... 101681 71066 2018 LA 58.8 2781 8/21/2020 8 Silicon Gr... 27.44 63.0 3.01 -0.44 St. Johns... 88633 43037 2018 ME 65.0 1000 8/22/2020 0 Southern... 15.13 41.9 2.46 0.99 Escambi... 88370 57114 2018 MD 35.0 2307 8/22/2020 5 Stratus C... 55.50 77.2 2.48 2.52 Clay Cou... 74898 27768 2018 MA 53.0 3971 8/22/2020 3 Sun Micr... 48.00 59.3 7.50 1.67 Okaloosa... 71788 23711 2018 MI 52.0 5555 8/23/2020 4 Tandem... 34.25 61.3 3.61 1.02 St. Lucie... 70248 66812 2018 MN 43.8 2792 8/23/2020 2 Tech Dat... 38.94 82.3 3.80 1.50 Santa Ro... 65126 18398 2018 MS 54.4 1692 8/24/2020 co Unisys C... 11.31 34.8 16.64 0.08 Bay Coun... 62010 21689 2018 MO 61.6 3975 8/24/2020 13 Company Price InstOwn P/B Value Earnings County Trump Clinton YEAR STATE RATE DEATHS Date Positive Unisys C... 11.31 34.8 16.64 0.08 Bay Coun... 62010 21689 2018 MO 61.6 3975 8/24/2020 13 Charlotte... 60196 33421 2018 MT 51.0 598 8/24/2020 3 Hernand... 59029 31818 2018 NE 38.5 806 8/25/2020 O Citrus Co... 54377 22765 2018 NV 48.4 1547 8/25/2020 21 Leon Cou... 53777 91936 2018 NH 66.0 959 8/25/2020 7 Martin C... 53182 30158 2018 NJ 50.1 4676 8/26/2020 1 Sumter C... 52722 22631 2018 NM 69.3 1514 8/26/2020 12 Osceola... 50252 85287 2018 NY 34.2 7415 8/26/2020 3 Indian Riv... 48564 28997 2018 NC 55.2 6007 8/27/2020 0 Alachua... 46584 75370 2018 ND 42.0 358 8/27/2020 12 Nassau C... 34221 10849 2018 OH 63.8 7755 8/27/2020 3 Flagler C... 33804 21985 2018 OK 62.5 2612 8/28/2020 2 Highland... 29509 14901 2018 OR 43.6 2075 8/28/2020 9 Walton C... 25695 6861 2018 PA 61.9 8585 8/28/2020 2 Monroe... 21885 18949 2018 RI 59.1 719 8/29/2020 O Putnam... 21873 9920 2018 SC 63.3 3369 8/29/2020 3 Columbia... 20359 7599 2018 SD 46.4 452 8/29/2020 3 Suwanne... 14281 3955 2018 TN 63.5 4483 8/30/2020 0 Jackson... 14231 6383 2018 TX 37.7 10646 8/30/2020 3 Levy Cou... 13758 5091 2018 UT 45.1 1284 8/30/2020 1 Wakulla... 10507 4348 2018 VT 63.1 444 8/31/2020 3 Baker Co... 10294 2112 2018 VA 43.7 3936 8/31/2020 1 Okeecho... 9342 3953 2018 WA 42.1 3396 8/31/2020 1 Bradford... 8913 2924 2018 WV 90.3 1707 9/1/2020 1 Washingt... 8630 2261 2018 WI 57.1 3786 9/1/2020 6 Holmes... 7476 852 2018 WY 57.1 353 9/1/2020 4 Tavlor Co 6923 2149 2017 AL 538 2703 9/2/2020 Company Price InstOwn P/B Value Earnings County Trump Clinton YEAR STATE RATE DEATHS Date Positive 2017 LA 58.8 2780 9/7/2020 1 2017 ME 68.0 990 9/8/2020 0 2017 MD 36.9 2408 9/8/2020 15 2017 MA 51.5 3821 9/8/2020 5 2017 MI 53.0 5623 9/9/2020 3 2017 MN 44.6 2788 9/9/2020 13 2017 MS 56.3 1738 9/9/2020 5 2017 MO 58.8 3776 9/10/2020 3 2017 MT 50.2 579 9/10/2020 7 2017 NE 38.5 811 9/10/2020 4 2017/NV 47.8 1496 9/11/2020 1 2017/NH 62.9 907 9/11/2020 17 2017 NJ 47.3 4482 9/11/2020 6 2017 NM 68.2 1460 9/12/2020 0 2017 NY 35.5 7687 9/12/2020 1 2017 NC 56.3 5985 9/12/2020 2 2017 ND 41.3 339 9/13/2020 0 2017 OH 75.1 8971 9/13/2020 10 2017 OK 62.5 2563 9/13/2020 4 2017 OR 44.7 2076 9/14/2020 2 2017 PA 70.2 9527 9/14/2020 9 2017 RI 60.0 718 9/14/2020 33 2017 SC 60.2 3147 9/15/2020 2 2017 SD 56.1 537 9/15/2020 7 2017 TN 63.0 4435 9/15/2020 4 2017 TX 38.8 10763 9/16/2020 0 2017 UT 442 1238 9/16/2020 10