QNT 561 Week 1, Statistics Concepts and Descriptive Measures

$12.00

Category: QNT 561 Tag: qnt 561

Description

QNT 561 Week 1 Assignment, Statistics Concepts and Descriptive Measures

  • 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 functionqnt 561 week 1