Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets.
Name | Type | Description |
arg1 | number | The value at which to evaluate the function, a nonnegative number. |
arg2 | number | The numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10. |
arg3 | number | The denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10. |
arg4 | 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. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); var ans = oFunction.F_DIST(10, 6, 4, false); oWorksheet.GetRange("B2").SetValue(ans); builder.SaveFile("xlsx", "F_DIST.xlsx"); builder.CloseFile();