Quick Navigation
STEYX Function
Summary
The Excel STEYX function calculates the standard error of the predicted y-value for each x-value in a linear regression analysis. This metric quantifies the accuracy of predictions made by the regression line, helping you understand the reliability of your forecasting model.
Syntax
STEYX(known_y's, known_x's)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| known_y's | Array/Range |
Yes | The dependent variable data - values you want to predict |
| known_x's | Array/Range |
Yes | The independent variable data - values used for prediction |
Using the STEYX Function
STEYX is crucial for regression analysis when you need to assess how well your linear model predicts outcomes. Use it alongside functions like SLOPE, INTERCEPT, and RSQ to get a complete picture of your regression model's performance.
Common STEYX Examples
Basic Regression Error Analysis
=STEYX(A2:A8,B2:B8)Calculates standard error using sample data where column A contains y-values (2,3,9,1,8,7,5) and column B contains x-values (6,5,11,7,5,4,4). Returns approximately 3.305719.
Sales Forecasting Reliability
=STEYX(C2:C20,D2:D20)Measures prediction error when forecasting sales (C column) based on advertising spend (D column).
Error Combined with R-Squared
=RSQ(A2:A8,B2:B8)&" (R²), STEYX(A2:A8,B2:B8)&" (Std Error)"Displays both correlation strength and prediction error in one cell.
Frequently Asked Questions
Common Errors and Solutions
#N/A error
Cause: Different number of data points in known_y's and known_x's
Solution: Ensure both arrays contain the same number of values
#DIV/0! error
Cause: Fewer than 3 data points or empty ranges
Solution: Provide at least 3 matching data points in both ranges
#VALUE! error
Cause: Ranges contain error values or unconvertible text
Solution: Clean your data to contain only numeric values
Notes
- STEYX uses the regression equation where x̄ and ȳ are sample means
- Ideal companion to SLOPE, INTERCEPT, and FORECAST functions
- Zero values are treated as valid data points
- Perfect for quality control in predictive modeling
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+