The Income Levels Vary by Race and Educational Attainment

question 39

Essay

The income levels vary by race and educational attainment. To examine this inequality in the income, data have been collected for seven 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:

Active Strategies

Deliberate efforts and techniques employed to address and manage problems, challenges, or tasks.

Unworthy of Love

A negative belief about oneself that suggests they do not deserve affection or care from others.

Adult Attachment

A framework within psychology that describes patterns of emotional bonds in adults, often mirroring those formed in infancy with primary caregivers.

Cathartic Release

The process of releasing or expressing pent-up emotions, which is believed to lead to psychological relief.