#3 On January 11, 2005, the Gallup Organization released the results of a poll investigating how many Americans have private health insurance. The results showed that among Americans making less than $30, 000 per year, 33% had private insurance, 50% were covered by Medicare/Medicaid, and 17% had no health insurance, while among Americans making $75, 000 or more per year, 87% had private insurance, 9% were covered by Medicare/Medicaid, and 4% had no health insurance. a. Use bar and pie charts to compare health coverage of the 2 income groups.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 25PPS
icon
Related questions
Question

Please do this in excel please

# 3 On January 11, 2005, the Gallup Organization released the results of a poll investigating how
many Americans have private health insurance. The results showed that among Americans
making less than $30, 000 per year, 33% had private insurance, 50% were covered by
Medicare/Medicaid, and 17% had no health insurance, while among Americans making $75,
000 or more per year, 87% had private insurance, 9% were covered by Medicare/Medicaid, and
4% had no health insurance.
a. Use bar and pie charts to compare health coverage of the 2 income groups.
Transcribed Image Text:# 3 On January 11, 2005, the Gallup Organization released the results of a poll investigating how many Americans have private health insurance. The results showed that among Americans making less than $30, 000 per year, 33% had private insurance, 50% were covered by Medicare/Medicaid, and 17% had no health insurance, while among Americans making $75, 000 or more per year, 87% had private insurance, 9% were covered by Medicare/Medicaid, and 4% had no health insurance. a. Use bar and pie charts to compare health coverage of the 2 income groups.
Expert Solution
steps

Step by step

Solved in 2 steps with 4 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
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
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
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax