TRY NEW VERSION

TDIST

TDIST(arg1, arg2, arg3) → { number }

Returns the Student's t-distribution.

Parameters:

Name Type Description
arg1 number

The numeric value at which to evaluate the distribution.

arg2 number

An integer indicating the number of degrees of freedom that characterize the distribution.

arg3 number

Specifies the number of distribution tails to return: one-tailed distribution = 1; two-tailed distribution = 2.

Returns:

Type
number

Example

Copy code
builder.CreateFile("xlsx");

var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.TDIST(1.5, 10, 1);
oWorksheet.GetRange("B2").SetValue(ans);

builder.SaveFile("xlsx", "TDIST.xlsx");
builder.CloseFile();

Resulting document