#7 The Excel file Internet Usage provides data about users of the internet. Construct stacked bar charts 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? #2 In the Excel file Facebook Survey, find the average and median hours online/week and number of friends in the sample using the appropriate the appropriate Excel functions. Compute the midrange and compare all measures of location. Facebook Survey Student Gender Hours online/week 1 female 4 2 female 10 3 male 7 4 male 15 5 female 9 6 female 5 7 female 7 8 male 5 9 female 12 10 female 2 11 female 6 12 female 2 13 male 3 14 female 6 15 male 6 16 male 4 17 female 8 18 male 10 19 female 4 20 male 4 21 male 6 22 female 4 23 female 5 24 female 9 25 female 12 26 male 8 27 female 2 28 female 7 29 male 6 30 male 4 31 female 2 32 male 5 33 female 7 Friends 150 400 120 500 260 70 90 250 110 30 80 30 200 240 150 90 340 450 50 120 180 280 60 100 380 430 80 170 90 50 50 70 170 Internet Usage: 2009 US Census Bureau .Age ..Under 25 years ..25-34 years ..35-44 years ..45-54 years ..55 years and older No Internet Internet Broadband Dialup 2,192 4,443 4,263 151 5,103 14,707 14,095 496 4,931 17,249 16,250 913 6,052 18,982 17,610 1,255 19,078 26,558 23,574 2,834 Educational attainment of individuals 25 years and older ..Less than high school graduate ..High school graduate ..Some college or associate's degree ..Bachelor's degree or higher degree No Internet Internet Broadband Dialup 9,294 4,417 3,808 588 14,023 18,967 16,842 2,000 7,841 23,210 21,424 1,612 4,006 30,903 29,455 1,297