Consumer Food, Financial, or Hospital Excel dataset, statistics homework help

/in /by

Consumer Food, Financial, or Hospital Excel dataset, statistics homework help

Download the Consumer Food, Financial, or Hospital Excel dataset. Please note: you have to work on only ONE dataset and not ALL.

(15 points) For each column, identify whether the data is qualitative or quantitative.

(15 points) Identify the level of measurement for the data in each column.

(30 points) For each column containing quantitative data, evaluate the mean and median. Interpret the mean and median in plain non-technical terms. Use Excel’s =AVERAGE function to find the mean. Use Excel’s =MEDIAN function to find the median.

(30 points) For each column containing quantitative data, evaluate the standard deviation and range. Interpret the standard deviation and range in plain non-technical terms. Use Excel’s =STDEV.S function to find the standard deviation. For Range, find the maximum value using the Excel’s =MAX function and find the minimum value using the Excel’s =MIN function. Range is maximum value minus the minimum value.