Question 862217
<pre><font face = "consolas" color = "indigo" size = 3><b>
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)
     *[illustration scatter_1]
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