statistics concepts and descriptive measures 21

Purpose of Assignment

The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics.

Special Note

All calculations must be performed within Excel using Excel formulas or functions, the Analysis ToolPak, StatPlus, or a similar statistical software. Formulas or results copied and pasted into Excel will be considered plagiarism and will result in earning a zero for the assignment.

Assignment Steps

This assignment has an Excel® dataset spreadsheet attached. You will be required to only do one of the three datasets.

Choose one of the following datasets to complete this assignment:

  • Consumer Food
  • Financial
  • Hospital

Within the Excel file, answer the following:

  • For each column, identify whether the data is qualitative or quantitative.
  • For each column, Identify the level of measurement (nominal, ordinal, interval, ratio) for the data.
  • For each column containing quantitative data:
  • Use the Excel =AVERAGE function to find the mean
  • Use the Excel =MEDIAN function to find the median
  • Evaluate the mean and median in plain non-technical terms relative to what they say about the data
  • For each column containing quantitative data:
  • Use the Excel =STDEV.S function to find the standard deviation
  • Use the Excel =VAR.S function to find the variance
  • Use the Excel =MAX and =MIN functions to find the range (range = MAX – MIN)
  • Evaluate the standard deviation, variance, and range in plain non-technical terms relative to what they say about the data


0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.