Question

The computer-science aptitude score, x, and the achievement score, y (measured by a comprehensive final), were measured for 10 students in a beginning computer-science course. The results were as follows. Calculate the estimated standard error of regression, s_b1. (Give your answer correct to two decimal places.)

x	5	18	8	15	13	19	13	22	7	12
y	16	25	35	18	22	19	33	21	22	33

Answer 1

Let's use excel:

Step 1) First enter the given data set in excel columns.

Step 2) Then click on Data >>> Data Analysis >>>Regression >>>>OK

Step 3) Input Y Range: Select the data of column "B"

Input X Range: Select the data of column "A"

Click on Lable

then Click on Ouput Range

Look the following Image

Then Click on OK, we get following result.

From the above output the estimated standard error of regression, sb₁ is 0.44 (after rounding upto two decimal places).