Case Study – Performance Lawn Equipment

Elizabeth Burke has identified some additional questions she would like you to answer:

1. According to the 2014 Customer Survey worksheet, are there significant differences in ratings of specific product/service attributes?
2. According to the worksheet On-Time Delivery, has the proportion of on-time deliveries in 2014 significantly improved since 2010?
3. Have the data in the worksheet Defects After Delivery changed significantly over the past five years?
4. Although engineering has collected data on alternative process costs for building transmissions in the worksheet Transmission Costs, why didn’t they reach a conclusion as to whether one of the proposed processes is better than the current process?
5. According to the data in the worksheet Employee Retention, are there differences in employee retention due to gender, college graduation status, or whether the employee is from the local area?

Conduct appropriate statistical analyses and hypothesis tests to answer these questions and summarize your results in a formal report to Ms. Burke. Upload your Word document AND your Excel worksheet file to the assignment drop box.