Statistics Concepts and Descriptive Measures

Resource: Microsoft Excel^®, Statistics Concepts and Descriptive Measures Data Set

Answer each of the following in a total of 90 words:

• 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