**Purpose of Assignment **The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel®.

**Assignment Steps**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 your Excel spreadsheet:

- For each column, identify whether the data is qualitative or quantitative.
- For each column, Identify the level of measurement for the data.
- For each column containing quantitative data:
- Evaluate the mean and median as described below
- Use the Excel =AVERAGE function to find the mean
- Use the Excel =MEDIAN function to find the median
- Interpret the mean and median in plain non-technical terms in a total of 90 words

- For each column containing quantitative data:
- Evaluate the standard deviation and range as described below
- 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
** **
- Interpret the standard deviation and range in plain non-technical terms in a total of 90 words

**Submit** your assignment as the **completed Excel spreadsheet**. There is no total word count limit for this assignment. Do not submit a Microsoft Word document.