this assigment. (This is provided free by GCU; contact the Help Desk for more information and help 2 On this sheet, you will investigate the relationship between years of education and average income. First, consider the installing the software.) Using an earlier version of Excel or a different spreadsheet program may result in following chart of education versus average income. Below it, use Excel functions to find the slope and y-intercept of the best-fit | missing or corrupted template elements. Copying cells from or into this template may likewise result in line for the given coordinates. Then, to the right, use the slope and y-intercept to calculate the average weekly income for all corrupted data. years of education from 8 through 24. Finally, create a chart showing the BLS data as a scatterplot, and add an auto trendline to this chart showing years of education versus predicted average income superimposed on the BLS data and forecasting backward Legend to 8 years and forward to 24 years. (That is, the line should start at 8 years and end at 24 years on the horizontal axis.) Here, you should format your slope and y-intercept as numbers with 0 decimal places and your average weekly incomes as If a cell is shaded You should Currency with the $ symbol and 0 decimal places. Blue Enter a text response In case you'd like to explore the data, numbers here are derived from Bureau of Labor Statistics figures at Green Enter a number https://www.bls.gov/emp/tables/unemployment-earnings-education.htm. However, you don't need to take any steps related Enter an Excel Gold to this reference for the assignment. ormula Any other color Make no changes BLS Data Predicted Incomes Based on Best Fit Years of Education Average Weekly Income Years of Education Average Weekly Income (X (Y) (X) (Y =m*X+b) 10 $769.00 8 12 $826.00 9 3 Add your chart here with an appropriate title and axis labels: an XY-scatterplot of the BLS Data in columns 13 $1,138.00 10 A and B (NOT the data in columns C and D) plus an auto trendline forecasting backward to 8 years and 14 $1,069.00 11 forward to 24 years (not periods). 16 $1,707.00 12 18 $1,669.00 13 19 $2,238.00 14 20 $2,069.00 15 16 Best-Fit Line Parameters 17 18 Slope (m) 19 Y-Intercept (0, b) 20 21 22 23 24