writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + + Line 10:
Line 11: − + − + − +
no edit summary
<div style="font-size:30px">'''STEYX(y,x)'''</div><br/>
<div style="font-size:30px">'''STEYX (KnownYs,KnownXs) '''</div><br/>
*<math>y</math> is set of dependent values.
*<math>KnownYs</math> is set of dependent values.
*<math>x </math> is the set of independent values.
*<math>KnownXs </math> is the set of independent values.
**STEYX(),returns the standard error of the predicted y-value for each x in the regression.
==Description==
==Description==
<math>\sqrt{\frac{1}{(n-2)}\left [ \sum(y-\bar{y})^2-\frac{[\sum(x-\bar{x})(y-\bar{y})]^2}{\sum(x-\bar{x})^2} \right ]}</math>
<math>\sqrt{\frac{1}{(n-2)}\left [ \sum(y-\bar{y})^2-\frac{[\sum(x-\bar{x})(y-\bar{y})]^2}{\sum(x-\bar{x})^2} \right ]}</math>
where <math>\bar{x}</math> and <math>\bar{y}</math> are the sample mean <math> x </math> and <math> y </math>.
where <math>\bar{x}</math> and <math>\bar{y}</math> are the sample mean <math> x </math> and <math> y </math>.
*In <math> STEYX(y,x)</math>, <math>y </math> is the array of the numeric dependent values and <math> x </math> is the array of the independent values.
*In <math>STEYX (KnownYs,KnownXs)</math>, <math>KnownYs </math> is the array of the numeric dependent values and <math> KnownXs </math> is the array of the independent values.
*The arguments can be be either numbers or names, array,constants or references that contain numbers.
*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.
*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
*This function will return the result as error when
1. Any one of the argument is non-numeric.
1. Any one of the argument is non-numeric.
2. <math>x</math> and <math>y </math> are empty or that have less than three data points.
2. <math>KnownYs</math> and <math>KnownXs</math> are empty or that have less than three data points.
3. <math>x</math> and <math>y </math> have a different number of data points.
3. <math>KnownYs</math> and <math>KnownXs </math> have a different number of data points.
==Examples==
==Examples==