Name

STEYX

Synopsis

Use STEYX to find the standard error of each y-value for the corresponding x-value in the regression.

To Calculate

=STEYX(Known_Y's, Known_X's)

Both arguments are required for this function.

Example

Figure 15-45 illustrates how to use STEYX to find the standard error of the y-values in the regression.

Use STEYX to find the standard error for the specified data points

Figure 15-45. Use STEYX to find the standard error for the specified data points

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.