T_DIST
function T_DIST(arg1: number = null, arg2: number = null, arg3: boolean = null): number
Description
Returns the left-tailed Student's t-distribution.
Parameters
- arg1
number
null The numeric value at which to evaluate the distribution.
- arg2
number
null An integer indicating the number of degrees of freedom that characterize the distribution.
- arg3
boolean
null 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
number
Try It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.T_DIST(1.5, 10, false);
oWorksheet.GetRange("B2").SetValue(ans);