qnt/561-spreadsheet

You may submit this assignment in an Excel spreadsheet, or in Word. Make sure you show your calculations and follow APA format (i.e. in-text citations; Reference page; headings; etc.)

Download the Statistics Concepts and Descriptive Measures Data Set.

Choose one of the following datasets to complete this assignment: (hint: you will use the same dataset for the Signature Assignment due Week 6)

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