SOLUTION: 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
Algebra ->
Probability-and-statistics
-> SOLUTION: 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
Log On
Question 862217: 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. (Give your answers correct to two decimal places.)
x = 5 17 11 20 9 19 9 17 20 15
y = 33 32 32 32 23 19 24 15 27 25
I have the line of equation as
y (hat)=29.833 + 0.30x (however the .30 is incorrect)
Hi
using Excel scatter Plot features after entering columns for x and y in a spreadsheet:
y = -0.2559x + 29.833
the standard error of the predicted y-value for each x in the regression = 6.3725 (Standard Error of the Estimate)
se2,
(excel function STEYX)
x y y' y-y' (y-y')^2
5 33 28.5535 4.4465 19.77
17 32 25.4827 6.5173 42.48
11 32 27.0181 4.9819 24.82
20 32 24.715 7.285 53.07
9 23 27.5299 -4.5299 20.52
19 19 24.9709 -5.9709 35.65
9 24 27.5299 -3.5299 12.46
17 15 25.4827 -10.4827109.89
20 27 24.715 2.285 5.22
15 25 25.9945 -0.9945 0.99
324.87
6.37249951 Standard Error of the Estimate
