F_DIST

Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets.

Syntax

expression.F_DIST(arg1, arg2, arg3, arg4);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange | ApiName | number		The value at which to evaluate the function, a nonnegative number.
arg2	Required	ApiRange | ApiName | number		The numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
arg3	Required	ApiRange | ApiName | number		The denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
arg4	Required	ApiRange | ApiName | boolean		A logical value that determines the function form. If this parameter is true, the function will return the cumulative distribution function, if it is false, it will return the probability density function.

Returns

number

Example

Return the (left-tailed) F probability distribution (degree of diversity) for two data sets in a spreadsheet.

// How to get the F probability distribution (degree of diversity) in a spreadsheet.

// Use function to calculate a left-tailed F probability distribution in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
let ans = func.F_DIST(10, 6, 4, false);
worksheet.GetRange("B2").SetValue(ans);