Reference no: EM133434627
Simple Graph:
In this section, you will produce a chart of the past and projected populations of three school districts (SDs) in British Columbia (Table 1). You will then derive additional data, describe, and compare and contrast the three populations.
- Complete Table 1 [Calculate the Annual Growth Rate in percentages to one decimal place] (5)
Year |
Abbotsford SD |
Delta SD |
North Vancouver SD |
Abbotsford SD Annual Growth rate |
Delta SD Annual Growth rate |
North Vancouver SD Annual Growth rate |
1986 |
68890 |
82831 |
108367 |
|
|
|
1991 |
89718 |
92146 |
116599 |
|
|
|
1996 |
110118 |
100021 |
126819 |
|
|
|
2001 |
123476 |
102593 |
134247 |
|
|
|
2006 |
129982 |
100724 |
133681 |
|
|
|
2011 |
137303 |
102839 |
137680 |
|
|
|
2016 |
147982 |
108687 |
148047 |
|
|
|
2021 |
162985 |
113820 |
152756 |
|
|
|
2026 |
172873 |
123727 |
161006 |
|
|
|
2031 |
183234 |
134492 |
169947 |
|
|
|
2036 |
193281 |
145202 |
179160 |
|
|
|
2041 |
202976 |
155582 |
188530 |
|
|
|
Table 1: Populations of Abbotsford, Delta and North Vancouver school districts (1986-2041)
[BC Stats. (2021). Population Estimates & Projections for British Columbia BC Population Estimates & Projections (shinyapps.io)]
- Create an appropriate chart using the data of the total populations against years of the three school districts (SDs) from Table.
- Describe, compare and contrast the data series on your chart. Start with the earliest date, and describe the general trends using dates and population data. Also consider the reasons for these trends (10)
B. Population Pyramid:
Access BCStats' BC Population Estimates & Projections (shinyapps.io) web page for the data for the following college regions (CR) to complete the following Table 2. (Choose College Region for region type, select the two college regions, 2022 for the year, both genders, 5-year age groups, generate output and then download the data as csv -
Age group |
Kwantlen CR Male (%) |
Kwantlen CR Female (%) |
Selkirk CR Male (%) |
Selkirk CR Female (%) |
0 to 9 |
|
|
|
|
10 to 19 |
|
|
|
|
20 to 29 |
|
|
|
|
30 to 39 |
|
|
|
|
40 to 49 |
|
|
|
|
50 to 59 |
|
|
|
|
60 to 69 |
|
|
|
|
70 to 79 |
|
|
|
|
80 and older |
|
|
|
|
Table 2: 2022 male and female populations by 10-year age groups for Kwantlen and Selkirk college regions, as percentages of their respective total populations.
- Complete Table 2 above [Use the percentage for each age group by gender of the respective college region's total population. Calculate to 1 decimal place]
- Create population pyramid(s) using the data from Table 2. Include appropriate title(s), legend(s), and axes [Make the chart(s) half a page in size.
- Describe, compare and contrast the data in your population pyramid(s)