Question: I need help on how to complete this assignment by showing the details please than you! The table below contains information about the median annual
I need help on how to complete this assignment by showing the details please than you!


The table below contains information about the median annual income and 2010 unemployment rate for Americans with various levels of education. Use charts to analyze the relationship between education and income as well as education and unemplovment Education Attained Less than a high school diploma High-school graduate Some college, no degree Associate degree Bachelor's degree Master's degree Professional degree Doctoral degree Median Annual Earnings $23,088 $32,552 $37,024 $39,884 $53,976 $66,144 $83,720 $80,600 Unemployment Rate (%) 14.9 10.3 9.2 7.0 5.4 4.0 2.4 1.9 0 4 Education The Education table contains information about the median annual income and 2010 unemployment rate for Americans with various levels of education. Use charts to analyze the relationship between education and income as well as education and unemployment. Task # Points 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. 10 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. 2 10 3 2 Add a linear trendline to the "Education and Income" chart. 4 2 Add a linear trendline to the "Education and Unemployment" chart. The table below contains information about the median annual income and 2010 unemployment rate for Americans with various levels of education. Use charts to analyze the relationship between education and income as well as education and unemplovment Education Attained Less than a high school diploma High-school graduate Some college, no degree Associate degree Bachelor's degree Master's degree Professional degree Doctoral degree Median Annual Earnings $23,088 $32,552 $37,024 $39,884 $53,976 $66,144 $83,720 $80,600 Unemployment Rate (%) 14.9 10.3 9.2 7.0 5.4 4.0 2.4 1.9 0 4 Education The Education table contains information about the median annual income and 2010 unemployment rate for Americans with various levels of education. Use charts to analyze the relationship between education and income as well as education and unemployment. Task # Points 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. 10 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. 2 10 3 2 Add a linear trendline to the "Education and Income" chart. 4 2 Add a linear trendline to the "Education and Unemployment" chart
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
