DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to use the POISSON.DIST function in Excel office 365?

#tousethepoissondistf #excel #excelfunctions

POISSON.DIST function built-in statistical function returns the probability for the POISSON distribution. It takes the 2 arguments with the type of distribution function. Here, we will show the formulas to use the POISSON.DIST Function In Excel Office 365. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

POISSON.DIST Function syntax 

=POISSON.DIST(x, exp_mean, cumulative)
Enter fullscreen mode Exit fullscreen mode

Syntax Explanation:

  • x : number of events.
  • exp_mean : expected average or mean value for the event.
  • cumulative : logical value that determines the form of the function. If cumulative is TRUE, POISSON.DIST returns the cumulative distribution function ; if FALSE , it returns the probability density function.

Example

  • Firstly, you need to create the sample data with x number of events and expected mean.

Sample data

  • Then, you have to calculate the cumulative for the POISSON distribution function.
  • Now, you need to use the following formula given below. 
=POISSON.DIST ( B2, B3, FALSE)
Enter fullscreen mode Exit fullscreen mode

Cumulative distribution

  • After that, you can find out the probability value for the POISSON distribution function for the value at least 5 following the same parameters with the formula shown below. 
=POISSON.DIST ( B2, B3, TRUE)
Enter fullscreen mode Exit fullscreen mode

Probability mass distribution

NOTE:

  • The POISSON.DIST Function only works with numbers.
  • If any argument other than cumulative is non-numeric , the function returns #VALUE! error.
  • The function returns #NUM! Error.
    • If argument x < 0
    • If argument exp_mean < 0
  • Then, the argument x event is truncated to integers if not.
  • Now, the cumulative argument can be used with boolean numbers (0 and 1) or (FALSE or TRUE).
  • After that, the value in decimal and value in percentage id the same value in Excel and convert the value to percentage , if required.
  • Finally, you can feed the arguments to the function directly or using the cell reference, as explained in the example.

Verdict

We hope that this short tutorial gives you guidelines to use the POISSON.DIST Function In Excel Office 365. ** Please leave a comment in case of any **queries, and don’t forget to mention your valuable suggestions as well. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *Read more on Excel Formulas *!!

Read Next:

Top comments (0)