- Expert Academic and Article Professional Writing Service
- +1 323 471 4575
- support@essaysolver.com

Labor Economics Research Project

Order ID53563633773 TypeEssay Writer LevelMasters StyleAPA Sources/References4 Perfect Number of Pages to Order5-10 Pages

Description/Paper InstructionsLabor Economics Research Project

Name: _________________________________ Red-ID_________________________

By the due date, upload one Excel file and this Word file with answers typed in red font.

- (Excel) Consider John, who just turned 18 years old and is about to embark on a four-year degree program. The tuition for the course is $25,000 per year. John currently works at Target as an assistant manager making $85,000 per year and will have to quit his job to pursue the degree. Based on the BLS Occupational Handbook John anticipates his incremental earnings from his new job will be $30,000 each year following graduation (starting when he turns 22) until he retires on his 60th birthday. Assume all payments and income are incurred-received at the end of each year and that he can borrow/save at an interest rate of 6%.
- Calculate the net present value of this investment.
- Calculate the internal rate of return from the investment in education (state as a percent and round answer to tenth place)
- Based on the NPV and IRR, should he undertake the program? Why?
- (Excel) Consider Joel, a 26-year-old San Diegan who has just graduated from UCSD with a M.A. in Engineering. He has received two job offers, one in San Diego that pays him $120,000/year and another in Manhattan that will pay him $130,000/year. He is planning on working in the position, regardless of the location, until he finishes his 20th year of work. Due to the higher cost of living, his added monetary costs in Manhattan will be $25,000 each year for the first 5 years only. He can borrow/save at a rate of 6%. Using the information provided and assuming all costs and benefits are incurred/accrued at the end of each year determine the following:
- Calculate the net present value of his migration.

- Calculate the internal rate of return of his migration (state as percent and round answer to tenth place)
- Based on the NPV and IRR, should he migrate? Why?
- Visit the BLS website link provided here and using the report (table A, June 2019) complete the following:
- (Use Excel only) Using Figure 7.1 in the text as your template, generate a pie chart reflecting the Compensation Components for Private Industry.
- Do the same as above for State and Local Government data.
- Compare the two pie charts and determine which sector (Private or Government) is providing a compensating wage differential?
- Go to the Bureau of Labor Statistics website provided here and create a monthly labor force participation rate time-series graph for each of the following demographics. You are to cut and paste your graphs in this document. (use seasonally adjusted data only):
- Men >16: years 1980-2019
- Women >16: years 1980-2019
- Teenagers: years 1980-2019
- Bachelor’s Degrees and Higher (use left panel A-4 data): years 1992-2019 for age 25 and over.
- Less than a High School Diploma (use left panel A-4 data): years 1992-2019 for age 25 and over.
- Using the information from your graphs in #4 respond to each of the following:
- Do you notice any turning points where the trend has shifted during the periods specified? Explain.
- For each graph what, if anything, changed during the Great Recession (12/07-6/09)? Explain.
- Go to the Bureau of Labor Statistics website provided here to answer the following: What was the seasonally adjusted number of employed, unemployed, and civilian labor force (not percentage but a count of people in correct denominations) for September 2019. How do these numbers compare to the Great Recession numbers in June of 2009?
- Go to the Bureau of Labor Statistics website provided here to answer the following: What is the seasonally adjusted unemployment rate for each level of educational attainment (<HS, HS, AA, BA+) September 2019. For each level of educational attainment explain what happened (increased, decreased, or no change) in comparison to June 2009. What group was most affected by the Great Recession? Why? Explain.
- Go to the Bureau of Labor Statistics Current Employment Statistics website provided here and in sequence select “CES Databases” and “Top Picks” to find info about employment by industry. Use numbers only, not words: i.e. 100,000,000 instead of one hundred million. Round percentage answers to the nearest whole number.
- How many people were employed in “total private” and “manufacturing” in December 2007, June 2009, and January 2019? Calculate the percentage increase or decrease for these two intervals (12/07-6/09 and 6/09-9/19) round percentages to the tenth place. Based on the data, how did the Great Recession and subsequent recovery impact total private and manufacturing?
- On average how many hours did people work in “total private” and “manufacturing” in December 2007, June 2009, and September 2019? Calculate the percentage increase or decrease for these two intervals (12/07-6/09 and 6/09-118) round percentages to the tenth place. Based on the data, how did the Great Recession and subsequent recovery impact total private and manufacturing?
- On average, what was the hourly wage of “total private” and “manufacturing” in December 2007, June 2009, and September 2019? Calculate the percentage increase or decrease for these two intervals (12/07-6/09 and 6/09-9/19) round percentages to the tenth place. Based on the data, how did the Great Recession and subsequent recovery impact total private and manufacturing?
- How many people were employed in “manufacturing” and “leisure & hospitality” in January 1980 and September 2019? Calculate the percentage increase or decrease for both (round to a whole percent). What does this tell you about any changes in the structure of the U.S. economy over this time interval?
- For each of the following visit the corresponding website link and locate the appropriate data. Round ratios to the nearest 100th and percentages to the nearest 10th .
- (Site Link) In 2015 what percentage of the population over age 65 had achieved at least each of the following credentials:
- High School diploma
- Bachelor’s degree
iii. Associate’ degree

- Advanced degree
- Based on the data, do men or women have a higher probability of attaining at least a bachelor’s degree? What is the percent difference?
- (Site Link) In 2009 what was the median monthly earnings of someone age 35-44 for <HS, HS, associates/some college, bachelors, and advanced degree? Once you have this data calculate the ratio of earnings (not percent difference) of:
- HS graduate to <HS
- Associates to HS
iii. BA graduate to Associates

- Advanced degree to Bachelors
- BA to HS
- Write a brief narrative explaining the results of i-iv.
- (Site Link) Calculate the 2009 ratio of earnings for Advanced degree to BA graduate in each of the following demographic categories then identify the group that has the greatest and least benefit of attaining a graduate degree after a bachelor’s degree. What is the percentage difference between the highest group relative to the lowest group:
- White (non-Hispanic White alone)
- Black
iii. Asian

- Hispanic (of any race)
- Male
- Female
vii. Write a brief narrative explaining the results of i-vi.

- (Site Link) Using the 2009 educational data by region table, determine the following:
- Which region of the US has the highest and lowest college grad rates (identify region and their percent)?
- What are the top and bottom 3 states in terms of HS graduation rates (identify state and percent)?
iii. Write a brief narrative explaining the results from above.

- (Site Link) Using Table -1 of the Census Bureau’s Income and Poverty in the U.S. for 2015, answer the following:
- What is the median household income in 2015 and by what percent has it increased or decreased from the prior year?
- Which “Type of Household” had the highest and lowest median income in 2015? What are the figures? Give at least two reasons this difference might exist.
- Which “Race Origin of Householder” had the highest and lowest median income in 2015? What are the figures? Give at least two reasons this difference might exist.
- Which “Age of householder under 65” had the highest and lowest median income in 2015? What are the figures? Give at least 2 reasons this difference might exist.
- Determine the 2015 median income for “native born” and “naturalized citizen”? How much more/less in percent terms does a naturalized citizen make relative to a native born? Explain why this difference might exist.
- Which “Region” had the highest and lowest median income in 2015? What are the figures? Give at least 2 reasons this difference might exist.
- Looking at the EARNINGS OF ALL FULL-TIME YEAR ROUND WORKERS for 2015, calculate in percentage terms how much higher the median wage is for men relative to women. Give at least 2 compensating wage differential explanations for this difference.
- Using Page 8 of the Census Bureau’s Income and Poverty in the U.S. for 2015, answer the following:
- Determine how much in income a household would need to make to be in the 95th percentile of U.S. income earners?
- Using Table-3 of the Census Bureau’s Income and Poverty in the U.S. for 2015, answer the following:
- Determine which Race, Age, Sex, Nativity, Region and Education Attainment have the lowest and highest poverty rates in 2015? What are the figures?
- Using Table-5 of the Census Bureau’s Income and Poverty in the U.S. for 2015, answer the following:
- If the level of income necessary to qualify as “Poverty” was doubled, what percent of Hispanic (any race) would be considered under the poverty threshold?
- Visit the following BLS websites regarding union affiliation and income:
- Complete the following table.

Characteristic 2018 Actual Wage Advantage in Percentage Terms Compare “Represented by Unions” to “Non-Union”

Round % to tenths

2018 Percent of Employed Represented by Unions Use “Represented by Union”

Round % to tenths

Total over age 25 Men over age 25 Women over age 25 Black over age 16 White over age 16 Asian over age 16 Hispanic over age 16 Full-time workers ———N/A———— Part-time workers ———N/A————

- Based on the data, which race has the highest and lowest measured wage advantage from unionization? Give at least two reasons this difference might exist?
- Based on the data, which characteristic has the highest and lowest level of union representation? Give at least two reasons this difference might exist?
- Based on the 2018 “Members of Unions” data, what is the difference between the number of women over the age of 16 and men over the age of 16? Calculate overall and for each racial category (make sure to use proper denominations: i.e. 1000 thousands is written as 1,000,000) and indicate if there are more men or women that are members.
- Visit the following BLS website illustrating the wage and employment statistics from May 2016 and perform the following operations:
- Sort all occupations by annual mean wage. What industry is most represented in the top 10 highest paying occupations? What level of education do they all require?
- What industry is most represented in the bottom 10 (ignore the ones without data) and what level of education do they require?
- Click on the occupation labeled “Economists” and fill in the bell curve below with the hourly wage data provided. Also, include the median corresponding to the 50th percentile.
50th %

- Based on the completed bell curve, the top 10% of economists earn more than ___________ and the bottom 10% of economists earn less than___________?
- Locate the anticipated occupation you are going to compete in once graduating college. Create a similar bell curve based on the same BLS data. What do you believe you will need to do, or what skill do you think you will need to have, to be part of the 90th percentile? (If working with a partner you need to do this one for each person)

Tired of getting an average grade in all your school assignments, projects, essays, and homework? Try us today for all your academic schoolwork needs. We are among the most trusted and recognized professional writing services in the market.

We provide unique, original and plagiarism-free high quality academic, homework, assignments and essay submissions for all our clients. At our company, we capitalize on producing A+ Grades for all our clients and also ensure that you have smooth academic progress in all your school term and semesters.

High-quality academic submissions, A 100% plagiarism-free submission, Meet even the most urgent deadlines, Provide our services to you at the most competitive rates in the market, Give you free revisions until you meet your desired grades and Provide you with 24/7 customer support service via calls or live chats.

error: Content is protected !!

Open chat

You can contact our live agent via WhatsApp! Via our number +1 323 471 4575.

Feel Free To Ask Questions, Clarifications, or Discounts, Available When Placing the Order.