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.

Alandlord rented an art studio to an artist. under the terms of the signed, written, two-year lease, the artist agreed to pay the landlord $1,000 per month and to assume responsibility for all necessary repairs. after the first year of the lease, the artist assigned the balance of his lease to a sculptor. the landlord approved the sculptor as a tenant and accepted two rent payments from her, and then the landlord sold the building to an investor. the sculptor had made two payments to the investor when an electrical fire broke out in the studio, injuring the sculptor. the fire was caused by faulty wiring. the landlord was aware that there was a dangerous wiring problem when he leased the property to the artist. but when the landlord discovered how costly repairs would be, he decided it would be more profitable to sell the property than to repair it. the problem was not easily discoverable by anyone other than an expert electrician, and the landlord did not tell the artist, the sculptor, or the investor about the problem. the sculptor sues to recover damages for her injuries. from whom can the sculptor recover?

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?

Is exploiting a distinctive competence or improving efficiency for competitive advantage. (a) cooptation (b) coalition (c) competitive intelligence (d) competitive aggression (e) smoothing