STEYX function

Category: Statistical
Introduced: Excel 365

Summary

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

Syntax

STEYX(known_y's, known_x's) The STEYX function syntax has the following arguments:
• Known_y's Required. An array or range of dependent data points.
• Known_x's Required. An array or range of independent data points.

Example

=STEYX(A3:A9,B3:B9)

Microsoft Support Page

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

Back to Functions