The Income Levels Vary by Race and Educational Attainment

question 31

Essay

The income levels vary by race and educational attainment. To examine this inequality in the income, data have been collected for 7 different years on the median income earned by an individual based on the race and education.




a. Sort the PivotTable data to display the years with the smallest sum of median income on top and the largest on the bottom. Which year had the smallest sum of median income? What is the total income in the year with the smallest sum of median income?
b. Add the Racial Demographic to the Row Labels in the PivotTable. Sort the Racial Demographic by Sum of Median Income with the lowest values on top and the highest values on bottom. Filter the Row Labels so that only the year 2003 is displayed. Which Racial demography had the smallest sum of median income in the year 2003? Which Racial demography had the largest sum of median income in the year 2003?

---

Definitions:

Supplies Account

An account used to track the costs of supplies that have not been consumed by the end of an accounting period.

Operating Expenses

Costs associated with the day-to-day operations of a business, such as rent, utilities, and payroll.

Operating Income

The profitability from a company's core business operations, excluding deductions of interest and taxes.

Net Profit Margin Ratio

A financial performance metric that calculates the percentage of net income to revenue, indicating how much profit a company generates from its revenues.