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

Statistical

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

Syntax

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

Remarks

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.

Example

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