sagefr0g said:
am i gonna flunk this class? lmao, i should just stick with the B+ :angel::whip:..
Heck no lol.
Aside from the fact I also learn from you and all your questions, I, as a teacher, am not allowed to flunk the "slower" children of America in the current political climate :grin: It makes it appear our billions in education $'s may be wasted lmao.
I'll keep trying as long as you keep trying until one of us understands. And, it may very well be me learning something before it is you.
Type "=NORMSDIST(1)" into a cell in Excel. The result displayed should be "0.84134474."
Type "=NORMSDIST(-1)" into another cell in Excel. The result displayed should be "0.15865526"
Note how the 2 results sum to "1" and the first result less the 2nd resut ="0.68268948", the area under the curve that represents 1SD whether + or - from the mean (think "EV"). What this means is 68.26...% of the time, one's results will fall within 1SD.
It also means, when it says "0.84134474", that 84.13...% of the time one's results will be that good or worse. In effect, it includes all areas to the left of the curve including any results outside -1SD. It's "cumulative" with respect to what's "left" of the curve.
When one uses the "=NORMSDIST" function in Excel it means "my results will be at least this good or better x% of the time" and includes all areas to the left of the curve when the the "x" in "=normsdist(x)" is positive.
When the "x" in "=normsdist(x)" is negative it means, "my results will be at least this bad or worse" x% of the time".
So, type in "=NORMSDIST(-4)" into a cell. The result will be "0.0000316860".
This means both "my results will be at least this bad or worse 0.0031686% of the time" or "my results will be better than this "1- 0.0000316860" (0.999968314) of the time.
It also means the area under a 4SD curve is 0.999936628 and all events will fall outside of this frequency 0.0000633721 of the time, half of that to the right of the curve (0.0000316860) of the time and half (0.0000316860) to the left of a 4SD curve.
As "unlikely" as 4SD is, it's only a 1 in 31560 to do better than that or worse than that and stuff happens. Get to 5SD and it's 1 in 3+MM. Get to 6SD and it's over a billion to 1. Get to 8 and it's 1500 trillion to 1 and you either suck or are being cheated.
If you get some weird scientific notation when you use this, just format the cell to a "number" with 10 decimals or so.
That's the point of measuring one's results, one's "luck" if you will, and how far they may be from expected. One can put a number on how good or bad one's "luck" has been. Well, one can if one has run a sim so one knows one's EV and SD/hd.
Like in Card Counting forum, someone sometimes posts some bad results and everyone says "a little bad luck happens. Don't worry about it, it will come around" even if the results are pretty much unbelievably bad. Likewise, if one posts a big win, it's "expected" even if the win is unbelievably good.
Of course, it must all be in the same game playing the same way, ideally, to have a point to measure the results in the first place.
One shouldn't count those "steaming" $1000 hands when behind and, when won, think "now I'm at EV just like I am supposed to be" lol.
So you were 1 in 31000 "lucky" over those 71100 hands. You could play 71,100 hands 30099 more times and not expect to do better than that. Maybe that's what that means? Assuming of course you were actually playing pretty much the same game pretty much the same way for those 71,100 hands like a Weekend Warrior should lol.
How lucky would you be if it happened you were playing 80 hands an hour instead of 100/hds/hr? Or even crazier 60 hands an hour? Now your results are 1 in a couple hundred thousand "lucky" or 1 in over 5MM "lucky". That's another homework assignment - to verify what I did was OK lol.
Which is why I think one should write down number of rounds played (best guess), even a range of number of hands so later you could develop a high-low estimate, after each "session" rather than only know, much later, how long you may have sat there in hours.
Probably even more important to do this when back-counting when a sim's "hourly" rate assumes you see 100 hds/hr but you only play 13% of them. The good news is, it shouldn't be that hard to know how many physical rounds you may have played in an evening since you have played so few. So don't go back to your room and just write down "3 hours", write down "x number of rounds played" and the 3 hours.
The beauty of this "hands played" way it also allows one to measure one's "luck" over a variety of different games with different pens, decks, spreads, etc if one only knows the EV and SD for each of those games and spreads per round played individually. In effect, a way to measure one's lifetime "luck" over many different games and spreads etc since both EV and variance are additive per round played.
I digress. If you use the "=NORMSDIST(x)" function in Excel the result always includes ALL areas to the "left" of that to infinity.