Statistics Concepts and Descriptive Measures

Need help with my Statistics question – I’m studying for my class.

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:
  • 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
 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support