PDA

View Full Version : Standard deviation for monthly data



Rog3rus
06-16-2011, 07:12 AM
Is there a way to get the standard deviation per hand per player for monthly data? I know the basics of accessing SQL queries, and I know that the stdev can be found per player (via stdev(ph.Netamountwon)).

Is it possible to also access this in monthly data? Maybe through a 'trick' using compiledplayerresults_month.totalbets and cpr_m.totalcalls?

Rog3rus
06-24-2011, 09:37 AM
Found one way to do so just stddev(totalamountwon).

This does not, however, give the standarddeviation per hand. It appears the "totalamountwon" is divided into a few subsamples - usually around 10, maybe one for each session? Does anyone know how compiledplayerresults acutally compiles???