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. You can meet the word count by only including your statistical response and short descriptions. You have one attempt at this assignment:
· 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:
· Compute 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:
· Compute 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
Submit your assignment as an Excel spreadsheet with your answers highlighted or in a table in an APA paper. You only have one attempt at this assignment.