(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