writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − ----+ − <div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function calculates the amount of error of the predicted y values for an individual x.</font></font></font></div>+ − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − * <font color="#484848"><font face="Arial, sans-serif"><font size="2">The Arguments can be numbers or names, arrays, or references. </font></font></font> − + − + + + + + + + + + + + − <br /><br /> − </div>+ − ----+ − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">+ + + + + + + + − STEYX+ + + + − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''B C'''</font></font></font> − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''25 15'''</font></font></font>+ − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''10 16'''</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''12 11'''</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''18 20'''</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''28 25'''</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''<nowiki>=STEYX(B2:B6,C2:C6) is 6.9</nowiki>'''</font></font></font> − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | class=" " | Column2 − | class=" " | Column3 − | class=" " | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f " | 25 − | class="sshl_f " | 15 − | class="sshl_f" | 6.895143 − | class="sshl_f" | − |- class="even" − | class=" " | Row2 − | class="sshl_f" | 10 − | class="sshl_f" | 16 − | class="sshl_f SelectTD ChangeBGColor SelectTD" | − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]</div> − | class="sshl_f" | − |- class="odd" − | Row3 − | class="sshl_f" | 12 − | class="sshl_f" | 11 − | class="sshl_f " | − | class="sshl_f" | − |- class="even" − | Row4 − | class="sshl_f" | 18 − | class="sshl_f" | 20 − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | class=" " | Row5 − | class=" " | 28 − | class="sshl_f " | 25 − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | Row6 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |} − − <div align="left">[[Image:calci1.gif]]</div></div> − ----
no edit summary
<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''STEYX'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(A</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''Y'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">, A</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''X'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''Where AY is the Array or range of dependent data points and AX is the independent data points.'''</font></font></font></div>
<div style="font-size:30px">'''STEYX(y,x)'''</div><br/>
*<math>y</math> is set of dependent values.
*<math>x </math> is the set of independent values.
* <font color="#484848"><font face="Arial, sans-serif"><font size="2">Empty cells, logical values, text, or error values are ignored. STEYX shows error value when AY and AX are empty or have less than three </font></font></font>
==Description==
* <font color="#484848"><font face="Arial, sans-serif"><font size="2">data points.</font></font></font>
*This function gives the standard error of the regression, which also is known as the standard error of the estimate.
*It is calculates the standard error for the straight line of best fit through a supplied set of <math> x </math> and <math> y </math> values.
*The standard error for this line provides a measure of the error in the prediction of <math> y </math> for an individual <math> x </math>.
*The equation for the standard error of the predicted <math> y </math> is: SQRT(1/(n-2)[summation (y-y(bar)^2-[summation (x-x(bar)(y-y(bar)]^2/summation(x-x(bar))^2] ,where x(bar) and y(bar) are the sample mean <math> x </math> and <math> y </math>.
*In <math> STEYX(y,x), y </math> is the array of the numeric dependent values and <math> x </math> is the array of the independent values.
*The arguments can be be either numbers or names, array,constants or references that contain numbers.
*Suppose the array contains text,logical values or empty cells, like that values are not considered.
*This function will return the result as error when
1. Any one of the argument is nonnumeric.
2. x and y are empty or that have less than three data points.
3. x and y have a different number of data points.
==Examples==
1.y={6,8,10,13,15,5}
x={1,4,9,11,20,3}
STEYX(G1:G6,H1:H6)=1.4350701130
2.y={2,9,1,8,17}
x={10,4,11,2,6}
STEYX(A1:A5,B1:B5)=5.944184833375
3.y={1,2,4,5,8}
x={10,4,7,5}
STEYX(A1:A5,B1:B4)=NAN
==See Also==
*[[Manuals/calci/INTERCEPT | INTERCEPT]]
*[[Manuals/calci/LINEST | LINEST ]]
*[[Manuals/calci/PEARSON | PEARSON ]]
==References==