Class TDist
- java.lang.Object
-
- org.apache.poi.ss.formula.functions.Fixed3ArgFunction
-
- org.apache.poi.ss.formula.functions.TDist
-
- All Implemented Interfaces:
FreeRefFunction
,Function
,Function3Arg
public final class TDist extends Fixed3ArgFunction implements FreeRefFunction
Implementation for Excel TDIST() function.Syntax:
TDIST (X,Deg_freedom,Tails)
Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.
- X Required. The numeric value at which to evaluate the distribution.
- Deg_freedom Required. An integer indicating the number of degrees of freedom.
- Tails Required. Specifies the number of distribution tails to return. If Tails = 1, TDIST returns the one-tailed distribution. If Tails = 2, TDIST returns the two-tailed distribution.
- If any argument is non-numeric, TDIST returns the #VALUE! error value.
- If Deg_freedom < 1, TDIST returns the #NUM! error value.
- The Deg_freedom and Tails arguments are truncated to integers.
- If Tails is any value other than 1 or 2, TDIST returns the #NUM! error value.
- If x < 0, then TDIST returns the #NUM! error value.
-
-
Constructor Summary
Constructors Constructor Description TDist()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description ValueEval
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
evaluate(ValueEval[] args, OperationEvaluationContext ec)
-
Methods inherited from class org.apache.poi.ss.formula.functions.Fixed3ArgFunction
evaluate
-
-
-
-
Field Detail
-
instance
public static final TDist instance
-
-
Method Detail
-
evaluate
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)
Description copied from interface:Function3Arg
- Specified by:
evaluate
in interfaceFunction3Arg
-
evaluate
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec)
- Specified by:
evaluate
in interfaceFreeRefFunction
- Parameters:
args
- the pre-evaluated arguments for this function. args is nevernull
, nor are any of its elements.ec
- primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.- Returns:
- never
null
. Possibly an instance ofErrorEval
in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).
-
-