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