Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An you help me with this Paste Merge & Center $ ~ % Conditional Formet Formatting as Table Styles HI x v fx C

An you help me with this

image text in transcribed
Paste Merge & Center $ ~ % " Conditional Formet Formatting as Table Styles HI x v fx C 5 On this sheet you will investigate the relationship between years of education and average income Furst consider the following chart of education versus average income Below It, use Excel functions to find the slope and Intercept of the best fit line for the given coordinates. Then, to the right, use the slope and y intercept to calculate the average weekly income for all years of education from it through 24. Finally, create a chart showing the BLS data is a scatterplot, and add on suto trendline to this chart showing years of education versus predicted average incom end on the BLS data and forecasting backward to B years and forward to 24 years (That is, the line should start at 8 years and and at 24 years on the Grirental axis. ) Legend there, you should format your slope and y intercept as num cimal places and your average weekly incomes as a cel is shaded You Should Currency with the 5 symbol and 0 decimal places Enter a text reponte 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.bis gov/emp/tables/unemployment ea education.htm, However, you don't need to take any steps related to Gold Enter an Excel this reference for the assignment formula Any other color Make no change 13: Your name from the Manthily Budget sheet Roberta Delgado 6 Add your chart here. a XY scatterplot of the BL Data In columns A and a (NOT the data in columns t 14 and Dj plans an auto trendine ward to B and forward to 24 years Years of Education Average Weekly Income Years of Education Average Weekly (7 = m'x .b) 10 $591.00 12 $758.00 $837 00 10 $890 00 14 12 $1.491.00 13 $1 840 00 $1.908 00 Slope (my Y-Intercept 10, bj

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

Theory Of Distributions

Authors: Svetlin G Georgiev

1st Edition

3319195271, 9783319195278

More Books

Students also viewed these Mathematics questions

Question

Wha t is proc rastination? (p. 3 02)

Answered: 1 week ago

Question

1. To generate a discussion on the concept of roles

Answered: 1 week ago