Hi, I just switched from SNGs to Cash(at least for some time^^), and I would like to know what kind of statistics I need to do in order to know whether I'm winning or not, and if possible, how much.
I played only 2500 hands so far(NL4- is it called NL4 at 0.02/0.04 Blinds?), or rather, watched 2500 hands, and I'm up by a few $. I'm playing at Cake and Elephant doesn't like the hand historys, so I want to do the whole stuff with excel.
Since now I only wrote down the amount of money I gained /lost and the number of hands I've seen in one session(playing 4 tables). So I could do a graph with hand nr vs bankroll, but each session would be one value only, no matter how long the session or how many tables played. Though the values would be weighted by distance on the x-axis. I got:
bankroll hands
160,51 500
160,35 823
153,93 1024
153,91 1162
156,98 1418
151,5 1707
153,56 2027
166,51 2427
(seems like I'm improving:D In the last one I 6-tabled and I liked it better)
My graph would consist of only 8 values yet. Over a large sample size I should get a linear digression with y = mx+n with n being my initial bankroll and m my ROI. Is it correct so far? can I use R² to show correlation? or how can I find out how much Variance affects my graph? Do I need to get different variables? I mean, apart from hands/h, I'll just get a few samples later and average over them to have a rough idea...