Description
Case Study Part III: Descriptive Statistics
Using the Performance Lawn Equipment dataset, complete the following data manipulation. Each process should be completed on a separate worksheet.
Descriptive Statistics
Complete the process and write a short summary for each of the following:
Worksheet 1 Create a frequency distribution and a histogram for each of the variables in the Customer Survey worksheet
Worksheet 2 – Use the Data Analysis Toolpak to run a Descriptive Statistics process for measures for engine production time in the worksheet Engines
Worksheet 3 – Create a frequency distribution and histogram for the blade weight sample in the worksheet Blade Weight
Worksheet 4 – Use the =COUNTIF() function to determine the proportion of samples that failed the functional performance test in the worksheet Mower Test
Worksheet 5 – Create PivotTables that summarize the data and provide useful insights in the worksheet Employee Retention with gender as the row.
Worksheet 6 – Run a correlation matrix among the satisfaction survey variables in the worksheet Purchasing Survey.
