Can you fill in the blanks in the below excel screenshot.
Also please mention the formulas that you have used to calculate the blanks.
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) 2,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) 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.7 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) 1,399.30 1,279.00 1,332.8 Employment (x 1,000) ,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.6 216.6 229.2 Employment (x 1,000) 232.5 191 194.2 Unemployment (x 1,000) 13 .1 25.6 35 Percentage Percentage change Unemployment rate Participation rate Quebec Persons Percenta X Population (x 1,000) 3,549.60 3,577.60 3,579.10 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 ratePopulation (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) ,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.6 216.6 229.2 Employment (x 1,000) 232.5 191 194.2 Unemployment (x 1,000) 13.1 25.6 35 Percentage Percentage change Unemployment rate Participation rate Quebec Persons Percentage change Population (x 1,000) 3,549.60 3,577.60 3,579.10 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 Ontario Persons Percentage change Population (x 1,000) 6,181.70 6,279.80 6,283.90 Labour force (x 1,000 3,734.50 3,414.70 3,468.00 Employment (x 1,000) ,546.00 3,017.10 2,977.40 Unemployment (x 1,000) 188.5 397.6 490.5 Percentage Percentage change Unemployment rate Participation rate Alberta Persons Percentage change Population (x 1,000) 1,747.50 1,776.10 1,777.30 Labour force (x 1,000) 1,155.30 1,030.70 1,042.90 Employment (x 1,000) 1,086.30 882.3 889.6 Unemployment (x 1,000) 69 148.4 153.3 Percentage Percentage change Unemployment rate Participation rate British Columbia Persons Percentage change Population (x 1,000) 2,073.00 2,109.80 2,111.70 Labour force (x 1,000) 1,295.00 1,142.00 1,191.20 Employment (x 1,000) 1,236.40 1,002.70 1,020.20 Unemployment (x 1,000) 58.6 139.2 171 Percentage Percentage change Unemployment rate Participation rate X How to cite: Statistics Canada. Table 14-10-0287-03 Labour force characteristics by province, monthly, seasonally adjusted https://www 150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410028703 DOI: https://doi.org/10.25318/1410028701-eng
