Format of the Project:

The Data Exercise must be posted to the LEO Student Assignments as a Attachments are limited to a maximum two files in doc, docx., xls. xlsx., or rtf. formats. OTHER FORMATS ARE NOT ACCEPTABLE, will not be reviewed or graded.

Please note that hand-written and scanned works, pdf. files, jpg. files, as well as files posted in google drive, will not be accepted or graded.

The paper should be written in APA style Research Paper format.

Please note that Use of APA Citation Methodology is required for all parts of the assignment

 

DATA EXERCISE #2 Consists of three parts

 

Part 1: The Unemployment Rate (weight 30% of the assignment grade)

Complete the following exercise

Visit the Bureau of Labor Statistics Web Site, www.bls.gov/news.release/empsit.toc.htm (http://www.bls.gov/news.release/empsit.toc.htm) . Select Employment Situation Summary.

Write a report (1 - 2 pages double spaced) to answer the questions:

1. What month (and year) is summarized? What was the unemployment rate for that month?

How does that rate compare with the rate in the previous month?

2. What were the unemployment rates for adult women, teenagers, blacks, Hispanics, and whites? How did these rates compare with those a month earlier?
3. What factors make it difficult to determine the unemployment rate?
4. Why is unemployment an economic problem?
5. What are the noneconomic effects of unemployment?
6. Who loses from unemployment?

 

Part 2: The Inflation Rate (weight 30% of the assignment grade)

Complete the following exercise:

Visit the Bureau of Labor Statistics Web Site,

www.bls.gov/news.release/cpi.toc.htm (http://www.bls.gov/news.release/cpi.toc.htm) . Select Consumer Price Index Summary.

Write a report (1 - 2 pages double spaced) to answer the questions:

1. What month (and year) is summarized? What was CPIU for that month?
2. What was the rate of inflation (percentage change in the CPIU) for the month? How does that rate of inflation compare with the rate in the previous month?
3. Which two categories of goods or services had the greatest price increase for the month?
4. Which two categories of goods or services had the lowest price increase (or greatest price decrease) for the month?
5. Who loses from inflation?

 

Part 3: Unemployment Data by Labor Force Groups and Duration (40% of the project grade)

 

Go to https://www.gpo.gov/fdsys/browse/collection.action?collectionCode=ERP&browsePath=2017&isCollapsed=false&leafLevelBrowse=false&isDocumentResults=true&ycord=0

the home page of the Economic Report of the President.

Scroll down and Click on the link download individual tables as Excel

This link is located below Appendix B: Statistical Tables Relating to Income, Employment, and Production.

1. Find unemployment data (Table B–12.—Civilian unemployment rate) for each year 2000 to present. Use four labor force groups: males, and females, in each case 16 to 19 years of age, versus 20 years of age or over.

1. Present the result in your project as a table.
2. Create one or more charts.

2. Use the Economic Report of the President (Table B–13.—Unemployment by duration and reason) to find data on the duration of unemployment for each year 2000 to present.

1.  Present the result in your project as a table.
2. Create one or more charts.

Write a report (1 - 2 pages double-spaced) about the 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 distribution of unemployment by duration over these years. Which years had the highest and lowest unemployment duration? What relationship, if any, do you find?
3. 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 natural rate of unemployment?

 

Grading Rubric for the Data Exercise #2

DATA EXERCISE #2	Â	Â	Â	Â	Â
Part 1: The Unemployment Rate (30% of the assignment grade)	Virtually no effort to complete part 1 of the exercise; not worthy of credit.	Only a superficial effort to complete part 1 of the exercise.	The project contains some data for the unemployment rate, but the analysis should be considerably more developed	Good effort is made to present and analyze the data in the unemployment rate.	Excellent and very thorough development and articulation in presenting and analyzing the data in the unemployment rate.
Part 2: The Inflation Rate (30% of the assignment grade)Â	Virtually no effort to complete part 2 of the exercise; not worthy of credit.	Only a superficial effort to complete part 2 of the exercise.	The project contains some data for the inflation rate, but the analysis should be considerably more developed	Good effort is made to present and analyze the data in the inflation rate.	Excellent and very thorough development and articulation in presenting and analyzing the data in for the inflation rate.
Part 3: Unemployment Data by Labor Force Groups and Duration (40% of the assignment grade)	Virtually no effort to complete part 3 of the exercise; not worthy of credit.	Only a superficial effort to complete part 3 of the exercise.	The project contains required data  for Unemployment by Labor Force Groups and Duration,  but the analysis should be considerably more developed	Very good effort in collecting Unemployment Data by Labor Force Groups and Duration, and analyzing the results	Excellent and very thorough development and articulation in presenting and analyzing the data Unemployment Data by Labor Force Groups and Duration .