Question: 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
Get step-by-step solutions from verified subject matter experts
