Excel Function : STEYX
Returns the standard error of the predicted y-value for each x in the regression
Microsoft Excel Reference Page
Syntax and Description of the STEYX Excel Function
The syntax for the STEYX function in Microsoft Excel is: STEYX( known_y's, known_x's ) Where the known_y's and known_x's arguments are the sets of known y-coordinates and x-coordinates that you want to use to calculate the standard error of the y-estimate.
About STEYX Excel Function
STEYX is an Excel function that returns the standard error of the predicted y-value for each x in a linear regression. The standard error is a measure of the variability of the prediction and is used to construct confidence intervals.