T_DIST
Returns the left-tailed Student's t-distribution.
Syntax
expression.T_DIST(arg1, arg2, arg3);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| arg1 | Required | ApiRange | ApiName | number | The numeric value at which to evaluate the distribution. | |
| arg2 | Required | ApiRange | ApiName | number | An integer indicating the number of degrees of freedom that characterize the distribution. | |
| arg3 | Required | ApiRange | ApiName | 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
number
Example
This example shows how to return the left-tailed Student's t-distribution.
- Code
- Result
// How to calculate the left-tailed Student's t-distribution.
// Use a function to estimate the Student's t-distribution left-tailed.
let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
let ans = func.T_DIST(1.5, 10, false);
worksheet.GetRange("B2").SetValue(ans);