Choose one of the following datasets to complete this assignment: I also uploaded Statistics Concepts and Descriptive Measures Data Set.
- Consumer Food
- Financial
- Hospital
Answer each of the following in a clear but concise Word document.
- For each column, identify whether the data is qualitative or quantitative.
- Identify the level of measurement for the data in each column.
- For each column containing quantitative data:
- Evaluate the mean and median
- Interpret the mean and median in plain non-technical terms
- Use the Excel =AVERAGE function to find the mean
- Use the Excel =MEDIAN function to find the median
- For each column containing quantitative data:
- Evaluate the standard deviation and range
- Interpret the standard deviation and range in plain non-technical terms
- Use the Excel =STDEV.S function to find the standard deviation
- For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel’s =MIN function