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, 20052014
The Father of Spreadsheet Dashboard Reports

Syntax
STEYX(known_y's, known_x's)
Applies To
Excel 2003 and above
Remarks
If you're wanting to measure the variability of timeseries
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
