can someone help me with this DATA EXERCISE 2 Due at the End of Week 5 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 Research Paper format No more than 20 of the text of the project should be made up of quotes Please note that Use of Methodology is required for all parts of the assignment Written projects must be typed, , in 12 point or Arial font, with margins no wider than one inch have footnotes or endnotes, with correct citations have a bibliography of sources used include, for each entry, the author, title, city and state of publisher, publisher's name, year, and page numbers prepared using word processing software (Microsoft Word preferred), in a manner similar to the preparation of a written assignment for classroom submission 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 Please note that using the data from previously published releases and summaries will produce grade zero for this part of the project report to answer the questions 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 What were the unemployment rates for adult women, teenagers, blacks, Hispanics, and whites How did these rates compare with those a month earlier What factors make it difficult to determine the unemployment rate Why is unemployment an economic problem What are the noneconomic effects of unemployment Who loses from unemployment Please analyze and discuss the significance of the data that you received for this Data exercise Reflect on what you have learned from this exercise 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) You will be using Consumer Price Index Summary and the Table 1 Consumer Price Index for All Urban Consumers (CPI U) U S city average, by expenditure category Please note that using the data from previously published releases and summaries will produce grade zero for this part of the project report (1 ) to answer the questions What month (and year) is summarized What was the level of the CPIU for that month (See Table 1 Consumer Price Index for All Urban Consumers ) What does this number represent What was the rate of inflation (percentage change in the CPIU) for the last available month How does that rate of inflation compare with the rate in the previous month What was the rate of inflation (percentage change in the CPIU) for the last 12 months for all items Which two categories of goods or services had the greatest price increase for the last 12 months Which two categories of goods or services had the lowest price increase for the last 12 months Which two categories of goods or services had the largest price decrease for the last 12 months Who loses from inflation Who benefits from inflation Please analyze and discuss the significance of the data that you received for this Data Exercise Reflect on what you have learned from this exercise Part 3 Unemployment Data by Labor Force Groups and Duration (40 of the project grade) Go to https www govinfo gov app collection erp This is the home page of the Economic Report of the President Click on the last 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 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 Present the result in your project as a table Create one or more charts (line graph, bar graph, etc ) 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 Present the result in your project as a table Create one or more charts (line graph, bar graph, etc ) report (1 ) about the results you received In this paper consider, but do not be limited to the following Which years had the highest and lowest unemployment rates How do the rates compare among these groups Compare the unemployment rates by educational attainment How do the rates compare among these groups What relationship, if any, do you find 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 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 Please analyze and discuss the significance of the data that you received for this Data exercise Reflect on what you have learned from this exercise

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 26, 2024

can someone help me with this? DATA EXERCISE #2 Due at the End of Week 5 Format of the Project: The Data Exercise must be

can someone help me with this?

DATA EXERCISE #2

Due at the End of Week 5

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 Research Paper format.

No more than 20% of the text of the project should be made up of quotes.

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

Written projects must be:

typed, , in 12-point or Arial font, with margins no wider than one inch
have footnotes or endnotes, with correct citations
have a bibliography of sources used
include, for each entry, the author, title, city and state of publisher, publisher's name, year, and page numbers
prepared using word processing software (Microsoft Word preferred), in a manner similar to the preparation of a written assignment for classroom submission

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.

Please note that using the data from previously published releases and summaries will produce grade zero for this part of the project.

report to answer the questions:

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?

What were the unemployment rates for adult women, teenagers, blacks, Hispanics, and whites? How did these rates compare with those a month earlier?
What factors make it difficult to determine the unemployment rate?
Why is unemployment an economic problem?
What are the noneconomic effects of unemployment?
Who loses from unemployment?
Please analyze and discuss the significance of the data that you received for this Data exercise. Reflect on what you have learned from this exercise.

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). You will be using "Consumer Price Index Summary" and the "Table 1 Consumer Price Index for All Urban Consumers (CPI-U): U. S. city average, by expenditure category ".

Please note that using the data from previously published releases and summaries will produce grade zero for this part of the project.

report (1 - ) to answer the questions:

What month (and year) is summarized? What was the level of the CPIU for that month? (See Table 1 "Consumer Price Index for All Urban Consumers"). What does this number represent?
What was the rate of inflation (percentage change in the CPIU) for the last available month? How does that rate of inflation compare with the rate in the previous month?
What was the rate of inflation (percentage change in the CPIU) for the last 12 months for "all items"?
Which two categories of goods or services had the greatest price increase for the last 12 months? Which two categories of goods or services had the lowest price increase for the last 12 months?
Which two categories of goods or services had the largest price decrease for the last 12 months?
Who loses from inflation?
Who benefits from inflation?
Please analyze and discuss the significance of the data that you received for this Data Exercise. Reflect on what you have learned from this exercise.

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

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

This is the home page of the Economic Report of the President.

Click on the last 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.

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.

Present the result in your project as a table.
Create one or more charts (line graph, bar graph, etc.).
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.

Present the result in your project as a table.
Create one or more charts (line graph, bar graph, etc.).

report (1 - ) about the results you received.

In this paper consider, but do not be limited to the following:

Which years had the highest and lowest unemployment rates? How do the rates compare among these groups?
Compare the unemployment rates by educational attainment. How do the rates compare among these groups? What relationship, if any, do you find?
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?
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?
Please analyze and discuss the significance of the data that you received for this Data exercise. Reflect on what you have learned from this exercise.