Choose one of the following data sets to complete this question: Consumer Food Financial Hospital
Answer each of the following: 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

Transcribed Image Text:

Region: Location: Annual mortgage 1= NE 21= Metro Food Househol househol = MW 3 2= 4 = Outside Non Annual Spending d income d debt =S (S) ($) (S) Metro 56697 8909 23180 5684 35945 7052 10706 52687 16149 14112 74041 21839 13855 63182 18866 15619 79064 21899 25981 2694 8774 9127 57424 15766 13514 72045 27685 6314 38046 8545 7622 52408 28057 41405 4322 6998 3805 29684 4806 49246 13592 6674 7347 41491 4088 2911 26703 15876 48753 Consumer Food 8026 16714 Financial Hospital