Question

1 Approved Answer

Posted on Jun 26, 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

Labour force characteristics by province, monthly, seasonally adjusted Monthly Table: 14-10-0287-03 (formerly CANSIM 282-0087) 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 anEstimate Seasonally Canada Persons Percentage change Population (x 1,000) 30,662.40 31,094.70 31,114.30 Labour force (x 1,000) 20,142.70 18,603.20 19,093.70 Employment (x 1,000) 9,050.40 16,184.90 16,474.5 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) 1,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.0 Employment (x 1,000) 2,575.80 2,142.60 2,185.9 Unemployment (x 1,000) 118.5 278.4 338.1 Percentage Percentage change Unemployment rate Participation rate Males 15 years andEstimate Seasonally Canada Persons Percenta 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 K X Employment (x 1,000) ,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 changeNova 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) .255.10 1,854.90 2,009.20 Unemployment (x 1,000) 138.9 369.9 319.1 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) ,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) ,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 2,048.50 2,050.60 Labour force (x 1,000) ,399.30 1,279.00 1,332.8 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 Females 15 years andEstimate Seasonally Canada Persons Percentage change Population (x 1,000) 15,541.60 15,749.20 15,758.00 Labour force (x 1,000) 9,540.20 8,747.40 8,902.20 Employment (x 1,000) ,070.10 7,572.20 7,655.80 Unemployment (x 1,000) 470.2 1,175.10 1,246.40 Percentage Percentage change Unemployment rate Participation rate Nova Scotia Persons Percentage change Population (x 1,000) 414.9 419.6 419.8 Labour force (x 1,000) 245. 216.6 229.2 Employment (x 1,000) 32.5 191 194.2 Unemployment (x 1,000) 13.1 25.6 35 Percentage Percentage change Unemployment rate Participation rate Quebec Persons Percenta Population (x 1,000) 3,549.60 3,577.60 3,579.10 K X Labour force (x 1,000) 2,160.40 2,068.50 2,070.60 Employment (x 1,000) 2,072.80 1,709.10 1,785.70 Unemployment (x 1,000) 87.6 359.4 284.9 Percentage Percentage change Unemployment rate Participation rate