$$Earnings ratios$$ and the $$wage gaps$$ are often reported in the media as a single $2$ dimensional statistic, e$.$g$.$women$$s earnings are $79\%$ of men$$s earnings,$$ or the $$male$/$female wage gap is $19\%.$ The goal of this question is to analyze these statistics in more detail.

The usual practice is to calculate the wage gap or earnings ratio by examining one characteristic at a time. For example:

The gender wage gap is defined as:

$($men$$s wages $$ women$$s wages$)/$men$$s wages

The racial $($or ethnicity$)$ wage gap is defined as:

$($white wages $$ black wages$)/$white wages

$($white wages $$ asian wages$)/$white wages

$($white wages $$ hispanic wages$)/$white wages

The gender earnings ratio is defined as:

$($women$\text{'}$s wages$/$men$$s wages$)$

Using the quarterly earnings data you

$(1)$ Using the quarterly earnings for $2004$ and $2023,$ calculate the annual averages for All Men and All Women, and each gender$/$race combo for $2004$ and $2023$

$(2)$ Using the $2004$ and $2023$ ANNUAL AVERAGES you just calculated, create and fill in the following tables $--$ one for Wage Gap and one for Earnings Ratios.

In the wage gap: always use the Men's earnings as the first part of the numerator, the Women's as the second part of the numerator, and the Men's as the denominator.

In the earnings ratio, always use the Women's earnings as the numerator and Men's earnings as the denominator