Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(1) From the CPS homepage at the BLS (addcheress given above), find the CPS Databases. Find the link to the Top Picks for Weekly &

(1)From the CPS homepage at the BLS (addcheress given above), find the "CPS Databases". Find the link to the "Top Picks" for Weekly & Hourly Earnings. Under the top picks, choose (by clicking the boxes) Median weekly earnings for those 25 years and over with a Bachelor's Degree only, high school grads and those with less than high school diploma ("LT High sch dipl"). Retrieve the weekly median earnings for the three groups.

a.Using data from the most recent quarter, calculate 2 ratios in Excel: the ratio of weekly earnings of college graduates to weekly earnings of high school graduates and the ratio of weekly earnings of college graduates to weekly earnings of those with less than a high school diploma.

b.Using Excel, make a bar graph showing the 2 ratios. (provide a proper title, labels, source citation, etc.)

year being 2020

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Macroeconomics

Authors: Paul Krugman, Robin Wells

4th Edition

1464110379, 9781464110375

More Books

Students also viewed these Economics questions

Question

=+d) State the conclusion from this analysis.

Answered: 1 week ago