Statistics Concepts and Descriptive Measures

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
*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

Get a 15 % discount on an order above $ 100
Use the following coupon code :
A+answer