TRY NEW VERSION

POISSON

POISSON(arg1, arg2, arg3) → { number }

Returns the Poisson distribution.

Parameters:

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.

Returns:

Type
number

Example

Copy code
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();

Resulting document