Please help me with this assignment. Thank you so much in advance.
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 unemployment data (Table B-27 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 result in 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. Present the 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 highestand lowestunemploymentrates? How do the rates compare among these groups? 2. Compare the unemploymentrates 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 highestand lowest unemployment duration? Whatrelationship, 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 unemploymentrate? 5. Please analyze and discuss the significance of the data that you received for this Data exercise. 6. Reflecton what you have learned from this exercise. PRESENTATION OF THE DATA EXERCISE AND USE OF APA CITATION METHODOLOGY (10%) of the project grade): Organization, format, and presentation of paper including the title page, introduction, body, and summary. Begin each section with a subheading; use the subheadings described in the assignment (3% of the project grade). + Use of tables, figures, and other graphics to summarize and support analysis presented in the paper. All tables and charts should have the numbering system: Table 1, a substantive title, and a reference to the source of the information. (3% of the project grade). Research sources and significance of research information and data, and use of APA citation methodology (4% of the project grade). TABLE B-27. Civilian unemployment rate, 1978-2023 [Percent : monthly data seasonally adjusted] By educational attainment By race or ethnicity 2 (25 Years & Over) By sex and age MBESUTE of labor LESS High Some Bach- All His- Woman Black or under than school college elor's civilian Men panic or Year or month Both a high grady- or as- degree 20 20 African workers Asian Latino and years Years SEXES White ethnic tion school ates, no sociate Aman- and 16-19 can diploma college degree higher and ity Over over 6.0 16.4 128 1978 4.3 5.2 9.1 6.1 5.1 123 83 58 4.2 5.7 16.1 1979 ... 6.3 143 101 1980 7.1 59 6.4 17.8 63 6.8 196 6.7 156 10.4 7.6 189 13 81 1981 .. 9.7 8.8 8.3 23.2 8.6 137 1982 .... 9.6 89 8.1 224 8.4 195 6.5 10.7 1983 .. 7.5 6.6 6.8 189 159 1984 ..... 6.2 151 105 7.2 62 6.6 186 6.0 145 106 1985 .... 7.0 61 6.2 5.3 8.8 1986 .... 5.4 13.0 6.2 SEBE 11.7 82 1587 .... 5.5 4.9 4.7 8.0 1988 .. 5.3 45 150 4.5 114 5.5 4.8 11.4 82 1930 ... 5.6 50 64 6.1 12.5 10.0 3.2 1991 6.8 1.6 7.1 14.2 29 7.5 6.6 0.8 1932 ..... 2.6 6.9 64 13.0 11.5 9.9 10.9 1595 ..... 24 1994 ... 6.1 5.4 4.0 5.6 1.8 4.9 104 10.1 16.7 4.7 10.5 8.9 9.7 3.7 2.2 19:5.. 5.4 4.6 7.7 8.9 195 ......... 4.9 4.2 16.0 10.0 7.2 8.0 1997 .... 3.7 14.6 3.9 8.9 7.4 67 1.8 198 ..... 3.5 3.9 80 6.4 1999 63 4.0 3.6 13.1 7.6 3.6 5.7 7.0 17 20 0 0 3.3 47 147 6.6 8.1 29 2001 ..... 165 102 5.9 75 9.6 75 10.1 2012 5.8 5.3 108 77 6.0 56 6.0 8.8 31 70 9.6 4.2 27 2003 ...... 50 4.9 170 10.4 4.4 23 2004 ..... 5.5 4.6 10.0 4.0 6.0 5.1 4.3 20 205 ......... 4.6 40 4.1 15.4 4.4 20 Zub ......... 1.6 4.1 4.0 15.7 05 57 4.6 26 2007 ..... 54 4.9 18.7 148 12.1 16.2 4.6 9.7 8.0 4.6 2008. 9.3 9.6 7.5 24.3 10 3 8.4 4.7 2009 9.6 9.8 25.9 16.0 75 8.0 4.3 2010 ...... ......" 24.4 7.1 4.0 2011 .. 8.9 8.1 7.5 24.0 3.8 5.9 2012 .... 7.0 22.9 13.1 5.2 13 8 6.4 3.7 5.4 3.2 2013 7.4 57 19.6 11.3 50 20 60 6.2 9.6 3.8 104 54 4.5 2.6 2014 16.9 2.5 2015 53 4.9 5.2 4.1 2.3 2016 1.9 4.5 15.7 43 8.4 36 3.8 4.4 4.0 14.0 7.5 34 4.6 3.3 2.1 2017 39 3.6 12.9 6.5 3.0 4.1 3.0 2.1 2018 3.4 6.1 2.7 5.4 3.7 2019 3.7 11.7 9.0 7.8 4.8 2020 81 7.4 80 10.4 6.2 5.1 3.1 4.0 2021 5.2 2.0 53 3.1 2.1 2022 3.6 3.4 3.0 3.9 3.0 3.5 3.5 2.3 2023 3.61 3.8 7.0 4.6 4.4 2.2 2022: Jan . 4.0 3.1 3.8 3.5 6.6 20 Feb ...... 3.6 34 3.4 10.3 2.7 20 3.7 35 3.3 0.6 3.0 1.9 3.4 3.4 105 2.4 3.6 3.1 21 May 34 3.3 09 58 2.9 2.8 20 June 3.6 3.3 July 3.5 3.6 35 3.2 2.8 1.4 2.9 19 Aug . 3.3 3.1 2.5 3.7 2.9 1.8 4.0 1.9 Sept 3.5 3.0 2.0 Oct. 3.6 3.3 39 Nov. 36 3.3 3.a 3.0 1.9 35 3.1 2.0 Dec. 2023: Jan .... 3.4 3.2 2.0 Feb .... 3.6 3.0 35 3.4 3.2 1.9 Mar 3.3 3.1 9.3 4.8 2.0 Apr .... 34 3.5 3.3 10.3 69 6.0 3.9 3.0 2.0 May . 3.7 11.2 6.0 31 3.1 2.0 June . 3.6 3.4 31 35 3.4 31 11.3 5.7 4.4 5.3 3.3 4.9 5.4 3.9 3.1 2.2 July .... 3.7 32 12.3 5.3 7.0 5.5 4.1 3.0 2.2 Aug ...... 3.8 3.4 2.9 4.6 3.8 3.8 3.1 11.8 5.7 13.1 3.5 5.8 4.8 72 5.8 4.0 3.1 2.1 Sept. 3.8 3.7 3.2 5.8 4.6 7.0 63 4.1 28 Oct....... 11.4 50 60 31 NOV..... 3.7 35 19 Dec ..... ! Unemployed as percent of civilian labor force in group specified. See footnote 1, Table B-23. Total unemployed, plus all persons marginally attached to the labor force, plus total employed part time for economic reasons, as a percent of the civilian labor force plus all persons marginally attached to the labor force. "Includes persons with bachelor's, master's, professional, and doctoral degrees.TABLE 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 Un- 27 Average Job losers Year or month amplay- Less Median Job New 5-14 15-26 weeks mean ment than 5 duration entrants entrants and duration leavers weeks weeks Weeks Total On [weeks Other (weaks| layoff 2,865 1,923 766 648 11.9 5.9 2,585 712 1,873 874 1,857 385 B/BL 6,202 E80 1,806 817 6,137 2,960 1,946 706 535 10.B 5.4 2,635 851 1,784 3.947 2,459 191 1,927 872 1980 ... 7,637 3.295 2,470 1,052 820 11.9 6.5 1,48 3.449 2,539 1,122 1,162 13.7 6.9 4 267 1,43 2.837 923 2,102 981 1981 8,273 3.863 3.311 1.708 1,776 15.6 8.7 6.268 2,127 4.141 840 2.384 1,185 1982 . 10.678 1.780 4,478 830 2.412 1.216 1983. 10,717 3.570 2.937 1.652 2,559 20.0 10.1 6.258 7.9 4 421 1,171 3,250 B23 2,184 1,110 8,539 3.350 2,451 1,10 1,634 18.2 2,509 1.025 1.280 15.6 6.8 4,139 .157 2,982 877 2.256 1.039 1985 8,312 3,498 090 2,943 1,015 2.160 1.029 1986 8.237 3,448 2.557 1.045 1,187 15.0 6.9 4,033 14.5 6.5 3.566 943 2 623 965 1.974 1987 7 425 3,24 2,196 943 1,040 13.5 5.9 3 092 851 2.241 983 1.809 816 809 1986 -.. 6.701 3,084 2,007 801 3.17 1.978 730 646 11.9 4.8 2 983 850 2,133 1,024 1.843 677 1989. 6 528 2.359 1.041 688 1990 7 047 1,028 1,930 3,265 2,25 822 703 12.0 5.3 3,387 1,111 13.7 6.8 4.694 1,292 3.402 1,004 2,139 792 1941 B,626 3 490 2 791 ,246 9613 3.376 2 830 1,453 1,95 17.7 B.7 5.389 1,260 4 129 002 2,285 937 1992 3.733 976 2, 198 919 1943 B 940 3 262 2 584 1.297 1,798 180 B.3 4.848 1,115 477 2 838 791 2 786 604 1994 7 996 2 728 2 408 1237 1,623 18.8 9.2 3.815 7 404 2.700 2.342 1,085 1,278 16.6 B.3 3,476 1,030 2 446 824 2.525 579 1995 2.349 774 2.512 580 1946 7.236 2 633 2 287 053 1.262 16.7 B.3 3,370 1 021 931 2,106 796 2.338 569 1907 6,739 2,538 2 138 995 1,067 15.8 3.037 1 950 763 `875 14.5 67 2,822 866 1,957 734 2,132 520 1498 6.210 2,622 725 13.4 6.4 2,622 948 1,774 783 2,006 469 1949 5.880 2,568 1.832 756 669 649 12.6 5.9 2,517 852 1,664 780 1,961 434 2000 5,692 2.558 1,815 2 853 2.196 451 801 13.1 6.8 3,476 1,067 2,409 835 2,031 459 2001 6,801 BLE'B 2,893 2.580 1.369 1,535 16.6 9.1 4,607 1,124 3,483 866 2.368 536 2002 19.2 10.1 1,121 3,717 818 641 1,936 4,838 2003 8,774 2,785 2,612 1,442 8.149 2,696 2,382 1.293 1,779 19.6 9.8 4,197 998 3,199 858 2,408 686 2004 1,490 18.4 8.9 3,667 933 2,734 B72 2,386 666 2005 7 591 2.667 2,304 1,130 9121 2,400 827 2,237 616 2006 7,001 2,614 2,121 1.031 1 235 16.B 8.3 3,321 793 2,142 627 2007 7,078 2,542 2,232 1,061 i .243 16.B 8.5 3,515 976 2,539 2,804 1,427 1,761 17.9 9.4 4,789 1,176 3,614 896 2,472 766 2008 8,924 2,932 2,775 4,496 24.4 15.1 9,160 1,630 7,530 892 3,187 1,035 2009 14,265 3,165 3,828 1,220 2010 14,825 2,771 3,267 2,371 6,415 33.0 21.4 9,250 1,431 7,819 889 3.466 13,747 2,677 2,993 2,061 6.016 39.3 21.4 B. 106 1,230 6,876 956 3,401 1,284 2011 1. 859 5,136 39.4 19.3 6,877 1,183 5.694 967 3,345 1,316 2012 .. 12 506 2.644 2,866 2.584 2,759 1,807 4,310 36.5 17.0 6.073 1,136 4.937 932 3,207 1.247 2013 .. 11,460 3,218 33.7 14.0 4.878 1.007 3,871 824 2,829 1.086 9617 1,497 2014 -. 2,471 2,432 879 2015 B 296 2.399 2,302 ,267 2,328 29.2 11.6 4.063 974 3:089 819 2 535 2 330 B23 2016 7,751 2,362 2.226 1,158 2,006 27.5 10.6 3.740 966 2,774 6.982 2,270 2 00B 017 1,687 25.0 10.0 3.434 956 2 479 778 2.079 690 2017 2,138 794 1.928 602 2018 .. 6 314 2.170 1,876 917 1,350 22.7 9.3 2.990 852 1.810 591 2019 ... 6001 2 086 1.789 860 1,266 21.6 9.1 2,786 823 1 963 814 12 947 3,708 4,728 2,516 1,995 16.5 9.7 9,770 6,371 3,399 683 1.969 526 2020 .. 2,140 1,981 1.164 3,337 28.7 16.5 5,099 1.582 3,516 803 2,20 518 2021 .. 8,623 B.7 2,767 830 1.936 857 1.891 482 2022 5.996 2 216 1,711 756 1,314 22.6 1,831 556 6,080 2,112 1,866 925 89 2,870 811 2,059 822 2023 1,177 20.6 1,715 24 5 10.0 3,267 993 2,274 950 1,961 438 2022: Jan 6,549 2.472 1,611 786 428 Feb 6,279 2,145 1.768 1 615 26.3 10.0 2.994 857 2,136 959 1,95 567 1,422 24.2 8.8 2,725 710 2,015 786 2,039 481 Mar 5.993 2.306 1,723 921 2,011 793 1.856 502 Apr -.... 6.034 2,277 809 L 647 1,354 24.8 8.5 2,932 531 5,966 2,030 1.757 696 1,333 22.4 8.9 2,713 822 1.891 768 1.960 May .. 5,984 2.240 1,536 816 1,296 22.3 B.1 2,570 743 1,827 836 2,020 472 June .... 879 1,789 843 1,821 477 July ... 5,783 2,097 1,849 656 1,166 22.1 8.3 2,668 447 864 1,181 22.3 8.5 2,763 1,956 902 1,817 Aug. 5,983 2.214 1,828 5,755 2,156 1,619 822 1,164 20.2 8.1 2,519 796 1,723 905 1,795 454 Sept ... 492 5.950 2.189 1,803 775 1216 20.B 8.0 2,718 862 1,855 863 1.863 Oct...... 815 1.229 8.4 2,730 T78 1,952 B29 1,799 556 NOV ..... 5956 2,247 1,665 1,645 792 1,106 19.5 8.3 2,596 1,808 1,786 502 Dec ....... 5.698 2,218 2023: Jan ... 5,719 1,942 1,795 929 1,073 20.4 9.8 2,568 763 1,804 883 1,799 526 1.959 838 1,844 521 Feb ..... 5,962 2.294 1 838 812 1,051 8.9 2,766 807 506 5 866 2,279 1,765 797 1,050 9.5 8.4 2,884 781 2,104 841 1,683 Mar ... 519 5.715 1.867 1,920 748 1,089 20.8 8.7 2,676 760 1,916 786 1,778 Apr .... 6.117 2.090 1,863 911 1,132 21.2 8.9 2,999 782 2,218 764 1,851 527 Mary ... 2,009 796 1,776 559 June .. 5 997 2 065 1,850 905 1,117 20.7 8.8 2,790 781 8.9 2,703 723 1,980 854 1,868 534 July 5 904 2007 1,74 956 1,206 20.6 6.340 2,224 1 913 97D 1,326 20.4 B.8 2,946 2, 132 1931 Aug .. 1,303 1.4 9.1 2,869 2,056 797 2,024 6,347 2,043 985 Sept....... 2 053 2.217 LOB 1,869 603 Oct.... 6.443 2.269 1,836 1,079 1,291 8.6 3,120 9.0 3.058 889 2,169 821 1,77 582 6.262 2,060 `931 NOV ... 2.069 1,220 3.058 917 2,140 833 1,741 609 Dec ...... 6.268 2.191 1,791 1,104 1,245 223 9.7
