a. Make a frequency distribution showing cumulative frequencies and cumulative relative frequencies. b. Make a histogram of this distribution. c. Evaluate measures of central tendency. d. Calculate the measures of dispersion.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
icon
Related questions
Question
100%
SOLVE IN EXCEL PLEASE
STEP BY STEP
INSTRUCTIONS:
Calculate the measures of central tendency (mean, median, and mode)
and the measures of dispersion (range, mean, standard deviation, and
variance) in the examples:
3. In a study, a reasoning test was applied to a school group of 10-
year-old girls and boys, the scores shown in the table were obtained:
80
99
103
107
107
96
108
87
88
100
112
81
114
99
103
108
95
104
85
97
a. Make a frequency distribution showing cumulative frequencies
and cumulative relative frequencies.
b. Make a histogram of this distribution.
c. Evaluate measures of central tendency.
d. Calculate the measures of dispersion.
96
112
94
102
87
109
95
92
Transcribed Image Text:SOLVE IN EXCEL PLEASE STEP BY STEP INSTRUCTIONS: Calculate the measures of central tendency (mean, median, and mode) and the measures of dispersion (range, mean, standard deviation, and variance) in the examples: 3. In a study, a reasoning test was applied to a school group of 10- year-old girls and boys, the scores shown in the table were obtained: 80 99 103 107 107 96 108 87 88 100 112 81 114 99 103 108 95 104 85 97 a. Make a frequency distribution showing cumulative frequencies and cumulative relative frequencies. b. Make a histogram of this distribution. c. Evaluate measures of central tendency. d. Calculate the measures of dispersion. 96 112 94 102 87 109 95 92
Expert Solution
steps

Step by step

Solved in 3 steps with 10 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill