Case: Performance Lawn Equipment Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database.

1. Count the number of failures in the worksheet Mower Test. (Hint: Use the Countif function)

2. Next, Elizabeth has provided you with prices for PLE products for the past 5 years:

Year Mower Price ($) Tractor Price ($)

2010 150 3,250

2011 175 3,400

2012 180 3,600

2013 185 3,700

2014 190 3,800

Create a new worksheet in the database named ‘Gross revenues’ 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.

3. Finally, in the Industry Mower Total Sales and Industry Tractor Total Sales worksheets, add a column, at the end that displays the region that has the highest sales for each month (for each row). You are free to use any combination of excel functions we have come across.

4. List any inferences you can make from the data given in the Dealer Satisfaction and User Satisfaction worksheets.