Excel: Incorrect F-Test F Critical One-Tail Value Returned

Last reviewed: September 12, 1996
Article ID: Q117362

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a

SYMPTOMS

In Microsoft Excel, when you use the F-Test: Two-Sample For Variances tool in the Analysis ToolPak to compare two data ranges, the F Critical one-tail result that is returned is incorrect.

CAUSE

This error occurs when the variance in the second range is greater than the variance in the first range. In this case, the F-Critical One-Tail value returned is for that of alpha*2. The value should be for that of 1-alpha. The F-Test: Two-Sample For Variances tool uses 0.5 as the value of alpha.

For example, if you use the F-Test: Two Sample For Variances tool to perform a two-sample F-test using the following ranges of data:

   A1: 1  B1: 1
   A2: 2  B2: 2
   A3: 3  B3: 3
   A4: 3  B4: 4

The variance in the range B1:B4 is greater than in A1:A4. If you use the range A1:A4 as the variable one input range, the F Critical One-Tail value returned is 5.390774. This matches the F distribution tables for alpha=.10 (alpha*2), instead of the correct value of .107798 (F distribution tables for alpha=.95 (1-alpha)).

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been corrected in Microsoft Excel version 5.0.

MORE INFORMATION

The F-Test: Two-Sample for Variances tool is available in the Analysis Tools dialog box by choosing Analysis Tools from the Options menu when the Analysis ToolPak add-in (ANALYSIS.XLA) is loaded.

REFERENCES

For more information about Using An Analysis ToolPak Tool, choose the Search button in Help and type:

   analysis

KBCategory: kbtool
KBSubcategory:
Additional reference words: 4.00 4.00a atp Ftest toolpack

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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.