Instruction: You have to work with your assigned group to prepare an analysis and write-up to answer the following questions. Write ups need to be submitted as a team. Limit your response to 2 pages (A4 size, 12 font). Single Submission per group via Brightspace. For this assignment you need to submit the excel file along with the word document (max 2 page) containing your answer.

Question Statistics Canada offers a wide range of economic data at its website (https://www150.statcan.gc.ca/) including that of "Labour force characteristics by province" (Table: 14-10-0287-03). I have attached a customized excel worksheet derived from this table that includes male and female Adult Population, Labour force, Employment, and Unemployment data for Canada and her major provinces. Use these data to answer the following questions:

a. 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 in the word document. (10+5=15)

b. Discuss the question "COVID 19 expected to bring up unemployment: what does that mean for Canada?" in light of the data you have just produced. Highlight the differences in scenario between provinces and genders (if there is any). ,