The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel® prior to the course start.
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:
o Evaluate the mean and median o Interpret the mean and median in plain non-technical terms o Use the Excel =AVERAGE function to find the mean o Use the Excel =MEDIAN function to find the median
For each column containing quantitative data: o Evaluate the standard deviation and range o Interpret the standard deviation and range in plain non-technical terms o Use the Excel =STDEV.S function to find the standard deviation o 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