Download the Statistics Concepts and Descriptive Measures Data
Set.
Choose:
• Financial
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
Annual Food Spending ($) Annual Household Income
mortgage household debt ($)
8909 56697 23180
5684 35945 7052
10706 52687 16149
14112 74041 21839
($) Non