**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^{®} prior to the course start.** **

**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 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:
- o Evaluate the mean and median
- o Interpret the mean and median in plain non-technical terms
- o Use the Excel =AVERAGE function to find the mean
- o Use the Excel =MEDIAN function to find the median

- For each column containing quantitative data:
- o Evaluate the standard deviation and range
- o Interpret the standard deviation and range in plain non-technical terms
- o Use the Excel =STDEV.S function to find the standard deviation
- o 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

**Click **the Assignment Files tab to submit your assignment.

**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^{®} prior to the course start.** **

**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 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:
- o Evaluate the mean and median
- o Interpret the mean and median in plain non-technical terms
- o Use the Excel =AVERAGE function to find the mean
- o Use the Excel =MEDIAN function to find the median

- For each column containing quantitative data:
- o Evaluate the standard deviation and range
- o Interpret the standard deviation and range in plain non-technical terms
- o Use the Excel =STDEV.S function to find the standard deviation
- o 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

**Click **the Assignment Files tab to submit your assignment.

**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^{®} prior to the course start.** **

**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 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:
- o Evaluate the mean and median
- o Interpret the mean and median in plain non-technical terms
- o Use the Excel =AVERAGE function to find the mean
- o Use the Excel =MEDIAN function to find the median

- For each column containing quantitative data:
- o Evaluate the standard deviation and range
- o Interpret the standard deviation and range in plain non-technical terms
- o Use the Excel =STDEV.S function to find the standard deviation
- o 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

**Click **the Assignment Files tab to submit your assignment.

**Purpose of Assignment **

**Purpose of Assignment ****Purpose of Assignment **Purpose of Assignment

^{®} prior to the course start.** **

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^{®} prior to the course start.** **^{®}** **

**Assignment Steps**

**Assignment Steps****Assignment Steps**Assignment Steps

^{®} dataset spreadsheet attached. You will be required to only do one of the three datasets.

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

**Resource:** Microsoft Excel^{®}, Statistics Concepts and Descriptive Measures Data Set**Resource:**Resource: Microsoft Excel^{®}, Statistics Concepts and Descriptive Measures Data Set^{®}

**Download** the Statistics Concepts and Descriptive Measures Data Set.

**Download** the Statistics Concepts and Descriptive Measures Data Set. **Download**Download the Statistics Concepts and Descriptive Measures Data Set.

**Choose** one of the following datasets to complete this assignment:

**Choose** one of the following datasets to complete this assignment:**Choose**Choose one of the following datasets to complete this assignment:

- Consumer Food
- Financial
- Hospital

Consumer Food

Financial

Hospital

**Answer** each of the following in a total of 90 words:

**Answer** each of the following in a total of 90 words:**Answer**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:
- o Evaluate the mean and median
- o Interpret the mean and median in plain non-technical terms
- o Use the Excel =AVERAGE function to find the mean
- o Use the Excel =MEDIAN function to find the median

- For each column containing quantitative data:
- o Evaluate the standard deviation and range
- o Interpret the standard deviation and range in plain non-technical terms
- o Use the Excel =STDEV.S function to find the standard deviation
- o 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

For each column, identify whether the data is qualitative or quantitative.

Identify the level of measurement for the data in each column.

- o Evaluate the mean and median
- o Interpret the mean and median in plain non-technical terms
- o Use the Excel =AVERAGE function to find the mean
- o Use the Excel =MEDIAN function to find the median

For each column containing quantitative data:

- o Evaluate the mean and median
- o Interpret the mean and median in plain non-technical terms
- o Use the Excel =AVERAGE function to find the mean
- o Use the Excel =MEDIAN function to find the median

o Evaluate the mean and median

o Interpret the mean and median in plain non-technical terms

o Use the Excel =AVERAGE function to find the mean

o Use the Excel =MEDIAN function to find the median

- o Evaluate the standard deviation and range
- o Interpret the standard deviation and range in plain non-technical terms
- o Use the Excel =STDEV.S function to find the standard deviation
- o 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

For each column containing quantitative data:

- o Evaluate the standard deviation and range
- o Interpret the standard deviation and range in plain non-technical terms
- o Use the Excel =STDEV.S function to find the standard deviation
- o 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

o Evaluate the standard deviation and range

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

o Use the Excel =STDEV.S function to find the standard deviation

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

**Click **the Assignment Files tab to submit your assignment.

**Click **the Assignment Files tab to submit your assignment.**Click **Click the Assignment Files tab to submit your assignment.