Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with the circled part please show me how to do it on excel 17 BLS Data Predicted Incomes Based on Best Fit Years

Need help with the circled part please show me how to do it on excel

image text in transcribed
17 BLS Data Predicted Incomes Based on Best Fit Years of Education Average Weekly Income ears of Education Average Weekly Income 18 (X] (Y) (x) (Y =m*X +b) 19 10 $625 8 20 12 $810 9 3 Below, insert an XY-scatterplot of the BLS Data in columns A and B ( not the predicted 21 13 $850 10 data in columns D and E). To that add a trendline forecasting backward to 8 years and 22 14 $925 11 forward to 24 years. (That is, the line should start at 8 years and end at 24 years on the 23 16 $1,275 12 horizontal axis.) Be sure to include an appropriate chart title and axis titles on the chart. 24 18 $1,525 13 25 19 $1,950 14 52 500 $1,925 15 Chart Title 26 20 $2 100 27 16 y = 141.05x - 915.35 28 17 $1 00 Best-Fit Line Parameters 29 18 30 Slope (m) 141.047486 19 20 500 Y-Intercept (b) -915.349162 21 SO 22 5 10 15 20 25 23 24

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finite Geometry And Combinatorics

Authors: F De Clerck ,J Hirschfeld

1st Edition

0521448506, 978-0521448505

More Books

Students also viewed these Mathematics questions