Question

1 Approved Answer

Posted on Jun 30, 2024

Fill in the blanks in the excel worksheet. In particular, calculate Unemployment rate, Labour Force Participation rate, and percentage changes in Population, Labour force, Employment,

Fill in the blanks in the excel worksheet. In particular, calculate Unemployment rate, Labour Force Participation rate, and percentage changes in Population, Labour force, Employment, Unemployment, Unemployment rate, and Labour Force Participation rate from April 2020 to May 2020 and from May 2019 to May 2020. Write down the formulas you have used to calculate these numbers

* @ Group Assignment # 2 Data File.xIsx Open with Microsoft Excel Geography: Canada, Province or territory Sex Age group Statistics Data type Geography Labour force characteristics 19-May 20-Apr 20-May April 2020 to May 2020 May 2019 to May 2020 Both sexes 15 years andEstimate Seasonally Canada Persons Percentage change Population (x 1,000) 30,662.40 31,094.70 31,114.30 0.07% Labour force (x 1,000) 20,142.70 18,603.20 19,093.70 Employment (x 1,000) 19,050.40 16,184.90 16,474.50 Unemployment (x 1,000) 1,092.30 2,418.30 2,619.20 Percentage Percentage change Unemployment rate Participation rate Nova Scotia Persons Percentage change Population (x 1,000) 805.1 814.8 815.2 Labour force (x 1,000) 502.3 449.6 467.5 Employment (x 1,000) 468.8 395.6 404.2 Unemployment (x 1,000) 33.5 54 63.4 Percentage Percentage change Unemployment rate Participation rate Quebec Persons Percentage change Population (x 1,000) 7,040.70 7,106.80 7,111.00 Labour force (x 1,000) 4,554.40 4,293.30 4,398.90 Employment (x 1,000) 4,327.90 3,564.00 3,794.90 Unemployment (x 1,000) 226.6 729.4 603.9 Percentage Percentage change Unemployment rate Participation rate Ontario Persons Percentage change Population (x 1,000) 12,093.30 12,298.20 12,307.20 Labour force (x 1,000) 7,844.60 7,285.60 7,402.10 Employment (x 1,000) 7,435.40 6,463.10 6,398.60 Unemployment (x 1,000) 409.2 822.4 1,003.40 Percentage Percentage change Unemployment rate Participation rate Alberta Persons Percentage change Population (x 1,000) 3,516.20 3,569.50 3,571.90 Labour force (x 1,000) 2,516.00 2,273.30 2,362.30 Employment (x 1,000) 2,346.90 1,969.00 1,997.20 Unemployment (x 1,000) 169 304.3 365.1 Percentage Percentage change Unemployment rate Participation rate British Columbia Persons Percentage change Population (x 1,000) 4,084.00 4,158.30 4,162.30 Labour force (x 1,000) 2,694.30 2,421.00 2,524.00 Employment (x 1,000) 2,575.80 2,142.60 2,185.90 Unemployment (x 1,000) 118.5 278.4 338.1 Percentage Percentage change Unemployment rate& @ Group Assignment # 2 Data File.xisx Open with Microsoft Excel Percentage Percentage change Unemployment rate Participation rate Males 15 years anEstimate Seasonally Canada Persons Percentage change Population (x 1,000) 15,120.90 15,345.40 15,356.30 Labour force (x 1,000) 10,602.50 9,855.80 10,191.50 Employment (x 1,000) 9,980.30 8,612.60 8,818.70 Unemployment (x 1,000) 622.1 1,243.20 1,372.80 Percentage Percentage change Unemployment rate Participation rate Nova Scotia Persons Percentage change Population (x 1,000) 390.2 395.1 395.4 Labour force (x 1,000) 256.7 233 238.3 Employment (x 1,000) 236.3 204.6 210 Unemployment (x 1,000) 20.4 28.4 28.3 Percentage Percentage change Unemployment rate Participation rate Quebec Persons Percentage change Population (x 1,000) 3,491.20 3,529.20 3,531.90 Labour force (x 1,000) 2,394.00 2,224.80 2,328.30 Employment (x 1,000) 2,255.10 1,854.90 2,009.20 Unemployment (x 1,000) 138.9 369.9 3191 Percentage Percentage change Unemployment rate Participation rate Ontario Persons Percentage change Population (x 1,000) 5,911.50 6,018.50 6,023.30 Labour force (x 1,000) 4,110.00 3,870.90 3,934.10 Employment (x 1,000) 3,889.40 3.446.00 3,421.20 Unemployment (x 1,000) 220.7 424.8 512.9 Percentage Percentage change Unemployment rate Participation rate Alberta Persons Percentage change Population (x 1,000) 1,768.70 1,793.40 1,794.60 Labour force (x 1,000) 1,360.70 1.242.60 1,319.40 Employment (x 1,000) 1,260.70 1,086.70 1,107.70 Unemployment (x 1,000) 100 155.8 211.8 Percentage Percentage change Unemployment rate Participation rate British Columbia Persons Percentage change Population (x 1,000) 2,011.10 2,048.50 2,050.60 Labour force (x 1,000) ,399.30 1,279.00 1,332.80 Employment (x 1,000) 1,339.40 1,139.80 1,165.70 Unemployment (x 1,000) 59.9 139.2 167.1 Percentage Percentage change Unemployment rate Participation rate