Given that each data point is in exactly one subset, then you could rely on the expansion of the variance equation to calculate sum of X2 from each subset's variance (given the subset mean). Then take the grand sum of the X2 over all subsets and use the total N and weighted mean to calculate the full sample variance. More on reddit.com

you dont plug in your winrate after 1600 hands into a variance calculator- you learn nothing from this What u should be doing is play around with different winrates and see what the expected downswings can look like so you can prepare urself More on reddit.com

u/MoneyInc - please read this comment in its entirety. Read the rules -- particularly 1 and 2 Include your Excel version and all other relevant information Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com

Find the summation of f(y)*y More on reddit.com