7. The following are numerical statistics for five data sets. Using Excel's statistical functions, complete the following questions. DATA SET MEAN MEDI 1 50 50 RANGE 6 R 2 2 70 100 100 3 25 15 92 4 44.5 60 5 33 0 . ཁྱ ཚོང་ 47 22 100 +1 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.

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter11: Data Analysis And Probability
Section11.2: Box-and-whisker Plots
Problem 2E
icon
Related questions
Question
Don’t solve i will dislike ?
7. The following are numerical statistics for five data sets. Using Excel's statistical functions, complete the
following questions.
DATA SET
MEAN
MEDI
1
50
50
RANGE
6
R
2
2
70
100
100
3
25
15
92
4
44.5
60
5
33
0
. ཁྱ ཚོང་
47
22
100
+1
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.
Transcribed Image Text:7. The following are numerical statistics for five data sets. Using Excel's statistical functions, complete the following questions. DATA SET MEAN MEDI 1 50 50 RANGE 6 R 2 2 70 100 100 3 25 15 92 4 44.5 60 5 33 0 . ཁྱ ཚོང་ 47 22 100 +1 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.
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
PREALGEBRA
PREALGEBRA
Algebra
ISBN:
9781938168994
Author:
OpenStax
Publisher:
OpenStax