Description Computes the standard error of the predicted y-value for each x in the regression.
Syntax STEYX (arrayX, arrayY)
| Argument | Description |
|---|---|
| arrayX and arrayY | A range reference or an array constant containing at least three numeric values. ArrayX and arrayY must contain the same potential number of values or the function will return the error value #N/A!All numeric values, including 0, are used. Text, logical values, and empty cells referenced by this function are ignored, along with the number they are paired up with. That is, when a number from arrayX is paired up with text from arrayY, the entire pair is ignored. The two ranges do not have to have the same shape or orientation: for example, arrayX may be 2 columns wide by 3 rows deep, and arrayY may be 1 column wide by 6 rows deep. The product of the number of rows and columns in each argument must be the same. |
Remarks This function pairs up the numbers in the two ranges by moving left-to-right through each sequential row.
Equation
Examples The examples are based on the following worksheet.
This function returns 3.651484:
This function returns 2.459675:
