This is the PLE below

This is the industry mower total sales below

Industry tractor total sales

4. Finally, she wants to know the market share for each product and region by month based on the PLE and industry sales data, and the average market share by region over the five years. Prices for PLE products for the past five years Mower Price Year Tractor Price 2014 $150 $3,250 2015 $175 $3,400 2016 $180 $3,600 2017 $185 $3,700 2018 $190 $3,800 1 Industry Mower Total Sales 2 3 Month NA SA Eur Pac China World 4 Jan-14 60000 571 13091 1045 0 74662 5 *** 77184 611 17679 1111 0 96585 6 Mar-14 77885 658 22759 1068 0 102369 7 Apr-14 86190 778 27966 1237 0 116171 8 *** 96117 886 27895 1313 0 126210 9 **** 97143 882 30566 1176 0 129768 10 Jul-14 84757 848 29444 1359 0 116409 11 79804 735 28364 1238 0 110141 12 * 64800 657 28393 1215 0 95065 13 Oct-14 59307 595 24444 1154 0 85500 14 ## 52157 553 18000 1262 0 71972 15 *** 45049 462 12453 1386 0 59349 16 Jan-15 58627 553 12778 1443 0 73401 17 ##### 76200 615 18214 1515 0 96545 18 Mar-15 82871 658 23889 1373 0108791 19 Apr-15 84904 784 29455 1442 0 116584 20 ##### 93100 846 29464 1215 0 124625 21 ##### 93000 838 27414 1333 0 122585 E 1415 1296 1402 1468 1351 1389 0 112594 0 104164 0 92241 0 81470 0 67386 0 57489 70892 94917 0 104583 0 115211 1509 1402 1524 1574 B C 22 Jul-15 83048 763 27368 23 *** 74854 694 27321 24 60769 625 29444 25 Oct-15 55619 610 23774 26 ## 48155 571 17308 27 **** 42647 512 12941 28 Jan-16 57885 537 10962 29 77647 595 15273 30 Mar-16 81845 659 20556 31 Apr-16 86095 756 26786 32 ** 91776 878 24828 33 # 100680 825 24737 34 Jul-16 86190 756 24828 35 # 71887 714 25179 36 ##### 60000 651 24545 37 Oct-16 55566 643 19286 38 ##### 50857 619 15273 39 ##### 42596 548 9107 40 Jan-17 58095 581 8671 41 ##### 75566 614 13158 42 Mar-17 80286 622 19666 1468 0 118949 0 127801 1560 1441 0 113216 1545 1667 1698 1810 1731 1887 1845 1923 0 99325 0 86863 0 77193 0 68558 0 53982 0 69135 0 91182 0102486 1981 1810 1942 1961 2000 2075 125 113027 142 115832 226 122482 230 114686 122 103729 56 87381 10 76771 0 67105 0 61797 069673 0 94165 43 Apr-17 85140 727 25179 44 * 90093 826 23103 45 95472 783 24286 46 Jul-17 87308 681 24737 74476 646 26607 48 61698 625 22982 49 Oct-17 57238 617 16897 50 50673 587 13750 51 51238 591 7818 52 Jan-18 59712 563 7547 5377961 571 13889 54 Mar-18 83725 625 18302 55 Apr-18 90297 723 25192 56 # 91143 848 24706 57 **** 99320 792 25306 58 Jul-18 93922 745 27083 73143 739 26042 60 66699 667 26304 61 Oct-18 56476 660 22558 62 ##**# 51068 625 14773 63 ##### 46893 608 6977 2019 0 104544 2095 2150 1852 1743 1892 2037 1887 1944 2170 2037 2018 2072 2182 2035 236 118250 542 118583 875 127363 1386 123919 1193 101961 421 95688 81766 0 68648 0 56510 56 1 Industry Tractor Total Sales 3 Month NA SA Eur Pac China World 4 8143 984 987 278 15483 5091 5310 5 8592 1051 1090 283 16325 6 8630 1016 6071 1127 285 17129 17327 7 8947 1027 5856 1209 288 8 8442 1057 5273 1221 286 16278 9 7500 1019 287 15448 10 Jul-14 6145 977 289 15905 5882 290 14422 12 5595 293 14258 13 5233 14 15 4494 3913 5938 6633 7327 8077 16 5315 1327 7170 1324 5926 1268 6075 1209 6321 1168 8381 1127 7944 1085 5688 1185 7037 1286 6981 1286 7500 1346 6571 1388 6990 1449 1057 1086 1045 1078 1029 1172 1273 1423 1612 1728 1815 17 295 14061 298 15378 301 14272 306 14289 302 16530 303 17320 307 18842 309 17826 312 17669 18 19 20 7830 21 7103 22 Jul-15 1776 6667 6762 6635 1490 1449 1685 1679 1394 6311 1256 1618 1564 1522 6239 6036 5664 5345 4831 4454 5299 6529 7120 7619 8387 8110 7752 6894 6015 29 6476 6250 5922 6667 7228 8200 7941 7921 7677 7200 6735 6495 6061 5816 5051 6082 6327 1835 2115 2202 2151 2214 2278 2100 2128 2367 2211 2483 1986 2257 2353 2457 1214 1171 1208 1214 1256 1311 1415 1520 1675 1584 1527 1422 1366 1262 1373 1436 1478 315 16487 318 16250 321 15692 315 14844 318 14402 320 13716 333 14597 313 16836 606 18412 571 19852 556 20513 526 20355 513 19716 769 18575 750 17394 732 16226 714 15587 698 14207 714 14394 1063 17218 1264 19310 34 Jul-16 35 37 39 5368 4964 4444 5000 6284 7785 40 41 42 9934 7604 7789 10645 9491 7347 45 46 Jul-17 2517 2612 2749 2887 2833 2789 9182 8528 8293 8221 2765 7470 6509 7267 8807 54 10168 11044 12120 13459 58 Jul-18 13048 59 12275 60 11347 61 10667 62 10459 63 10082 2746 2534 2635 2703 2795 2997 3131 3311 3390 3277 3232 3131 3087 3030 6979 6489 6316 5833 5789 5591 5106 5474 6022 6064 6344 6593 6304 6064 5789 5699 5604 5444 1512 1642 1667 1733 1700 1642 1576 1493 1450 1010 1045 1106 1150 1244 1357 1421 1263 1173 1128 974 979 1333 22901 1556 24244 1739 22993 1702 22483 1915 21465 2083 21123 2128 20523 2292 19789 2245 18329 2292 18311 2449 20477 2400 22489 2353 23607 2600 25439 2653 27374 2600 26764 2549 25428 2453 23995 2517 23142 2541 22666 2453 21989 4. Finally, she wants to know the market share for each product and region by month based on the PLE and industry sales data, and the average market share by region over the five years. Prices for PLE products for the past five years Mower Price Year Tractor Price 2014 $150 $3,250 2015 $175 $3,400 2016 $180 $3,600 2017 $185 $3,700 2018 $190 $3,800 1 Industry Mower Total Sales 2 3 Month NA SA Eur Pac China World 4 Jan-14 60000 571 13091 1045 0 74662 5 *** 77184 611 17679 1111 0 96585 6 Mar-14 77885 658 22759 1068 0 102369 7 Apr-14 86190 778 27966 1237 0 116171 8 *** 96117 886 27895 1313 0 126210 9 **** 97143 882 30566 1176 0 129768 10 Jul-14 84757 848 29444 1359 0 116409 11 79804 735 28364 1238 0 110141 12 * 64800 657 28393 1215 0 95065 13 Oct-14 59307 595 24444 1154 0 85500 14 ## 52157 553 18000 1262 0 71972 15 *** 45049 462 12453 1386 0 59349 16 Jan-15 58627 553 12778 1443 0 73401 17 ##### 76200 615 18214 1515 0 96545 18 Mar-15 82871 658 23889 1373 0108791 19 Apr-15 84904 784 29455 1442 0 116584 20 ##### 93100 846 29464 1215 0 124625 21 ##### 93000 838 27414 1333 0 122585 E 1415 1296 1402 1468 1351 1389 0 112594 0 104164 0 92241 0 81470 0 67386 0 57489 70892 94917 0 104583 0 115211 1509 1402 1524 1574 B C 22 Jul-15 83048 763 27368 23 *** 74854 694 27321 24 60769 625 29444 25 Oct-15 55619 610 23774 26 ## 48155 571 17308 27 **** 42647 512 12941 28 Jan-16 57885 537 10962 29 77647 595 15273 30 Mar-16 81845 659 20556 31 Apr-16 86095 756 26786 32 ** 91776 878 24828 33 # 100680 825 24737 34 Jul-16 86190 756 24828 35 # 71887 714 25179 36 ##### 60000 651 24545 37 Oct-16 55566 643 19286 38 ##### 50857 619 15273 39 ##### 42596 548 9107 40 Jan-17 58095 581 8671 41 ##### 75566 614 13158 42 Mar-17 80286 622 19666 1468 0 118949 0 127801 1560 1441 0 113216 1545 1667 1698 1810 1731 1887 1845 1923 0 99325 0 86863 0 77193 0 68558 0 53982 0 69135 0 91182 0102486 1981 1810 1942 1961 2000 2075 125 113027 142 115832 226 122482 230 114686 122 103729 56 87381 10 76771 0 67105 0 61797 069673 0 94165 43 Apr-17 85140 727 25179 44 * 90093 826 23103 45 95472 783 24286 46 Jul-17 87308 681 24737 74476 646 26607 48 61698 625 22982 49 Oct-17 57238 617 16897 50 50673 587 13750 51 51238 591 7818 52 Jan-18 59712 563 7547 5377961 571 13889 54 Mar-18 83725 625 18302 55 Apr-18 90297 723 25192 56 # 91143 848 24706 57 **** 99320 792 25306 58 Jul-18 93922 745 27083 73143 739 26042 60 66699 667 26304 61 Oct-18 56476 660 22558 62 ##**# 51068 625 14773 63 ##### 46893 608 6977 2019 0 104544 2095 2150 1852 1743 1892 2037 1887 1944 2170 2037 2018 2072 2182 2035 236 118250 542 118583 875 127363 1386 123919 1193 101961 421 95688 81766 0 68648 0 56510 56 1 Industry Tractor Total Sales 3 Month NA SA Eur Pac China World 4 8143 984 987 278 15483 5091 5310 5 8592 1051 1090 283 16325 6 8630 1016 6071 1127 285 17129 17327 7 8947 1027 5856 1209 288 8 8442 1057 5273 1221 286 16278 9 7500 1019 287 15448 10 Jul-14 6145 977 289 15905 5882 290 14422 12 5595 293 14258 13 5233 14 15 4494 3913 5938 6633 7327 8077 16 5315 1327 7170 1324 5926 1268 6075 1209 6321 1168 8381 1127 7944 1085 5688 1185 7037 1286 6981 1286 7500 1346 6571 1388 6990 1449 1057 1086 1045 1078 1029 1172 1273 1423 1612 1728 1815 17 295 14061 298 15378 301 14272 306 14289 302 16530 303 17320 307 18842 309 17826 312 17669 18 19 20 7830 21 7103 22 Jul-15 1776 6667 6762 6635 1490 1449 1685 1679 1394 6311 1256 1618 1564 1522 6239 6036 5664 5345 4831 4454 5299 6529 7120 7619 8387 8110 7752 6894 6015 29 6476 6250 5922 6667 7228 8200 7941 7921 7677 7200 6735 6495 6061 5816 5051 6082 6327 1835 2115 2202 2151 2214 2278 2100 2128 2367 2211 2483 1986 2257 2353 2457 1214 1171 1208 1214 1256 1311 1415 1520 1675 1584 1527 1422 1366 1262 1373 1436 1478 315 16487 318 16250 321 15692 315 14844 318 14402 320 13716 333 14597 313 16836 606 18412 571 19852 556 20513 526 20355 513 19716 769 18575 750 17394 732 16226 714 15587 698 14207 714 14394 1063 17218 1264 19310 34 Jul-16 35 37 39 5368 4964 4444 5000 6284 7785 40 41 42 9934 7604 7789 10645 9491 7347 45 46 Jul-17 2517 2612 2749 2887 2833 2789 9182 8528 8293 8221 2765 7470 6509 7267 8807 54 10168 11044 12120 13459 58 Jul-18 13048 59 12275 60 11347 61 10667 62 10459 63 10082 2746 2534 2635 2703 2795 2997 3131 3311 3390 3277 3232 3131 3087 3030 6979 6489 6316 5833 5789 5591 5106 5474 6022 6064 6344 6593 6304 6064 5789 5699 5604 5444 1512 1642 1667 1733 1700 1642 1576 1493 1450 1010 1045 1106 1150 1244 1357 1421 1263 1173 1128 974 979 1333 22901 1556 24244 1739 22993 1702 22483 1915 21465 2083 21123 2128 20523 2292 19789 2245 18329 2292 18311 2449 20477 2400 22489 2353 23607 2600 25439 2653 27374 2600 26764 2549 25428 2453 23995 2517 23142 2541 22666 2453 21989