Question: 7. The following are numerical statistics for five data sets. Using Excel's statistical functions, complete the following questions. DATA SET 1 2 3 4

7. The following are numerical statistics for five data sets. Using Excel's statistical functions, complete the following questions. DATA SET 1 2 3 4 5 MEAN 50 70 25 50 33 MEDIAN 50 100 15 44.5 0 RANGE 6 100 92 60 100 SD 2 47 25 22 41 a. Compare the data sets with regard to measures of central tendency. Does the mean equal the median for each data set? What does it mean if they are equal? Comment on each data set. b. Are any data sets similar? Do some data sets appear similar with regard to measures of central tendency but different with regard to measures of dispersion? Comment on each data set.
Step by Step Solution
There are 3 Steps involved in it
a The measures of central tendency used are mean and median If mean is equal to the median ... View full answer
Get step-by-step solutions from verified subject matter experts
