Question

x	20	30	40	50	60
y	100	97	89	83	70

​(a) Use technology to find the estimates of

beta 0β0

and

beta 1β1.

beta 0β0almost equals≈b 0b0equals=

​(Round to two decimal places as​ needed.)

beta 1β1almost equals≈b 1b1equals=

​(Round to two decimal places as​ needed.) ​(b) Use technology to compute the standard​ error, the point estimate for

sigmaσ.

s Subscript eseequals=

​(Round to four decimal places as​ needed.)

Answer 1

(A) Copy and paste the data set into excel sheet

use excel function INTERCEPT, SLOPE and STEYX to find the intercept (Bo), slope(b1) and standard error Se

we get

= INTERCEPT(known y's, known x's)

select y data set as known y's and x data set as known x's

we get

= 117.40

and

= SLOPE(known y's, known x's)

select y data set as known y's and x data set as known x's

we get

= -0.74

(B) Se = STEYX(known y's, known x's)

select y data set as known y's and x data set as known x's

we get

Se = 3.0111