Evaluate the standard deviation and range Interpret the standard deviation and range in plain non-technical terms

This assignment has an Excel dataset spreadsheet attached. You will be required to only do one of the three datasets. Resource: Microsoft Excel, Statistics Concepts and Descriptive Measures Data Set Download the Statistics Concepts and Descriptive Measures Data Set. Choose one of the following datasets to complete this assignment: Consumer Food Financial Hospital 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 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