Microsoft KB Archive/96325

= Microsoft Knowledge Base =

Excel: Answer to TTEST Example Is Not 0.191996
Last reviewed: September 12, 1996

Article ID: Q96325

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
&quot;Online Help,&quot; version 5.0 and page 439 of the &quot;Microsoft Excel Function Reference&quot; version 4.0, give an incorrect answer in the example of the TTEST function. The example states that the answer to the sample function is 0.191996. This answer is correct if the type argument is 2. However, in the example, the type argument is 1 (paired); therefore, the correct answer to the example is 0.196015785.