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.
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.