For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  


STEYX Function

Returns the standard error of the regression, which also is known as the standard error of the estimate. The standard error is essentially the standard deviation around a trend line.

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports


STEYX(known_y's, known_x's)

  • known_y's  Required. An array or range of dependent data points.

  • known_x's  Required. An array or range of independent data points.

Applies To

Excel 2003 and above


If you're wanting to measure the variability of time-series data, it's usually a good idea to rely on the standard error (using the STEYX function) rather than the standard deviation (using the STDEV.S function). This is because the standard error removes variability imposed by the trend in the data, which the standard deviation does not.


You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area. 

This table shows trends in sales by date, with a chart that summarizes the data. The gray line is the TREND line. The orange lines, calculated in columns D and E, mark one standard error on each side of the trend.


Other ExcelUser Information

Other Help


Charley's SwipeFile charts

Free Excel Dashboards