Variables: GEO: 10751x1 cell array of character vectors GRADE: 10751x1 cell array of character vectors SEX: 10751x1 cell array of character vectors NUM: 10751x1 double Values: Min Median 7041 5.1259e+06 Max YEAR: 10751x1 double Values: Min Median 1997 2005 2013 Max Exercise 2 For this exercise, please create a new script called Labo3_schools STUDENTNUMBER.m. In the same OWL folder as this laboratory work sheet, you will find a file named schools.csv. Upload this file in the same folder as your script. This data set was downloaded from Statistics Canada as a CSV file. It gives the number of children in schools in Canada, stratified by provinces/territories, Grade level, gender and year. a) Import the data set schools.csv in a MATLAB table and print a summary of this data set. b) There are five variables (columns) in this table. Convert the ones that should be in string in the string type, the ones that should be unsigned integer in uint32 type. Print out another summary to check that the type conversion is made. c) Display the unique values taken by the variables GEO, GRADE and SEX. d) Create a new table that is a subset of the whole dataset containing only the numbers for both sexes of all grades (Total grades) in Canada. Use this table to plot the evolution of these numbers by years. Your figure should look like Figure 2. e) Plot for the regions Alberta, Nunavut, Ontario and Nova Scotia, the evolution of the enrolment for Grade 1 and Grade 6, for males and females. Use subplots and a custom-made function. Your final figure should look like Figure 3. Variables: GEO: 10751x1 cell array of character vectors GRADE: 10751x1 cell array of character vectors SEX: 10751x1 cell array of character vectors NUM: 10751x1 double Values: Min Median 7041 5.1259e+06 Max YEAR: 10751x1 double Values: Min Median 1997 2005 2013 Max Exercise 2 For this exercise, please create a new script called Labo3_schools STUDENTNUMBER.m. In the same OWL folder as this laboratory work sheet, you will find a file named schools.csv. Upload this file in the same folder as your script. This data set was downloaded from Statistics Canada as a CSV file. It gives the number of children in schools in Canada, stratified by provinces/territories, Grade level, gender and year. a) Import the data set schools.csv in a MATLAB table and print a summary of this data set. b) There are five variables (columns) in this table. Convert the ones that should be in string in the string type, the ones that should be unsigned integer in uint32 type. Print out another summary to check that the type conversion is made. c) Display the unique values taken by the variables GEO, GRADE and SEX. d) Create a new table that is a subset of the whole dataset containing only the numbers for both sexes of all grades (Total grades) in Canada. Use this table to plot the evolution of these numbers by years. Your figure should look like Figure 2. e) Plot for the regions Alberta, Nunavut, Ontario and Nova Scotia, the evolution of the enrolment for Grade 1 and Grade 6, for males and females. Use subplots and a custom-made function. Your final figure should look like Figure 3
