Statistics Concepts and Descriptive Measures
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
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer