Thanks Mike!!! Honestly....I am not much into Financing, so I need to watch this video many times, BUT I still enjoyed your explanation even though I only understood 0.15 of it all after my first watch!!! Thanks Mike for all the material you provide here!!!
Twice Better then perfect tutorial:) Good hot spicy meal and very good very expensive beer bottle and I can start to learn new stuff while resting from almost 16h day work time 4 days :) Thank you Mike :)
@@excelisfun well, i do have hard month before me, if you only knew what i had to deal with in my new team. 1 data set linked into at least 15 files by basic link option. Cross tab report used as data range for comparison. not to mention overcomplicated addition using 2 or 3 or 4 vlookups to check if all data in the 2 systems do correspond with each other. and thats only 1 % of the things i saw. I will try my best to clear it out. preferebly by CTRL+A Delete. Redesigne the process from scratch. but wow such mess... if excel hell would exist thats not even 10% of it.
Thanks Mike for all of these examples. After seeing your video a question popped up: why on earth do you need to know the SD for an binomial distribution? you can calculate directly for example P(X < value) ?
In the Textbook on the calculation of water supply systems, it is written: the number of simultaneously operating water sampling devices "m" can be determined using the Erlang formula, Poisson formulas and binomial distribution or formulas approximating them for a given security P and probability "P". In Russia, the volumetric consumption of cold and hot water in an apartment building is calculated this way: the number of apartments, sanitary appliances, the approximate number of residents is known; the probability of using a sanitary appliance (washbasin, van, toilet, etc.) for an hour, a second is calculated; water consumption and pipe diameters are calculated. The probability of use is calculated either by the binomial distribution formula or by the Poisson formula.
Russian textbooks and regulatory documents do not give an example of using the Erlang formula, nor the binomial distribution, nor the Poisson formula, but instead give a table of values with a certain step of probabilities and the number of water sampling points, and intermediate values are obtained by approximation. There should be calculation formulas in the standards, but they are hidden and not given, you have to invent yourself.