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.

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

• Highlight Normal Results in Line Charts, Making Extreme Results Stand Out

Other Help

• Microsoft Help for the STEYX Function.