The annual income of a family is: $25,500, $54,000, $31,500, $37,500, $39,000 $36,750, $30,500, $35,250, $31,500, $31,500 a) What is the average monthly income? b. How many families earn less than the average? c. Calculate the interquartile rangeC1 andC3? d. Make a bar graph that represents the annual income of these families.

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
Calculate the measures of central tendency (mean, median, and mode)
and the measures of dispersion (range, mean, standard deviation, and
variance) in the examples:
1. The annual income of a family is:
$25,500, $54,000, $31,500, $37,500, $39,000
$36,750, $30,500, $35,250, $31,500, $31,500
a) What is the average monthly income?
b. How many families earn less than the average?
c. Calculate the interquartile rangeC1 andC3?
d. Make a bar graph that represents the annual income of
these families.
Transcribed Image Text:SOLVE IN EXCEL PLEASE STEP BY STEP Calculate the measures of central tendency (mean, median, and mode) and the measures of dispersion (range, mean, standard deviation, and variance) in the examples: 1. The annual income of a family is: $25,500, $54,000, $31,500, $37,500, $39,000 $36,750, $30,500, $35,250, $31,500, $31,500 a) What is the average monthly income? b. How many families earn less than the average? c. Calculate the interquartile rangeC1 andC3? d. Make a bar graph that represents the annual income of these families.
Expert Solution
steps

Step by step

Solved in 6 steps with 6 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
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