Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Excel file Internet Usage provides data about users of the Internet. Construct stacked bar charts (I need to know how to construct my own
The Excel file Internet Usage provides data about users of the Internet. Construct stacked bar charts (I need to know how to construct my own graph in excel myself--step by step guide {for example highlight a certain column}) that will allow you to compare any differences due to age or educational attainment and draw any conclusions that you can. Would another type of charts be more appropriate? The Data is as follows:
Internet Usage: 2009 | US Census Bureau | |||
.Age | No Internet | Internet | Broadband | Dialup |
..Under 25 years | 2,192 | 4,443 | 4,263 | 151 |
..25-34 years | 5,103 | 14,707 | 14,095 | 496 |
..35-44 years | 4,931 | 17,249 | 16,250 | 913 |
..45-54 years | 6,052 | 18,982 | 17,610 | 1,255 |
..55 years and older | 19,078 | 26,558 | 23,574 | 2,834 |
Educational attainment of individuals 25 years and older | No Internet | Internet | Broadband | Dialup |
..Less than high school graduate | 9,294 | 4,417 | 3,808 | 588 |
..High school graduate | 14,023 | 18,967 | 16,842 | 2,000 |
..Some college or associate's degree | 7,841 | 23,210 | 21,424 | 1,612 |
..Bachelor's degree or higher degree | 4,006 | 30,903 | 29,455 | 1,297 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started