how do I answer question 1 with the Excel sheets that's provided in the bottom left and on the right is an example of how the charts look like

Questions: PLANIOS SEC in the City- Assignment 2 Using the characteristics/statistics available for the census subdivisions for both the City of Waterloo #1. Figure I: Sex-age Structure of Population and your hometown (hereafter referred to as "communities"), answer the following questions. Ensure that for each question, appropriate figures (charts) are generated, properly titled, labeled, incorporated, Waterloo Population % by Age Group and explained in your response. 80 0 84 years (1) Using the age/sex data conduct a basic demographic comparison between your two communities. 70 te 74 years do to 64 years Include population pyramids for each community. Compare and contrast the two communities, 5 10 54 years incorporating the dependency ratio into your discussion. What might account for the differences 40 80 44 years MENT between the communities? (Explanation 5, charts/data 5) (10 marks) 10 to 34 years WOMEN'S 20 te 24 years 10 0 14 years B C D E G H 0 be 4 years waterloo Kingston 610 -4.00 -2.09 2.00 4.00 600 2 Topic Characteristics Male dummy Female Male dummy Female Percentage of Population Age characteristics 0 to 4 years 2440 -2440 2300 3040 -3040 2835 Figure 1: Sex-age Structure of Population Age characteristics 5 to 9 years 2900 -2900 2689 3160 -3160 3100 6 Age characteristics 10 to 14 years 3100 -3100 3020 Kingston Population % by Age Group 3100 -3100 2880 7 Age characteristics 15 to 64 years 37030 -37030 36340 39880 39880 41800 80 to 84 years B Age characteristics 15 to 19 years 1875 3875 3560 3445 -3445 3410 70 te 74 years 9 Age characteristics 20 to 24 years 5285 6285 5420 4640 4640 4855 60 50 64 years 0 Age characteristics 25 to 29 years 4175 4175 3435 4595 4595 4560 50 10 54 years 1 Age characteristics 30 to 34 years 3110 -3110 4130 4130 4110 40 10 14 years MENT 12 Age characteristics 35 to 39 years 2955 -2955 2995 3735 -3735 3700 30 ke 34 years WOMEN'S 13 Age characteristics 40 to 44 years 3155 -3155 3425 3360 -3360 3425 20 to 14 years 14 |Age characteristics 45 to 49 years 3505 -3505 3905 3690 -3690 3960 10 te 14 years 15 Age characteristics 50 to 54 years 3780 -3780 4020 1535 4535 4780 0 to 4 years 6 Age characteristics 55 to 59 years 3485 -3485 3535 4075 4075 4755 -500 -400 -300 -200 -10 0:00 140 200 309 00 509 6.30 17 Age characteristics 60 to 64 years 2700 -2700 3005 3670 -3670 4240 Percentage of Population 8 Age characteristics 65 years and over 7015 7015 8159 10410 10410 13600 9 Age characteristics 65 to 69 years 2350 2350 2555 3285 3285 3965 D Age characteristics 70 to 74 years 1625 -1625 1840 2545 2545 3000 1 Age characteristics 75 to 79 years 1155 -1155 1395 1865 -1865 2315 2 Age characteristics 80 to 84 years 890 890 1085 1430 -1430 1960 3 Age characteristics 85 years and over 995 995 1275 1280 -1280 2360