Excel 2013 Statistical Analysis #34: POSSION Distribution and POISSON.DIST Function
HTML-код
- Опубликовано: 21 авг 2024
- Download files (which file shown at begin of video): people.highlin...
Topics in this video:
1. (00:24) Look at Data Set that exhibits the characteristics of a Poisson Experiment and compare it to the results of the POISSON.DIST to helps us understand why when can use this function to make probability predictions.
2. (05:57) Chart a POISSON Distribution with a column chart
3. (09:16) Discussion of POISSON experiment and POISSON.DIST Discrete Probability Distribution
4. (12:23) Use POISSON.DIST for arrivals at Dick’s Hamburger Restaurant
5. (17:14) Use POISSON.DIST for arrivals at an Accounting Tutoring Center
6. (18:20) Use POISSON.DIST for water line breaks in a 100 Mile stretch of pipe
Excel 2013 Statistical Analysis #34: POSSION Distribution and POISSON.DIST Function
Download files: people.highline.edu/mgirvin/excelisfun.htm
POSSION Discrete Probability Distribution and POISSON.DIST Function:
1. (00:24) Look at Data Set that exhibits the characteristics of a Poisson Experiment and compare it to the results of the POISSON.DIST to helps us understand why when can use this function to make probability predictions.
2. (05:57) Chart a POISSON Distribution with a column chart
3. (09:16) Discussion of POISSON experiment and POISSON.DIST Discrete Probability Distribution
4. (12:23) Use POISSON.DIST for arrivals at Dick’s Hamburger Restaurant
5. (17:14) Use POISSON.DIST for arrivals at an Accounting Tutoring Center
6. (18:20) Use POISSON.DIST for water line breaks in a 100 Mile stretch of pipe
For the downloadable workbook use: people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch05/Ch05.htm
TY!!
Very Informative Thank you.
Glad you like it!
Thanks!
Mr. Excellsfun you have some excellent tutorials, that are very informative. My question is in regards to using Excell 2010, this is the issue:I have a work book called Invoice Log which list (date recd, date submitted, vendor, acct code, due date, amount, check #, date paid). I create a tab for each time I submit invoices for payment (every two weeks). I would like to populate a form using the data from the invoice log to create a Expense approval voucher for each vendor paid that week. The expense approval voucher is in a separate workbook and is attached to each vendor invoice paid for that week. Can you direct me to one or some of your tutorials that can assist me in this effort or make a suggestion on how to accomplish this task. I have looked at a number of tutorials and not sure what to use, i.e. data validation, indirect, lookup, etc. Thanks for any assistance you can provide.
Can I use poisson distribution to estimate number of goals ih football game if I know average ? because from your definition it doesn't seem so ....
Let's say I have 14 airplane crashes in year 2015. It's a Poisson distribution. How many crashes are expected in the year 2016 and 2017? (variance=299,582222). How do I solve this problem? Is it with binomial -> mu=n . p?
Please help I am trying to solve this for the past 2 hours :(
Thanks!
You are welcome!