Formulas > =POISSON()
How to Use POISSON() in Google Sheets
Description
How To Actually Use POISSON() in Sheets
POISSON(x, mean, cumulative)
Try POISSON yourself
In cells A1:A10, enter different values for 'x'. In cell B1, calculate the Poisson probability for each 'x' using a mean of 3. Your formula should return the probability for each 'x' in the range A1:A10.
Hints (2)
-
Remember to set the cumulative argument to FALSE for exact probabilities.
-
You can drag the formula down to fill B1:B10 after entering it in B1.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
More related tutorials
Transcript-matched member videos for POISSON(). Click through to watch.
REGEXMATCH Formula Generator for Google Sheets
Write Apps Script to Create a New Google Sheets Formula
One Weird Google Sheet Formula for Bulk Publishing With AI
Create a Trello Board with Transpose Formula in Google Sheets
Learn more about the POISSON() formula:
Generate a POISSON() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses POISSON(). 2 free AI generations, no signup. Members get unlimited use.
Generate a POISSON() formula