Education

Howard volunteers for a local youth group. He was asked to talk with the youth about the importance of education. He found some information about the median annual income and unemployment rate for Americans with various levels of education. Use charts to look at how education impacts income and unemployment.

Task Description

Construct a column chart to examine the median annual earnings for each level of education. Format the chart with a title "Education and Income" at the top, each education level on the horizontal axis, and no legend. Show data labels on the top of each of the "bars" of the graph. Add a linear trendline to the chart.

Construct a column chart to examine the unemployment rate for each level of education. Format the chart with a title "Education and Unemployment" at the top, each education level on the horizontal axis, and no legend. Show data labels on the top of each of the "bars" of the graph. Add a linear trendline to the chart.

Data