Tuesday, October 22, 2019

Assignment 3: Data Update 2

Update 2
1. Lead:

This assignment demonstrates the trend how the proportion of English, French and Non-official languages shift. And reflect the immigration frequency in recent 50 more years. Here is the chart showed below which called Population percentage of different mother tongue in British Columbia from 1951 to 2016.

2. Excel Workbook Link and Explanation:


Link: https://docs.google.com/spreadsheets/d/1k2K4WtD5Ocg4ZiUx5tzY3NZtq9cJI7NVeQnlrzFH3Y4/edit?usp=sharing
Explanation: This data set looks at the population percentage of different mother tongue in British Columbia from 1951 to 2016. It differs into three mother tongues: French, English, Non-official Languages. The units in number are percentages. The raw data also have volume of each time period population. Due to the numbers of exact population are not that useful to evaluate,  I deleted the volume rows. 

3. Original Data set Link:


Click here to see original data set.

4. News Story/Study Link and Brief Summary:

Link: https://www150.statcan.gc.ca/n1/pub/11-630-x/11-630-x2018001-eng.htm

Here is the new story/study of that I found for the assignment. In this study, it indicates the mother tongue of Canadian at the beginning of the 20th century are French and English.In 1901, about one in ten people declared their mother tongue as an indigenous or immigrant language. It was not until 1941 that the concept of mother tongue was defined in the Canadian Census, which was defined as the first language of childhood learning at home and can still be understood today.However, In the next 115 years, Canadian language features have become more diverse, the reason is there were more and more immigration and aboard students came to Canada. Thus the proportion of English and French speakers decreased.

Monday, October 7, 2019

Assignment 2: Data Update 1


Data Update 1


1. What data set will you use for your final report? (describe your data set, include a link to it and claim it at the URL above).
I'm going to use a data set named Air passenger traffic at Canadian airports, annual, which is from Statistics Canada.

2. Describe the data set. What kind of data does it contain?
This data set was illustrated by several information: airport distribution, air passenger type, volumes and times. By using these information this table evaluate the volume of different type of air passengers in several area between 2014 to 2018.


3. Is there anything about your data that you don’t understand? (i.e. what a column heading means). How will you find this out?
No, I understand everything about this table. And I think all of this chart is simply comprehensive. 

4.What are some questions you hope to answer with your data? List at least three.

  a. Which airport has the most volume of domestic passengers in 2018?
  b. In which year Vancouver International airport had most trans-border passengers?
  c. How many passengers total in Calgary International airport at 2014?
This data set was illustrated by several information: airport distribution, air passenger type, volumes and times. By using these information this table evaluate the volume of different type of air passengers in several area between 2014 to 2018.