Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 3: Unemployment Data by Labor Force Groups and Duration (30% of the project grade) Go to https:/fwww.govinfo.gov/app/collection/erp This is the home page of the
Part 3: Unemployment Data by Labor Force Groups and Duration (30% of the project grade) Go to https:/fwww.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 unemploymentdata (Table B27 Civilian unemploymentrate) 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. Presentthe resultin your project as a table. b. Create one or more charts (line graph, bar graph, etc.). 2. Find unemploymentdata (Table B-27.Civilian unemploymentrate) 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. Presentthe resultin 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 B28.Unemployment by duration and reason) to find data on the duration of unemployment for each year 2000 to present. a. Presentthe 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 aboutthe results you received. In this paper consider, but do not be limited to the following: 1. Which years 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 by duration over these years. Which years had the highest and lowest unemployment duration? What relationship, if any, do you find? 4. 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? 5. Please analyze and discuss the significance of the data that you received for this Data exercise. 6. Reflect on what you have learned from this exercise.TABLE B-27. Civilian unemployment rate, 1978-2023 [Percent *; monthly data seasonally adjusted] By sex and age By race or ethnicity 2 By educational attainment (25 years & over) All civilian U-6 Year or month workers Men 20 Women 20 Both Black or measure of years and years and sexes White Hispanic or labor under- Less than a African Asian |High school Some college Latino Bachelor's over over 16-19 high school American utilization 3 graduates, no or associate ethnicity degree and diploma college degree higher 4 2000. 1.0 3.3 3.6 13.1 3.5 2001. 7.6 3.6 5.7 4.7 7.0 4.2 4.1 6.3 14.7 3.4 2002 4.2 2.7 8.6 1.7 4.5 6.6 5.8 8.1 5.3 7.2 5.1 16.5 4.2 3.3 5.1 2003. 10.2 2.3 5.9 7.5 6.0 9.6 5.6 8.4 5.1 17.5 5.3 4.5 10.8 2.9 2004. 5.2 6.0 7.7 5.5 10.1 5.0 4.9 17.0 8.8 5.5 4.8 4.8 2005. 10.4 3.1 4.4 7.0 5.1 9.6 4.4 8.5 4.6 16.6 5.0 4.2 4 4 10.0 2.7 2006 4.0 6.0 4.6 8.9 4.0 7.6 47 4.1 15.4 4.0 3.9 2007. 8.9 2.3 3.0 5.2 4.6 8.2 4.1 6.8 4.3 4.0 15.7 3.6 4 1 2.0 2008 8.3 3.2 5.6 5.8 8.3 5.4 7.1 4.9 18.7 4.4 5.2 3.6 10.1 2.0 2009 4.0 7.6 9.3 9.6 10.5 7.5 9.0 5.7 24.3 8.5 4.6 14.8 2.6 7.3 12.1 16.2 14.6 97 2010. 8.0 4.6 9.6 9.8 8.0 25.9 8.7 2011 16.0 7.5 8.9 12.5 16.7 8.7 14.9 7.9 24.4 10.3 7.9 8.4 2012 15.8 4.7 7.0 11.5 15.9 8.1 7.5 14.1 7.3 24.0 9.4 8.0 7.2 4.3 2013 13.8 5.9 10.3 7.4 14.7 7.0 12.4 6.5 8.3 22.9 7.1 6.5 4.0 2014. 13. 5.2 9.1 6.2 13.8 5.7 11.0 56 7.5 19.6 6.4 53 2015. 11.3 3.7 5.0 7.4 5.3 12.0 4.9 9.0 6.0 4.8 16.9 54 4.6 3.2 2016. 9.6 3.8 6.6 10.4 4.9 8.0 4.5 4.4 15.7 5.4 4.5 4.3 2.6 2017. 8.4 3.6 5.8 9.6 4.4 4.0 7.4 5.2 4.0 14.0 41 3.8 2.5 2018. 7.5 3.4 5.1 8.5 3.9 3.6 6.5 4.6 3.5 12.9 3.8 3.5 2.3 2019. 6.5 3.0 4.7 3.7 7.7 3.4 3.3 5.6 4.1 12.7 3.3 3.3 6.1 2.1 2.7 4.3 7.2 5.4 3.7 2020 3.0 2.1 81 74 80 17 9 73 114 87 104 136 11 7 90 78 48TABLE B-27. Civilian unemployment rate, 1978-2023 [Percent '; monthly data seasonally adjusted] By sex and age By race or ethnicity 2 By educational attainment (25 years & over) Year or month All civilian U-6 workers Men 20 Women 20 Both Black or measure of years and Hispanic or years and sexes White labor under- Less than a African Asian High school Some college Latino Bachelor's over over 16-19 high school American utilization graduates, no | or associate degree and ethnicity diploma college degree higher 4 2021 5.3 5.2 5.0 11.7 4.7 8.6 2022. 5.0 9.4 8.3 3.6 3.4 3.3 6.2 10.8 5.1 3.1 3.2 6 1 2023 2.8 4.3 6.9 5.5 3.6 4.0 3.5 3.2 11.2 3.1 3 3 2.0 5.5 3.0 4.6 69 5.6 3.9 3.0 2.1 2022: Jan. 4.0 3.8 3.6 11.2 3.4 7.0 Feb. 3.6 4.7 7.2 3.8 3.5 6.3 4.6 3.7 10.2 3.5 2.3 3.3 6.6 2.9 Mar 4.3 7.2 3.6 4 4 3.4 4.4 3.4 3.7 10.3 3.2 2.2 6.4 27 Apr. 4.2 7.0 53 3.7 3.5 4.0 3.1 3.3 10.6 2.0 3.3 6. 1 3.0 4.2 May 7.1 5.4 3.6 3.4 3.8 3.1 3.4 10.5 2.0 3.2 6.2 2.4 June 4.4 7.1 3.6 3.4 5.2 3.7 3.3 10.9 3.3 3 3 1.9 58 2.9 July. 4.3 67 5.7 3.5 3.3 3.6 3.1 3.1 11.2 2.1 3.1 5.9 2.7 4.0 Aug 6.8 5.9 3.6 3.5 3.6 2.8 3.2 10.2 2.0 3.2 64 Sept 2.8 1 5 7.0 3.5 3.3 6.2 4.4 3.1 11.4 2.9 3.0 1.9 5.8 Oct. 2.5 3.9 6.7 3.6 5.6 3.3 3.7 2.9 3.4 10.6 1.8 3.2 5.8 Nov. 3.0 4.2 67 6.2 3.6 3.3 4.0 3.3 11.3 3.0 1.9 3.2 5.6 2.6 Dec. 4.0 6.7 43 3.5 3.1 3.9 32 3.2 10.5 3.0 2.0 5.7 24 4.21 6 5 5.0 3.6 3.0 2023: Jan. 1.9 3.4 3.2 3.1 10.5 3.1 5.4 2.9 4.7 Feb. 6.7 1.5 3.6 3.3 3.8 2.9 3.3 11. 2.0 3.2 5.7 3.4 Mar. 5.4 6.8 3.5 3.4 5.8 3.6 3.2 3.3 2.1 9.9 3.2 5.1 Apr. 2.8 4.6 6.7 3.4 4.8 3.3 4.0 3.1 9.3 3.0 3.1 2.0 4 8 2.8 4.4 May 6.6 5.4 3.7 3.5 3.9 2.9 3.3 10.3 1.9 3.3 5.7 June. 3.0 4.1 6.8 3.6 3.4 5.7 3.1 11.2 3.9 3.2 3.1 2.0 6.0 July. 3.1 4.2 6.9 3.5 6.0 3.4 3.9 3.1 11.3 3.0 2.0 3.1 5.7 2.3 4.4 Aug 6.7 5.3 3.8 3.7 3.3 3.1 3.2 12.3 2.0 3.4 5.3 3.2 Sept 4.9 7.1 3.8 5.4 3.8 3.9 3.1 3.1 11.8 3.4 2.2 57 2.9 Oct. 4.6 7.0 3.8 5.5 3.7 4.1 3.2 3.0 13.1 2.2 3.5 5.8 Nov. 3.1 1.8 7.2 3.7 3.7 5.8 4.0 3.1 3. 1 11.4 2.1 3.3 5.8 3.5 Dec 1.6 7.0 3.7 3.5 6.3 3.3 11.9 4.1 2.8 3.5 2.1 52 3.1 5.0 7.1 6.0 4.2 3.1 2.1TABLE B-28. Unemployment by duration and reason, 1978-2023 Thousands of persons, except as noted; monthly data seasonally adjusted '] Duration of unemployment Reason for unemployment Year or month Unemploy- Average Job losers 3 ment Less than 5-14 15-26 27 weeks (mean) Median Job 5 weeks weeks weeks and over duration duration New leavers Reentrants entrants weeks) 2 (weeks) Total On layoff Other 2000. 5,692 2,558 1,815 695 649 12.6 5.9 2,517 852 1,664 780 1,961 434 2001. 6,801 2,853 2,196 951 801 13. 6.8 3,476 1,067 2,409 2,031 459 2002 8,378 2,893 2,580 1,369 1,535 16.6 9.1 4,607 1, 124 3,483 366 2,368 536 2003. 8,774 2,785 2,612 1,442 1,936 19.2 10.1 4,838 1, 121 3,717 318 2,477 641 2004. 8, 149 2,696 2,382 1,293 1,779 19.6 9.8 4,197 998 3,199 858 2,408 686 2005. 7,591 2,667 2,304 1, 130 1,490 18.4 8.9 3,667 933 2,734 872 2,386 666 2006. 7,001 2,614 2, 121 1,031 1,235 16.8 8.3 3,321 321 2,400 827 2,237 616 2007. 7,078 2,542 2,232 1,061 1,243 16.8 8.5 3,515 976 2,539 793 2, 142 627 2008. 8,924 2,932 2,804 1,427 1,761 17.9 9.4 4,789 1,176 3,614 896 2,472 766 2009 14,265 3,165 3,828 2,775 4.496 24.4 15.1 9,160 1,630 7,530 882 3, 187 1,035 2010. 14,825 2,771 3,267 2,371 6,415 33.0 21.4 9,250 1,431 7,819 889 3,466 1,220 2011 . 13,747 2,677 2,993 . 2,061 6,016 39.3 21.4 8.106 1,230 6,876 956 3,401 1,284 2012 12,506 2,644 2,866 1,859 5,136 39.4 19.3 6,877 1,183 5,694 967 3,345 1,316 2013. 11,460 2,584 2,759 1,807 4,310 36.5 17.0 6,073 1,136 4,937 932 3,207 1,247 2014. 9,617 2,471 2,432 1,497 3,218 33.7 14.0 4,878 1,007 3,871 824 2,829 1,086 2015. 8,296 2,399 2,302 1,267 2,328 29.2 11.6 4,063 974 3,089 819 2,535 879 2016. 7,751 2,362 2,226 1, 158 2,005 27.5 10.6 3,740 966 2,774 858 2,330 823 2017. 6,982 2,270 2,008 1,017 1,687 25.0 10.0 3,434 956 2,479 778 2,079 690 2018. 6,314 2, 170 1,876 917 1,350 22.7 9.3 2,990 852 2,138 794 1,928 602 2019. 6,001 2,086 1,789 860 1,266 21.6 9.1 2,786 323 1,963 814 1,810 591 2020. 12,947 3,708 4,728 2,516 1,995 16.5 9.7 9,770 6,371 3,399 683 1,969 526 2021. 8,623 2,140 1,981 1, 164 3,337 28.7 16.5 5,099 1,582 3,516 803 2,204 518 2022. 5,996 2,216 1,711 756 1,314 22.6 8.7 2,767 830 1,936 857 1,891 482 2023. 6,080 2,112 1,866 925 1, 177 20.6 8.9 2,870 811 2,059 822 1,831 656TABLE B-28. Unemployment by duration and reason, 1978-2023 Thousands of persons, except as noted; monthly data seasonally adjusted '] Duration of unemployment Reason for unemployment Unemploy- Average Median Job losers 3 Year or month New ment Less than 5-14 15-26 27 weeks (mean) Job duration leavers Reentrants 5 weeks weeks weeks and over duration entrants (weeks) 2 (weeks) Total On layof Other 2022: Jan. 6,549 2,472 1,611 786 1,715 24.5 10.0 3,267 993 2,274 950 1,961 438 Feb. 6,279 2,145 1,768 803 1,615 26.3 10.0 2,994 857 2,136 959 1,951 428 5.993 2,305 1,723 567 1,422 24.2 B.8 2,725 710 2,015 786 2,035 481 Mar. 921 793 1,856 502 Apr 6,034 2,277 1,608 647 1,354 24.8 B.5 2,932 2,011 5,966 2,030 1,757 696 1,333 22.4 8.9 2,713 822 1,89 768 1,960 531 May June 5,984 2,240 1,536 816 1,296 22.3 2,570 743 1,827 836 2,020 472 5,783 2,097 1,849 656 1,166 22. 2,668 879 1,789 843 1,821 477 July Aug. 5,983 2,214 1,828 864 1, 181 22.3 3.5 2,763 808 1,956 902 1,817 447 Sept. 5,755 2, 156 1,619 822 1,164 20.2 2.519 796 1,723 905 1,795 454 Oct. 5,950 2, 18 1,803 775 1,216 20.8 8.0 2,718 862 1,855 863 1,863 492 Nov. 5,956 2,247 1,66 815 1,229 21.5 8.4 2,730 778 1,952 829 1,799 556 Dec. 5,698 2,218 1,645 792 1, 106 19.5 8 3 2,596 788 1,808 824 1,786 502 2023: Jan. 5,719 1,942 1,795 929 1,073 20.4 9.8 2,568 763 1,804 883 1,799 526 Feb. 5,962 2,294 1,838 812 1,051 19.3 8.9 2,766 807 1,959 888 1,844 521 Mar. 5,866 2,279 1,765 797 1,050 19.5 84 2,884 781 2, 104 841 1,683 506 Apr 5,715 1,867 1,920 748 1,089 20.8 8.7 2,676 760 1,916 786 1,778 519 764 1,851 527 May 6, 117 2,080 1,863 911 1,132 21.2 8.9 2,999 782 2,218 June 5,997 2,065 1,850 905 1,117 20.7 3.8 2,790 781 2,009 796 1,776 559 July. 5,904 2,007 1,741 956 1,205 20.6 39 2,703 72 1,980 854 1,868 534 6,340 2,224 1,913 970 1,326 20.4 B.8 2,946 813 2, 132 804 1,931 592 Aug. Sept. 6,347 2.053 2,043 985 1,303 21. 9.1 2.869 813 2,056 797 2,024 586 Oct. 6,443 2,269 1,836 1,079 1,291 21.6 B.6 3, 120 904 2,217 801 1,869 603 821 1,771 582 Nov. 6,262 2,069 2,060 931 1,220 19.5 9.0 3,058 889 2,169 Dec 6,268 2, 191 1,791 1,104 1.245 22.3 9.7 3,058 917 2,140 833 1,741 609 Because of independent seasonal adjustment of the various series, detail will not sum to totals. Beginning with 2011, includes unemployment durations of up to 5 years; prior data are for up to 2 years
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started