Unemployment Data by Labor Force Groups and Duration

Go to https://www.govinfo.gov/app/collection/erp
This is the home page of the Economic Report of the 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 produce grade zero for
this part of the project.

  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 result in your project as a table.
    b. Create one or more charts (line graph, bar graph, etc.).
  2. Find unemployment data (Table B–27.—Civilian 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 result in your project as a table.
    b. Create one or more charts (line graph, bar graph, etc.).
  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 your project as a table.
    b. Create one or more charts (line graph, bar graph, etc.).
    Write a report (2 pages double-spaced) in your own words about the results you
    received.
    In this paper consider, but do not be limited to the following:
  4. Which years had the highest and lowest unemployment rates? How do the rates
    compare among these groups?
  5. 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 by duration over these years. Which years had
    the highest and lowest unemployment duration? What relationship, if any, do you
    find?
  6. Demographic studies show 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 the unemployment rate?
  7. Please analyze and discuss the significance of the data that you received
    for this Data exercise.
  8. Reflect on what you have learned from this exercise.