Elizabeth Burke has recently joined the PLE management team to oversee production operations. She has reviewed the types of data that the company collects and has assigned you the responsibility to be her chief analyst in the coming weeks. She has asked you to do some preliminary analysis of the data for the company.-------------------------------------
First, she would like you to edit the worksheets Dealer 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 Price Tractor Price
2014 150 3250
2015 175 3400
2016 180 3600
2017 185 3700
2018 $190 3800
Create a new worksheet to compute gross revenues by month and region, as well as worldwide totals, for each product using the data in Mower Unit Sales and Tractor Unit Sales.
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.
Summarize all your findings in a report to Ms. Burke.