Excel Statistical Analysis 35: Exponential Probability Distribution & EXPON.DIST function

preview_player
Показать описание
Learn about calculating probabilities from the Exponential Probability Distribution and the EXPON.DIST function.
Topics:
1. (00:00) Introduction
2. (00:26) Notes about Exponential Probability Distribution
3. (03:17) Dick’s Hamburgers example with math formula and EXPON.DIST function
4. (07:15) Disneyland Ride wait time example with math formula and EXPON.DIST function
5. (11:06) Summary of video
6. (11:25) Closing and Video Links
Рекомендации по теме
Комментарии
Автор

Boom!Really Great Class To Finish This Section, Looking Forward To The Central Limit Therom Classes...Thank You Mike :)

darrylmorgan
Автор

Great video as usual. At 5:24 you mean 10 seconds. Thanks for your explanation at the beginning. It helps a lot.

clalgbarros
Автор

Loving this series Mike! Great video, thanks!

chrism
Автор

You should do something for Pareto and Price's law. They go hand in hand, and used for anything from gold medalist gymnasts to productivity.

hhattingh
Автор

Did you think about K- means classification in excel ?

vacilando
Автор

Hello Mike Iv'e got a issue Iv'e been trying to solve for a week now, hope you can help.
I have a table which looks like this
Date Reading E Day Kw/h Price
28/03/2018 45890 12.24
28/03/2019 51725 12.24
28/05/2019 52698 13.55
21/11/2019 55022 13.55
28/03/2020 57612 13.55

How would I take the SUM of the differences between each Meter reading based on two Dates in a drop down list.
For example say I have *From Drop Down List as 28/03/2018 & To Drop Down List as 21/11/2019*
That should give me the 4 records which lie between these 2 dates, but also the SUM of the difference between each of them.
So in this case it needs to give a value of 4484. Each of these difference then need to be multiplied by the corresponding Kwh Rate.

Is this possible to do? Hope you can help
Thanks in advance.

qasmb