POISSON_DIST
function POISSON_DIST(arg1: number = null, arg2: number = null, arg3: boolean = null): numberDescription
Returns the Poisson distribution.
Parameters
- arg1
numberdefault: null The number of events.
- arg2
numberdefault: null The expected numeric value, a positive number.
- arg3
booleandefault: null A logical value (true or false) that determines the function form. If it is true, the function returns the cumulative Poisson probability. If it is false, the function returns the Poisson probability mass function.
Returns
numberTry It
const oWorksheet = Api.GetActiveSheet();
//method params
var x = 9;
var mean = 12;
var cumulative = false;
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.POISSON_DIST(x, mean, cumulative);
oWorksheet.GetRange("C1").SetValue(ans);