H B D E F 1 Gross domestic product (GDP) at basic prices, by industry, provinces and territories (X 1,000,000) c1234567 2 Annual 3. Table: 36-10-0402-01 (formerly CANSIM 379-0030) 4 Geography: Province or territory 5 6 Chained (2012) dollars 9 7 Allindustries (T001]10 8 Geography 2014 2015 2016 2017 2018 Dollars 10 Newfoundland and Labrador 31,143.30 30,806.00 31,282.00 31,414.00 30,383.20 11 Prince Edward Island 5,205.60 5,280.70 5,393.80 5,632.20 5,788.90 12 Nova Scotia 34,747.20 35,013,40 35,489.10 36,106.50 36,662.50 3 New Brunswick 29,039.60 29,275.70 29,546.00 30,223.90 30,446.60 14 Quebec 338,319.00 341,688.00 347,197.70 357,285.70 367,074.80 15 Ontario 659,861.20 677,384.00 692,620.80 713,254.10 730,276.20 76 Manitoba 58,276.30 59,082.50 59,966.80 61,932.60 62,862.50 17 Saskatchewan 80,175.70 79,574.20 79,317.50 80,844.70 82,166.20 18 Alberta 338,262.60 326,476.70 314,599.40 329,904.60 336,281.30 19 British Columbia 219,060.90 224,153.40 230,763.50 239,852.30 246,260.20 20 Yukon 2,510.90 2,320.20 2,487.60 2,511.80 2,593.20 21 Northwest Territories 4,574.60 4,621.30 4,570.30 4,642.70 4,716.40 22 Nunavut 2,362.60 2,353.00 2,479.20 2,764.50 2,974.10 23 24 Symbol legend: Sheet1 Sheet3 Sheet2 Sheet4 Gross domestic product (GDP) at basic prices by industry provinces and territories, percentage share o 1234 Annual Table: 36-10-0400-01(formerly CANSIM 379-0028) Geography Province or territory 100 British Columbia North American Indu 2014 2015 2016 2017 2018 Percentage share All industries (T001]6 100 100 100 100 Goods-producing in 24.08 22.55 22.46 23.38 23.92 Service-producing i 75.92 77.45 77.54 76.62 76.08 Industrial production 13.72 12.33 12.55 13.22 13.5 Information and com 3.82 4.06 4.19 4.07 3.93 Energy sector (T016 5.69 4.42 4.62 5.24 5.44 Agriculture forestry 2.43 248 2.43 2.29 2.4 Mining, quarrying, ar 4.21 2.74 2.95 3.55 3.82 Utilities [22] 2.26 2.33 2.25 2.17 2.24 8 Construction [23] 8.23 8.04 7.75 8.13 27 19 Manufacturing (31-3 6.95 6.97 7.07 7.24 7.19 20 Wholesale trade [41 3.96 387 3.96 3.98 3.86 21 Retail trade [44-45] 5.78 5.93 5.98 6.01 5.87 222 Transportation and 5.72 5.97 5.8 6 6.27 23 Information and cultu 3.28 3.17 3.21 3.1 2.9 24 Finance and insurar 5.73 5.83 5.8 5.84 5.88 25 Real estate and rent 17.78 18.22 18.36 17 89 17,48 26 Professional, scienti 6.03 6.39 6.42 6.31 6.27 27 Management of con 0.59 0.59 0.48 0.51 0.51 28 Administrative and si 2.61 2.66 2.69 2.53 248 29 Educational services 5.18 5.38 5.31 5.19 30 Health care and soc 7.25 7.33 7.34 110 7.16 31 Arts, entertainment 0.89 0.91 0.91 0.91 32 Accommodation and 2.81 2.93 3.25 3.27 3.36 33 Other services lence 2.34 2.33 23 2.26 2.25 34 Public administration 5.96 5.92 5.74 5.69 569 35 36 Symbol legend: 37 38 Corrections: Sheet1 Sheet3 Sheet2 Sheet4 0.93 9.71 B F 1 G H 2 Annual Gross domestic product (GDP) at basic prices, by industry, provinces and territories, percentage share c 1264 Table: 36-10-0400-01 (formerly CANSIM 379-0028) 4 Geography: Province or territory 5 6. Alberta 7 North American Industry Classification Syst 2014 2015 2016 8 2017 2018 Percentage share 9 All industries (T00136 100 100 100 100 100 10 Goods-producing industries [T00217 47.57 38.53 84.99 67.86 38.34 11 Service-producing industries (T00318 52.43 61.47 65.01 62.14 61.66 12 Industrial production (T01019 35.47 25.24 23 26.63 27.59 13 Information and communication technology 2.74 3.08 3.11 2.84 2.72 14 Energy sector (T016]11 30.13 19.18 16.88 20.44 21.38 15 Agriculture, forestry, fishing and hunting (11 1.14 1.82 2.13 1.96 1.78 16 Mining, quarrying, and oil and gas extractio 27.05 15.21 12.95 16.26 16.78 17 Utilities [22] 1.29 1.51 1.49 1.77 18 Construction [23] 11.33 11.93 10.65 9.42 19 Manufacturing (31-33] 6.76 8.06 8.07 8.42 8.59 20 Wholesale trade [41] 4.51 4.74 4.62 4.73 4.67 21 Retail trade [44-45] 3.87 4.38 4.63 4.51 4.39 22 Transportation and warehousing (48-49) 4.08 4.82 5.24 5.25 5.56 23 Information and cultural industries [51] 1.99 2.24 2.38 2.11 1.96 24 Finance and insurance [52] 3.55 4.32 4.6 4.45 4.46 25 Real estate and rental and leasing [53] 9.4 11.45 12.49 11.78 26 Professional, scientific and technical servic 5.56 6.01 5.74 5.35 5.22 27 Management of companies and enterprise: 0.68 0.8 0.71 0.68 0.68 28 Administrative and support, waste manager 2.34 2.78 2.93 2.68 2.65 29 Educational services (61) 3.19 3.9 4.19 3.98 3.96 30 Health care and social assistance [62] 4.81 5.99 6.62 6.36 6.41 31 Arts, entertainment and recreation [71] 0.44 0.55 0.62 0.6 0.6 32 Accommodation and food services [72] 1.99 2.29 2.45 2.31 2.23 33 Other services (except public administration 1.85 2.14 2.01 34 Publio administration (91) 4.18 5.06 5.68 5.65 5.27 35 36 Symbollegend: 37 38 Corrections: 11.56 2.13 2.07 Gross domestic product (GOP) at basic prices, by industry, provinces and territories, peroentage share o 1234 Annual Table: 36-10-0400-01(formerly CANSIM 379-0028) Geography Province or territory 2017 2018 100 Saskatchewan North Am 2014 2015 2016 Percentage share All indust 100 100 100 Goods-p 48.68 45.42 41.68 Service-1 51.32 54.58 58,32 Industrial 33.43 27.07 23.2 Informatic 1.78 1.9 2.05 Energy se 23.78 16.71 15.34 Agricultu 5.63 9.09 9.52 Mining, 25.08 18.77 14.53 Utilities (3 2.19 2.43 2.8 Construc 9.77 9.41 9.14 Manufac 6.01 5.72 5.7 Wholesal 5.35 5.25 5.71 Retail tras 4.17 4.4 4.73 Transpor 4.54 4.68 4.73 Informatic 1.51 1.61 1.72 Finance 3.29 3.53 3.76 Real esta 9.25 10.08 10.85 Professic 2.75 2.79 2.81 Manager 0.47 0.52 0.46 Administr 1.15 1.24 1.35 Educatio 4.28 4.64 5.03 Health cz 5.74 6.39 6.88 Arts.ente 0.56 0.59 0.66 Accomm 1.59 171 1.83 3 Other ser 1.52 1.6 166 4 Publicac 5.15 5.56 6.15 5 Countelemondi 42.41 57.59 25.36 1.91 17.04 8.7 16.32 2.89 8.5 6 5.72 4.65 4.81 1.57 3.8 10.6 2.69 0.45 1.29 4.96 6.8 0.65 1.8 1.63 6.17 100 42.31 57.69 25.81 1.78 16.16 8.44 16.27 3 8.22 6.37 5.8 4.54 5.01 1.46 3.8 10.58 2.67 0.45 123 4.96 6.87 0.66 1.78 163 6.27 An economist was interested in analyzing the significant changes in the Canadian economy and in the economies of the western provinces brought about by COVID-19. In preparation she collects several data sets for the purpose of making a comparison of the "before" data to the "during shut-down" and beyond data. The initial data is annual GDP, by province, from the years 2014 to 2018, as 2019 was not yet released. The data for the provinces is more detailed, as it is broken down by industry. The first thing the economist needs to do is format the data and check any totals. Unfortunately, the data she downloaded is not reported the same way. 1. Open your workbook and start by naming the worksheets so it is clear which dataset is on each of the worksheets. Use colour fill as well on the worksheet tabs to help identify the different datasets. 2. On each of the worksheets format the data into a table. Make the text fit the cells by changing the column sizes, wrapping the data or headings if appropriate, and bolding and centering the headings. Use some colour fill in the table column headings so that the variables across the year categories are coloured in a consistent manner across each of the worksheets. Use borders around the data and then around the whole table. Make sure to make up a descriptive title and put the table title in a larger, bold font. Center the title over the whole table. 3. On each of the worksheets, put the header information and the footnotes inside a Textbox, and format the information in an appropriate manner. Note that the information for the provinces is similar, so you can copy to other worksheets and then update the textbox if needed. Make sure that the box is sized such that all the text is readable. Include the source of the data and any other important information in the textbox at the bottom of the footnotes. matalattalDDIS da 4. For the Canadian GDP table add a row at the bottom and sum up the total GDP for each year. w 5. For the provincial data read the footnotes carefully. Add a row on the bottom of your tables for BC, AB, and SK to check that the information for the industries add up to 100%. Why might it not add up? Do you think there is something else you should be checking? [Put your answers to these questions in a textbox on the worksheet with the BC Data] 6. On the AB data worksheet, copy and paste transpose your table of data. Place this new table Scolumns to the right of your original table. Fix the column widths on the new table so that the Industries are readable and none of the labels have words broken up. Paste the table title above this new table 7. On the SK worksheet answer the following questions in a textbox. & Note that there are three sectors of the economy reported underneath the Gossano Services prochacing sectors for each province. Which province has the larzest value for Industrial Production, and when does it occur? Which province has the largest value for the Information and communication technology sector, and then does it occur? Which province has the largest value for the energy sector, and then does it For the individual sectors of the economy what are the three largest for each province? Does this change over the 5-year period H B D E F 1 Gross domestic product (GDP) at basic prices, by industry, provinces and territories (X 1,000,000) c1234567 2 Annual 3. Table: 36-10-0402-01 (formerly CANSIM 379-0030) 4 Geography: Province or territory 5 6 Chained (2012) dollars 9 7 Allindustries (T001]10 8 Geography 2014 2015 2016 2017 2018 Dollars 10 Newfoundland and Labrador 31,143.30 30,806.00 31,282.00 31,414.00 30,383.20 11 Prince Edward Island 5,205.60 5,280.70 5,393.80 5,632.20 5,788.90 12 Nova Scotia 34,747.20 35,013,40 35,489.10 36,106.50 36,662.50 3 New Brunswick 29,039.60 29,275.70 29,546.00 30,223.90 30,446.60 14 Quebec 338,319.00 341,688.00 347,197.70 357,285.70 367,074.80 15 Ontario 659,861.20 677,384.00 692,620.80 713,254.10 730,276.20 76 Manitoba 58,276.30 59,082.50 59,966.80 61,932.60 62,862.50 17 Saskatchewan 80,175.70 79,574.20 79,317.50 80,844.70 82,166.20 18 Alberta 338,262.60 326,476.70 314,599.40 329,904.60 336,281.30 19 British Columbia 219,060.90 224,153.40 230,763.50 239,852.30 246,260.20 20 Yukon 2,510.90 2,320.20 2,487.60 2,511.80 2,593.20 21 Northwest Territories 4,574.60 4,621.30 4,570.30 4,642.70 4,716.40 22 Nunavut 2,362.60 2,353.00 2,479.20 2,764.50 2,974.10 23 24 Symbol legend: Sheet1 Sheet3 Sheet2 Sheet4 Gross domestic product (GDP) at basic prices by industry provinces and territories, percentage share o 1234 Annual Table: 36-10-0400-01(formerly CANSIM 379-0028) Geography Province or territory 100 British Columbia North American Indu 2014 2015 2016 2017 2018 Percentage share All industries (T001]6 100 100 100 100 Goods-producing in 24.08 22.55 22.46 23.38 23.92 Service-producing i 75.92 77.45 77.54 76.62 76.08 Industrial production 13.72 12.33 12.55 13.22 13.5 Information and com 3.82 4.06 4.19 4.07 3.93 Energy sector (T016 5.69 4.42 4.62 5.24 5.44 Agriculture forestry 2.43 248 2.43 2.29 2.4 Mining, quarrying, ar 4.21 2.74 2.95 3.55 3.82 Utilities [22] 2.26 2.33 2.25 2.17 2.24 8 Construction [23] 8.23 8.04 7.75 8.13 27 19 Manufacturing (31-3 6.95 6.97 7.07 7.24 7.19 20 Wholesale trade [41 3.96 387 3.96 3.98 3.86 21 Retail trade [44-45] 5.78 5.93 5.98 6.01 5.87 222 Transportation and 5.72 5.97 5.8 6 6.27 23 Information and cultu 3.28 3.17 3.21 3.1 2.9 24 Finance and insurar 5.73 5.83 5.8 5.84 5.88 25 Real estate and rent 17.78 18.22 18.36 17 89 17,48 26 Professional, scienti 6.03 6.39 6.42 6.31 6.27 27 Management of con 0.59 0.59 0.48 0.51 0.51 28 Administrative and si 2.61 2.66 2.69 2.53 248 29 Educational services 5.18 5.38 5.31 5.19 30 Health care and soc 7.25 7.33 7.34 110 7.16 31 Arts, entertainment 0.89 0.91 0.91 0.91 32 Accommodation and 2.81 2.93 3.25 3.27 3.36 33 Other services lence 2.34 2.33 23 2.26 2.25 34 Public administration 5.96 5.92 5.74 5.69 569 35 36 Symbol legend: 37 38 Corrections: Sheet1 Sheet3 Sheet2 Sheet4 0.93 9.71 B F 1 G H 2 Annual Gross domestic product (GDP) at basic prices, by industry, provinces and territories, percentage share c 1264 Table: 36-10-0400-01 (formerly CANSIM 379-0028) 4 Geography: Province or territory 5 6. Alberta 7 North American Industry Classification Syst 2014 2015 2016 8 2017 2018 Percentage share 9 All industries (T00136 100 100 100 100 100 10 Goods-producing industries [T00217 47.57 38.53 84.99 67.86 38.34 11 Service-producing industries (T00318 52.43 61.47 65.01 62.14 61.66 12 Industrial production (T01019 35.47 25.24 23 26.63 27.59 13 Information and communication technology 2.74 3.08 3.11 2.84 2.72 14 Energy sector (T016]11 30.13 19.18 16.88 20.44 21.38 15 Agriculture, forestry, fishing and hunting (11 1.14 1.82 2.13 1.96 1.78 16 Mining, quarrying, and oil and gas extractio 27.05 15.21 12.95 16.26 16.78 17 Utilities [22] 1.29 1.51 1.49 1.77 18 Construction [23] 11.33 11.93 10.65 9.42 19 Manufacturing (31-33] 6.76 8.06 8.07 8.42 8.59 20 Wholesale trade [41] 4.51 4.74 4.62 4.73 4.67 21 Retail trade [44-45] 3.87 4.38 4.63 4.51 4.39 22 Transportation and warehousing (48-49) 4.08 4.82 5.24 5.25 5.56 23 Information and cultural industries [51] 1.99 2.24 2.38 2.11 1.96 24 Finance and insurance [52] 3.55 4.32 4.6 4.45 4.46 25 Real estate and rental and leasing [53] 9.4 11.45 12.49 11.78 26 Professional, scientific and technical servic 5.56 6.01 5.74 5.35 5.22 27 Management of companies and enterprise: 0.68 0.8 0.71 0.68 0.68 28 Administrative and support, waste manager 2.34 2.78 2.93 2.68 2.65 29 Educational services (61) 3.19 3.9 4.19 3.98 3.96 30 Health care and social assistance [62] 4.81 5.99 6.62 6.36 6.41 31 Arts, entertainment and recreation [71] 0.44 0.55 0.62 0.6 0.6 32 Accommodation and food services [72] 1.99 2.29 2.45 2.31 2.23 33 Other services (except public administration 1.85 2.14 2.01 34 Publio administration (91) 4.18 5.06 5.68 5.65 5.27 35 36 Symbollegend: 37 38 Corrections: 11.56 2.13 2.07 Gross domestic product (GOP) at basic prices, by industry, provinces and territories, peroentage share o 1234 Annual Table: 36-10-0400-01(formerly CANSIM 379-0028) Geography Province or territory 2017 2018 100 Saskatchewan North Am 2014 2015 2016 Percentage share All indust 100 100 100 Goods-p 48.68 45.42 41.68 Service-1 51.32 54.58 58,32 Industrial 33.43 27.07 23.2 Informatic 1.78 1.9 2.05 Energy se 23.78 16.71 15.34 Agricultu 5.63 9.09 9.52 Mining, 25.08 18.77 14.53 Utilities (3 2.19 2.43 2.8 Construc 9.77 9.41 9.14 Manufac 6.01 5.72 5.7 Wholesal 5.35 5.25 5.71 Retail tras 4.17 4.4 4.73 Transpor 4.54 4.68 4.73 Informatic 1.51 1.61 1.72 Finance 3.29 3.53 3.76 Real esta 9.25 10.08 10.85 Professic 2.75 2.79 2.81 Manager 0.47 0.52 0.46 Administr 1.15 1.24 1.35 Educatio 4.28 4.64 5.03 Health cz 5.74 6.39 6.88 Arts.ente 0.56 0.59 0.66 Accomm 1.59 171 1.83 3 Other ser 1.52 1.6 166 4 Publicac 5.15 5.56 6.15 5 Countelemondi 42.41 57.59 25.36 1.91 17.04 8.7 16.32 2.89 8.5 6 5.72 4.65 4.81 1.57 3.8 10.6 2.69 0.45 1.29 4.96 6.8 0.65 1.8 1.63 6.17 100 42.31 57.69 25.81 1.78 16.16 8.44 16.27 3 8.22 6.37 5.8 4.54 5.01 1.46 3.8 10.58 2.67 0.45 123 4.96 6.87 0.66 1.78 163 6.27 An economist was interested in analyzing the significant changes in the Canadian economy and in the economies of the western provinces brought about by COVID-19. In preparation she collects several data sets for the purpose of making a comparison of the "before" data to the "during shut-down" and beyond data. The initial data is annual GDP, by province, from the years 2014 to 2018, as 2019 was not yet released. The data for the provinces is more detailed, as it is broken down by industry. The first thing the economist needs to do is format the data and check any totals. Unfortunately, the data she downloaded is not reported the same way. 1. Open your workbook and start by naming the worksheets so it is clear which dataset is on each of the worksheets. Use colour fill as well on the worksheet tabs to help identify the different datasets. 2. On each of the worksheets format the data into a table. Make the text fit the cells by changing the column sizes, wrapping the data or headings if appropriate, and bolding and centering the headings. Use some colour fill in the table column headings so that the variables across the year categories are coloured in a consistent manner across each of the worksheets. Use borders around the data and then around the whole table. Make sure to make up a descriptive title and put the table title in a larger, bold font. Center the title over the whole table. 3. On each of the worksheets, put the header information and the footnotes inside a Textbox, and format the information in an appropriate manner. Note that the information for the provinces is similar, so you can copy to other worksheets and then update the textbox if needed. Make sure that the box is sized such that all the text is readable. Include the source of the data and any other important information in the textbox at the bottom of the footnotes. matalattalDDIS da 4. For the Canadian GDP table add a row at the bottom and sum up the total GDP for each year. w 5. For the provincial data read the footnotes carefully. Add a row on the bottom of your tables for BC, AB, and SK to check that the information for the industries add up to 100%. Why might it not add up? Do you think there is something else you should be checking? [Put your answers to these questions in a textbox on the worksheet with the BC Data] 6. On the AB data worksheet, copy and paste transpose your table of data. Place this new table Scolumns to the right of your original table. Fix the column widths on the new table so that the Industries are readable and none of the labels have words broken up. Paste the table title above this new table 7. On the SK worksheet answer the following questions in a textbox. & Note that there are three sectors of the economy reported underneath the Gossano Services prochacing sectors for each province. Which province has the larzest value for Industrial Production, and when does it occur? Which province has the largest value for the Information and communication technology sector, and then does it occur? Which province has the largest value for the energy sector, and then does it For the individual sectors of the economy what are the three largest for each province? Does this change over the 5-year period