How to use the POISSON.DIST function in Excel office 365?
Tags: tousethepoissondistf, excel, excelfunctions
Published: 2021-08-23 06:17:09

---
title: How to use the POISSON.DIST function in Excel office 365?
published: true
date: 2021-08-17 18:06:57 UTC
tags: ToUseThePOISSONDISTF,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-poisson-dist-function-in-excel-office-365/
---

 **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](https://www.microsoft.com/en-in/microsoft-365/excel)

## POISSON.DIST Function syntax

```
=POISSON.DIST(x, exp_mean, cumulative)
```

**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**.

![](https://geekexcel.com/wp-content/uploads/2021/08/sample-data-2.png)<figcaption>Sample data</figcaption>

- 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)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/cumulative-distribution-1-1024x165.png)<figcaption>Cumulative distribution</figcaption>

- 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)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/probability-mass-distribution-2-1024x167.png)<figcaption>Probability mass distribution</figcaption>

**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](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[Excel Formulas to Calculate the Cumulative Loan Interest ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-interest-easily/)**
- **[Formulas to Calculate the Cumulative Loan Principal Payments!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-principal-payments/)**
- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**