The spreadsheet is at this link: https://media.pearsoncmg.com/ph/bp/bridgepages/teamsite/evans/ (click on link for online data files under the "Business Analytics, 2/e" - the spreadsheet being used is entitled Performance Lawn Equipment within the zip file)
Performance Lawn Equipment Elizabeth Burke wants some detailed statistical information about much of the data in the PLE database. In particular, she wants to know the following:
a. the mean satisfaction ratings and standard deviations by year and region in the worksheets Dealer Satisfactionand End-User Satisfaction
b. a descriptive statistical summary for the 2012 customer survey data
c. how the response times differ in each quarter of the worksheet Response Time
d. how defects after delivery (worksheet Defects after Delivery) have changed over these 5 years
e. how sales of mowers and tractors compare with industry totals and how strongly monthly product sales are correlated with industry sales
(I'm stuck on part a - how do you calculate the mean and standard deviation of the results in the dealer satisfaction worksheet? They only list the number of survey responses (for example, the year 2010 in North America received 1 zero survery score, no 1's, 2 2's, 14 3's, 22 4's, and 11 5's)