TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

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