XL2000: The TDIST Function Returns #NUM! if the X Argument Is Negative (214371)
The information in this article applies to:
This article was previously published under Q214371 SYMPTOMS
In Microsoft Excel 2000, if you type a formula that uses the TDIST function, the formula may return a #NUM! error. This behavior may occur even when you use a value greater than or equal to 1 for the degrees_freedom argument, and a value of 1 or 2 for the tails argument.
CAUSE
This behavior occurs if the X argument is negative (less than zero) in the following syntax
TDIST(x,degrees_freedom,tails)
where x is the numeric value at which to evaluate the distribution.
RESOLUTION
To resolve this behavior, use a value that is greater than or equal to zero
for the X argument in the TDIST function.
MORE INFORMATION
In Microsoft Excel, the TDIST function allows you to calculate the
Student t-distribution. The t-distribution is used in the hypothesis
testing of small sample data sets. You can use the TDIST function in place
of a table of critical values for the t-distribution.
REFERENCESFor more information about the TDIST function, click Microsoft Excel Help on the Help menu, type tdist worksheet function in the Office Assistant or the Answer Wizard, and then click Search to view the topic. NOTE: The Help file does not mention any restrictions for the X argument. However, the following additional information does apply:
If x is less than 0, the TDIST function returns a #NUM! error.
| Modification Type: | Major | Last Reviewed: | 11/5/2003 |
|---|
| Keywords: | kbprb KB214371 |
|---|
|