TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

T_DIST

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

Returns the left-tailed 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 boolean

A logical value (true or false) that determines the function form. If it is true, the function returns the cumulative distribution function. If it is false, the function returns the probability density function.

Returns:

Type
number

Example

Copy code
builder.CreateFile("xlsx");

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

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

Resulting document