Channel: ExcelIsFun

Category: Education

Tags: business statistical analysisplot poisson distribution excel column chartpipes over stretch in roaddata analysisesa 28highline collegeexcel statisticsmike girvindick’s hamburgers restaurantpoisson.dist functionmicrosoft 365 excelpoisson distribution characteristics and requirementsbusn 210mike excelisfun girvinstatistical analysischapter 5line waitingexcelisfunexcel statistical analysiscumulative distribution function option

Description: Download Excel File: excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: 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