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.

1. 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)]

1. Create an appropriate chart using the data of the total populations against years of the three school districts (SDs) from Table.
2. 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.

1. 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]
2. 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. 
3. Describe, compare and contrast the data in your population pyramid(s)