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 

Click the Assignment Files tab to submit your assignment.

• 1503235578-Statistics Concepts and Descriptive Measures Data Set QNT 561 data worksheet.xlsx

AccountingQueen

(3)

Status NEW Posted 20 Aug 2017 01:08 PM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)

• Buy Answer