Excel Function : STEYX

Download now!

Excel Function : STEYX

Category

Statistical

Description

Returns the standard error of the predicted y-value for each x in the regression

Microsoft Excel Reference Page

https://support.office.com/en-us/article/STEYX-function-6ce74b2c-449d-4a6e-b9ac-f9cef5ba48ab

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.