Data assignment #2 In this data assignment, you will learn to use the FRED database of the St. Louis Federal Reserve to analyze the labor force participation data by gender. This data assignment is worth 10 points. It will be due by 11:59 PM on March 29th, 2023. A. Search and download labor data on FRED: https://fred.stlouisfed.org/ 1. Labor force participation rate for female: In the search box, type in this term and search. You want to choose the \"percent, monthly, seasonally adjusted\" version Now click the Download button, and choose \"Excel (data)\" Labor force participation rate for male: Similarly, search and download the data for male B. Make a graph for labor force participation for male and female (3 points) 1. The data for male and female are in two separate les. You first need to create a new Excel le with both series together. Label each column with their respective gender. It should look something like this. In mummy Monthly 11 cmemlimidm: mm Male 2 lyemtvn'l m 357 a wow 32 A av o u man] at 32' as 3 Is me am 3: a as s 15 rats usrt 32 u asv n| 946 05411 3: i as 5|:I, in was m m a: 4 as 7 I! ma ow 321 as 7 Zn imam x: n as :1 2: 19484111\" 32 A as s 22 martin 316 ass a ma ram 3: a as 9 Select the two columns and choose Insert > Line Charts Note that this graph does not have the right labels for its horizontal axis yet. Right click on the graph and choose \"Select data". In the \"Horizontal (Category) Axis Labels" cell, choose Edit (Window) or just click in the cell (Mac) and select all the dates in the data. Click OK to apply the change. Make sure you name each series its gender . Make sure you give a title to your graph. Your nal product should look something like this (but longer period). The position of the legend doesn't matter. Labor force participation rate 70.0 W 55.0 Female Male 60.0 55.0 W 50.0 2023707702 2024709702 2025711702 C. Which gender was affected most by the pandemic in terms of labor force participation rate? The pandemic hit in March 2020. (2 points) . Calculate the growth rate of labor force participation for male and female for April 2020. Recall that growth rate is the percentage change of that variable compared to the previous period. 2. Both groups suffered a negative growth rate, which means labor force participation decreased. Which group decreased more? D. Analyze the long-term trends in labor force participation of male and female in the US. (5 points) . Ever since 1948, how has labor force participation rate of female changed? 2. Ever since 1948, how has labor force participation rate of male changed? 3. In a paragraph, explain why you observed such patterns in part 1. 4. To understand the patterns you observed in part 2, first read this paper: w www.kansascityfed.org/Economic%20Review/ documents/ 653/ 20 1 8- Why%20Are%20Prime- Age%20Men%20Vanishing%20from%20the%20Lab0r%20Force%3F.pdf (Don't have to read the whole thing, just focus on part II) In a paragraph, summarize the possible reasons why labor force participation rate of men has followed the pattern that you observed in part 2