\fRow Month NA SA Eur Pac China World 24 Dec-15 42647 512 12941 1389 57489 25 Jan-16 57885 537 10962 1509 70892 26 Feb-16 77647 595 15273 1402 94917 27 Mar-16 81845 659 20556 1524 104583 28 Apr-16 86095 756 26786 1574 0 115211 29 May-16 91776 878 24828 1468 118949 30 Jun-16 100680 825 24737 1560 127801 31 Jul-16 86190 756 24828 1441 113216 32 Aug-16 71887 714 25179 1545 99325 33 Sep-16 60000 651 24545 1667 0 86863 34 Oct-16 55566 643 19286 1698 77193 35 Nov-16 50857 619 15273 1810 0 68558 36 Dec-16 42596 548 9107 1731 0 53982 37 Jan-17 58095 581 8571 1887 0 69135 38 Feb-17 75566 614 13158 1845 0 91182 39 Mar-17 80286 622 19655 1923 0 102486 40 Apr-17 85140 727 25179 1981 125 113027 41 May-17 90093 826 23103 1810 142 115832 42 Jun-17 95472 783 24286 1942 226 122482 43 Jul-17 87308 681 24737 1961 230 114686 44 Aug-17 74476 646 26607 2000 122 103729 45 Sep-17 61698 625 22982 2075 56 87381 46 Oct-17 57238 617 16897 2019 10 76771 47 Nov-17 50673 587 13750 2095 0 67105 48 Dec-17 51238 591 7818 2150 0 61797 49 Jan-18 59712 563 7547 1852 0 69673 50 Feb-18 77961 571 13889 1743 0 94165 51 Mar-18 83725 625 18302 1892 0 104544 52 Apr-18 90297 723 25192 2037 236 118250 53 May-18 91143 848 24706 1887 542 118583 54 Jun-18 99320 792 25306 1944 875 127363 55 Jul-18 93922 745 27083 2170 1386 123919 56 Aug-18 73143 739 26042 2037 1193 101961 57 Sep-18 66699 667 26304 2018 421 95688 58 Oct-18 56476 660 22558 2072 56 81766 59 Nov-18 51068 625 14773 2182 0 68648 60 Dec-18 46893 608 6977 2035 56510Sign in to Pearson MyLab online.The data file for the Performance Lawn Equipment database is located in the Stat Crunch link in the Pearson MyLab online. Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database. First, she would like you to edit the worksheets Deaier Satisfaction and End-User Satisfaction to display the total number of responses to each level of the survey scale across all regions for each year. Second, she wants a count of the number of failures in the worksheet Mower Test Next, Elizabeth has provided you with prices for PLE products for the past five years: Year Mower Tractor Price Price ($1 ($1 201 4 1 50 3,250 201 5 1 75 3,400 201 6 1 80 3,600 201 7 1 85 3,700 201 B 1 90 3,300 Create a new worksheet in the database to compute gross revenues by month and region, as well as worldwide totals, for each product using the data in Mower Unit Saiesand Tractor Unit Saies. Finally, she wants to knew the market share for each product and region based on the PLE and industry sales data in the database. Create and save these calculations in a new worksheet. Summarize all your findings in a report to Ms- Burke and upload your Word document AND your Excel worksheet file to the Assignment drop box. Parameters I The assignment should be double-spaced. 12-point Times New Roman font, with one-inch margins I Use APA for citing references and quotations I See the case study rubric below for more details I Due: Sunday at 1 1 :59 p.m. ET Plagiarism You are expected to write primarily in your own voice, using paraphrase, summary. and synthesis techniques when integrating information from class and outside sou rces. Use an author's exact words only when the language is especially vivid, unique, or needed for technical accuracy, Failure to do so may result in charges of academic dishonesty, lO'verusing an authoris exact words, such as including block quotations to meet word counts, may lead your readers to conclude that you lack appropriate comprehension of the subject matter or that you are neither an original thinker nor a skillful writer. Case Studyr Rubric Criteria Ratings P'Ls KMW'EdQe 0' 20 to >1a.u pts 13 to 2-15.:1 pts 15 to no.0 pts 11:- m >0 pts 20 pts Material Accomplished Meets Expectations Satisfactory Needs Shows extensive Shows good Shows basic Improvement understanding of the understanding of the understanding of some Shows little or no material in the case material in the case material in the case understanding of study, without errors. study, with some study, with several the material. errors. errors. O'Qar'izatlon and 1G- to 3-9.!) pts 9 to 51!] pts 7 to 54.0 pt: 4 to >11 pts 10 [3'55 Presentation Accomplished Meets Expectations Satisfactory Needs Improvement Provides a clear explanation of case study problems and Case study mate rial is explained, with most questions Provides limited explanation of case study material' and Case study material is poorly explained, and questions of case solutions. answered. questions of the case study are unanswered. study are unanswered. Analytic 1a to see pts 9 to >10 pts 7 to >44} pts 4m :43 pts 10 pts Applications and Accomplished Meets Expectations Satisfactory Needs Content Provides clear Demonstrates Application of Improvement strategies and knowledge of strategies, strategies is limited or Minimal analysis information for with some accurate done incorrectly for of content is accurate decision decision making shown. decision making. given. making. Communication 5 pts 35 P15 2 P15 0 PTS 5 pts Accomplished Meets Expectations Satisfactory Needs Improvement Excellent explanation Thoroughly explains Has difficulty Explanations for explaining the reason for the the decision, with so me detail. of the decision is given in detail. decisions are usually confusing and unclear. decision