Please include steps and formulas used to complete this task. Thank 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 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 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 1 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 Add a linear trendline to the "Education and Income" chart. 3 Add a linear trendline to the "Education and Unemployment" chart. 4 Total: 24