STEYX(dependent, independent) returns the standard error of the predicted y-value for each x in the regression : STEYX « Statistical functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Statistical functions
3. STEYX

Input the formula: =STEYX(A2:A8,B2:B8). Press Enter to get the result.

Referenced from Excel Help

21.71.STEYX
	21.71.1.	STEYX(dependent, independent) returns the standard error of the predicted y-value for each x in the regression