Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch05-ESA.pdf
Learn about the Poisson Distribution and how to calculate probabilities using the POISSON.DIST function.
Topics:
1. (00:00) Introduction
2. (00:22) Data for arrivals at Dick’s Hamburgers restaurant
3. (01:05) Poisson Distribution Characteristics and requirements
4. (03:36) Poisson frequency Distribution pattern
5. (04:35) POISSON.DIST function
6. (08:22) Plot a Poisson Distribution on an Excel Column Chart
7. (09:31) Examples of when you can use Poisson Distribution, kike Waiting and stretches of road
8. (11:02) Poisson Math Formula
9. (11:20) The number e
10. (11:40) EXP worksheet function to calculate the number e
11. (12:20) POISSON.DIST function for the Dick’s Hamburgers restaurant
12. (13:06) How to calculate Poisson probabilities between two x values with two POISSON.DIST functions
13. (13:06) POISSON.DIST function using the cumulative distribution function option in the cumulative argument of the POISSON.DIST function
14. (16:10) Calculating probabilities for a half of a minute when the average is given for a one minute period
15. (17:12) POISSON.DIST function for an Accounting Tutoring Center example
16. (18:10) POISSON.DIST function for a 100 mile stretch of pipe in Richmond, CA
17. (20:59) Summary of video
18. (21:40) Closing and Video Links