Need help with math problem. Length and uses microsoft excel?
(1) In cell C16, enter the expression =SLOPE(B6:B14,A6:A14).
(2) In cell C17, enter the expression =INTERCEPT(B6:B14,A6:A14).
The slope and intercept we obtain, let’s call them m and b, are the values such that the line with equation y = mx+b
is as close to the original data as possible everywhere. This line is called the best-fit line, or regression line.
• Use the values of m and b to fill out column C, the regression column: on each line, you want the y value (earnings
in $) that correspond to the number of years x for this line, under the relation y = mx + b.
(i was able to put all of the #’s in and fill out columns a and b and also find the slope and y-intercept. How would i fill out column c using an equation.
A B
Years Earnings
8 $18,377
10 $12,906
12 $21,726
13 $24,438
14 $27,722
16 $46,142
18 $49,772
20 $66,812
22 $82,095
Slope 4937.25
Intercept -34073.91
Favorite Answer
m= slope, b = interception. You have the x values.
So, basically, there are two ways:
1) you repeat the equation “=SLOPE(…)*A#+INTERCEPT(…)
2) you repeat the equation “=C16*A#+C17”, where # is the number of the line you work with.
That’s all (and yes, you have to do your homework, not just copy words like a robot -in case you did that).
