SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / POISSON.DIST
In This Topic
    POISSON.DIST
    In This Topic

    This function returns the Poisson distribution.

    Syntax

    POISSON.DIST(nevents,mean,cumulative)

    Remarks

    This function has these arguments:

    Argument Description
    nevents Number of events; provide an integer, or the value is truncated; the number must be greater than zero
    mean Expected numeric value; the number must be greater than zero
    cumulative Set to TRUE to return the cumulative Poisson probability that the number of random events occurring is between zero and nevents inclusive. Set to FALSE to return the Poisson probability mass function that the number of events occurring is exactly nevents.

    Remarks

    The cumulative Poisson probability is calculated as follows:

    Cumulative Poisson Probability Equation

    The Poisson probability mass function is calculated as follows:

    Poisson probability mass function

    where x is the number of events (nevents argument), mu is the mean (mean argument).

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    POISSON.DIST(A3,B4,TRUE)

    POISSON.DIST(R1C2,3,FALSE)

    POISSON.DIST(7,4,TRUE) gives the result 0.9488663842071525

    POISSON.DIST(7,4,FALSE) gives the result 0.059540362609726345