# Manuals/calci/STEYX

Jump to navigation
Jump to search

**STEYX (KnownYs,KnownXs)**

- is set of dependent values.
- is the set of independent values.
- STEYX(),returns the standard error of the predicted y-value for each x in the regression.

## Description

- 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 and values.
- The standard error for this line provides a measure of the error in the prediction of for an individual .
- The equation for the standard error of the predicted is:

where and are the sample mean and .

- In , is the array of the numeric dependent values and 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 non-numeric. 2. KnownYs and KnownXs are empty or that have less than three data points. 3. KnownYs and KnownXs have a different number of data points.

## Examples

1.

A | B | C | D | E | F | |
---|---|---|---|---|---|---|

1 | 6 | 8 | 10 | 13 | 15 | 5 |

2 | 1 | 4 | 8 | 11 | 20 | 3 |

=STEYX(A1:F1,A2:F2) = 1.4525201161135368

2.

A | B | C | D | E | |
---|---|---|---|---|---|

1 | 2 | 9 | 1 | 8 | 17 |

2 | 10 | 4 | 11 | 2 | 6 |

=STEYX(A1:E1,A2:E2)) = 5.944184833375669

3.

A | B | C | D | E | |
---|---|---|---|---|---|

1 | 1 | 2 | 4 | 5 | 8 |

2 | 10 | 4 | 7 | 5 |

=STEYX(A1:A5,B1:B4) = NAN

## Related Videos

## See Also

## References