Re: Random result grapher spreadsheet
[ QUOTE ]
Forgive me, as I know I'm being a nit here, but what's accounting for the variance when recalcing each time? I somehow get that the sheet is calculating different scenarios even if you play it the same way but can anyone go into it a bit more? The simulated results must be changing the finish distributions, right?
Thanks.
[/ QUOTE ]
A randomizer accounts for the variance (based on entered ROI and finish distribution). For each tournament in each simulation the randomizer is called.
Of course, the more simulations are performed the better the simulated ROI fits the actual ROI. The main purpose of this program is to provide graphical insight into the varianced based on your own parameters.
|