F_DIST
function F_DIST(
arg1: number = null,
arg2: number = null,
arg3: number = null,
arg4: boolean = null,
): numberDescription
Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets.
Parameters
- arg1
numberdefault: null The value at which to evaluate the function, a nonnegative number.
- arg2
numberdefault: null The numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
- arg3
numberdefault: null The denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
- arg4
booleandefault: null 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
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.F_DIST(10, 6, 4, false);
oWorksheet.GetRange("B2").SetValue(ans);