Elizabeth Berk 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 you 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 to counter the number of failures in the worksheet lower test next in Elizabeth has provided you with prices for ple products for the past 5 years from 2014 to 2018 the mower prices 150 for 2014 so on 175 180 185 190 and the prices for tractor price 3250 3400 3600 3,73800 create a new worksheet to compute gross revenues by month and region as well as worldwide totals for each product using the data and motor unit sales and tractor unit sales finally she wants to know the market value 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 5 years summarize all your findings and report to miss Burk l

please show work and fornulas for excel thank you the last two questions I'm having trouble with I have posted the data for them.

10, 898 \$3600 Go cach prolot woy Hodite 10, 898 \$3600 Go cach prolot woy Hodite