Microsoft KB Archive/95520

Microsoft Knowledge Base

Excel: STEYX() Function Returns #DIV/0! Error

Last reviewed: September 12, 1996
Article ID: Q95520

The information in this article applies to:

• Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
• Microsoft Excel for the Macintosh, versions 4.0, 5.0

SUMMARY

The STEYX() function is a new statistical function included in Microsoft Excel, version 4.0. This function will return the error #DIV/0! if fewer than three data points are used both for the x-values and the y-values.

Page 421 of the version 4.0 "Microsoft Excel Function Reference," states that the STEYX() function returns the standard error of the regression. The function uses the following syntax

     =STEYX(known_y's,known_x's)

where known_y's is an array or range of dependent data points and known_x's is an array or range of independent data points.

The document should also include the information that there must be at least three data points for known_y's and known_x's. This is by design of the function.

REFERENCES

"Microsoft Excel Function Reference," version 4.0, Page 421

KBCategory: kbdocerr KBSubcategory: Additional reference words: 5.00 4.00 4.00a THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.