Question
(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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started