Returns the Poisson distribution.
Name | Type | Description |
arg1 | number | The number of events. |
arg2 | number | The expected numeric value, a positive number. |
arg3 | boolean | 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. |
builder.CreateFile("xlsx"); const oWorksheet = Api.GetActiveSheet(); //method params var x = 9; var mean = 12; var cumulative = false; var oFunction = Api.GetWorksheetFunction(); var ans = oFunction.POISSON(x, mean, cumulative); oWorksheet.GetRange("C1").SetValue(ans); builder.SaveFile("xlsx", "POISSON.xlsx"); builder.CloseFile();