Class TDistLt
- java.lang.Object
-
- org.apache.poi.ss.formula.functions.Fixed3ArgFunction
-
- org.apache.poi.ss.formula.functions.TDistLt
-
- All Implemented Interfaces:
FreeRefFunction
,Function
,Function3Arg
public final class TDistLt extends Fixed3ArgFunction implements FreeRefFunction
Implementation for Excel T.DIST() function.Syntax:
T.DIST (X,Deg_freedom,Cumulative)
Returns the Student's left-tailed t-distribution. 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.
- Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, T.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
- If any argument is non-numeric, T.DIST returns the #VALUE! error value.
- If Deg_freedom < 1, T.DIST returns the #NUM! error value.
- The Deg_freedom argument is truncated to an integer.
-
-
Constructor Summary
Constructors Constructor Description TDistLt()
-
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 TDistLt 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).
-
-