POISSON.DIST function in Excel

POISSON.DIST function in Excel


A common application of Poisson distribution is to predict the number of events in a specific time, such as you predict the number of cars to a toll booth in 1 minute, for example, the following article introduces you to POISSON.DIST function in excel, please follow along.


Jaw POISSON.DIST is one of the functions in the group of statistical functions that is very popular in Excel. Use this function to help you calculate in excel to get a Poisson distribution.

How to use the POISSON.DIST function in MS Excel

POISSON.DIST function in Excel

1. Description and syntax

This is the function that returns the Poisson distribution, the application function to predict the number of events in a specific time. Support function from version Excel 2013 onwards.

Syntax:

= POISSON.DIST (x, mean, cumulative)

Inside:

X is the event number.

Mean is the estimated numerical value.

Cumulative is the logical value

2. Attention

X and Mean is the required value

Cumulative is an optional value. Cumulative = True -> returns the cumulative distribution function; Cumulative = False -> returns the probability block function.

– In case X if not an integer then it will be truncated.

– In case X or if the mean is not numeric then the POISSON.DIST function will produce an error #VALUE!

– In case X less than zero then the POISSON.DIST function will produce an error #NUM!

– In case the median value is less than 0 then the calculation function POISSON.DIST will produce an error result #NUM!

– Function POISSON.DIST with cumulative is False Calculated based on the formula:

ham poisson dist in excel 2

– Function POISSON.DIST with cumulative is True Calculated based on the formula:

ham poisson dist in excel 3

3. Illustrative example

Calculate the Poisson distribution with specific information such as the spreadsheet image below:

ham poisson dist in excel 4

Step 1: Enter the syntax of the function calculated in the cell C3 as follows:

ham poisson dist in excel 5

Step 2: You press the key Enter To get the result of the function:

ham poisson dist in excel 6

0.151203882 is the Poisson distribution in the above example problem

In case X or if the median doesn’t have a numeric value, the POISSON.DIST function will produce an error #VALUE! As the picture below:

ham poisson dist in excel 7

ham poisson dist in excel 8

In case X is less than zero then the POISSON.DIST function will produce an error result #NUM! as shown below:

ham poisson dist in excel 9

Share on we have just taught you how to use POISSON.DIST function in Excel, this is a calculation function that helps you produce a Poisson distribution.

https://thuthuat.taimienphi.vn/ham-poisson-dist-trong-excel-44323n.aspx
In addition, you should learn and refer to the basic functions in Excel that Taimienphi.vn introduced, share to see and review formulas and how to use functions in Excel, wish you success. !

.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *