Statistical
Excel 2010
◉ 56 views
=POISSON.DIST()
Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=POISSON.DIST(x,mean,cumulative)
Hover argument names in the table for details.
Output typeStatistical
Popularity12 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =POISSON.DIST() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
x |
Number | Required | The number of events. |
mean |
Number | Required | The expected numeric value. |
cumulative |
Logical | Required | A logical value that determines the form of the probability distribution returned. If cumulative is TRUE, POISSON.DIST returns the cumulative Poisson probability that the number of random events occurring will be between zero and x inclusive; if FALSE, it returns the Poisson probability mass function that the number of events occurring will be exactly x. |
▣ Examples
▦ Data
| Cell | Value | Description |
|---|---|---|
A2 |
2 | Number of events |
A3 |
5 | Expected mean |
A4 |
2 | Number of events |
A5 |
5 | Expected mean |
Cumulative Poisson probability with the arguments specified in A2 and A3.
=POISSON.DIST(A2,A3,TRUE)
Result:
0.124652
Poisson probability mass function with the arguments specified in A2 and A3.
=POISSON.DIST(A2,A3,FALSE)
Result:
0.084224
§ Remarks
- If x is not an integer, it is truncated.
- If x or mean is nonnumeric, POISSON.DIST returns the #VALUE! error value.
- If x < 0, POISSON.DIST returns the #NUM! error value.
- If mean < 0, POISSON.DIST returns the #NUM! error value.
- POISSON.DIST is calculated as follows. For cumulative = FALSE: For cumulative = TRUE:
✦ Tips
- If x is not an integer, it is truncated.
⚠ Common Errors
#VALUE!
If x or mean is nonnumeric, POISSON.DIST returns the #VALUE! error value.
Fix: برای x و mean مقادیر عددی وارد کنید.
#NUM!
If x < 0, POISSON.DIST returns the #NUM! error value. If mean < 0, POISSON.DIST returns the #NUM! error value.
Fix: Correct the input value
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!