QUESTION

# Statistics Concepts and Descriptive Measures

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

Choose one of the following datasets to complete this assignment:

• Consumer Food
Files: QNT561_r9_Statistics_Concepts_and_Descriptive_Measures_Data_Set.xlsx
• @
• 25 orders completed
Tutor has posted answer for $10.00. See answer's preview$10.00
**** ****** *** *** are default ********* ********* in ***** ***** make *********** ********** ** the average ** a group of data ****** ** *** ******* data point **** *** *** **** ****** *** ******** ** either ********** or ************* ******* ********** *** ******* **** ***** of *** *** Annual **** ******** *** Annual ********* Income *** *** mortgage ********* **** ($) Region: * * ** * * ** * * * 4 * * ********* * * ***** * = Outside Metro 8909 56697 ***** * 1 **** ***** 7052 * * ***** 52687 ***** * * ***** 74041 ***** 1 1 ***** 63182 ***** * 1 ***** ***** ***** * * **** ***** **** * * **** 57424 ***** 1 * 13514 72045 ***** * * or • @ • 161 orders completed ANSWER Tutor has posted answer for$20.00. See answer's preview