Go to https:/www.govinfo.gov/app/collection/erp

This is the homepage of the Economic Report of President

Click on the most recent available report, scroll down and download individual tables as Excel.

please note that using the data from previous reports will result in grade zero.

1. Find unemployment data ( Table B-27- Civilian unemployment rate) for each year 2000 to present. Use three labor force groups: men 20 years and over, women 20 years and over, both sexes 16 to 19 years of age.

a. Present the results in a table

b. Create either a line or bat graph

2.Find unemployment data (Table B-27-Unemployment rate) for each year 2000 to present by educational attainment (25 years and over). Use the following groups: less than an high school diploma; high school graduates; no college; some college or associate degree, bachelor's degree and higher.

a. Present the results in a table

b. Create either a line or bar graph

3. Use the economic report of the president (Table B-28- Unemployment by duration and reason) to find data on the duration of unemployment for each year 2000 to present

a. Present the result in a table

b. Create either a bar or line graph

1. which year had the highest and lowest unemployment rates? How do the rates compare among these groups?

2. Compare the unemployment rates by educational attainment. How do the rates compare among these groups? what relationship, if any do you find?

3. Compare the distribution of unemployment b duration over these years. Which years had the lowest and highest unemployment duration? What relationship, if any, do you find?

4. Demographic studies shows that the proportion of teenagers and minorities in the U.S. population is likely to increase in the near future. In your opinion, what implications, if any will this trend have on unemployment rate?

5. Analyze and discuss the significance of the data received from this exercise

6. Reflect on less learnt from the exercise

Please I need detailed answers, thank you