|
#1
|
|||
|
|||
Re: 8 SNG set probabilities
It sounds like you are doing these things in Excel so I am not sure if Excel supports anything more precise than double-precision floating point.
If you were doing it in Java, you could use a solution called BigDecimal. Note: I am a Java programmer and if you could show me the calculations, I could very likely write a program to do it as well. Java even has packages that would allow you to produce the graphs as well. There are other solutions too. Depending on how good of a programmer you are, you can always do bit manipulation to use two double-preicision floating point numbers to act as one or a similar idea. Hopefully this will be helpful, Will |
#2
|
|||
|
|||
Re: 8 SNG set probabilities
Hi Will,
Thanks for the info. I used Visual Basic for this, and then exported the won/lost and probability data into Excel for graphing. VB is the the only language that I know anything about, and I am definitely not a strong programmer. If you would like to see the code then just send me a PM and I will forward it to you. It is only about 100 lines of code so you would abe able to get it working in Java in no time I am sure. It the end, it looks like the results for SNG sets higher than about 50 games smooth out to look normally distributed anyways. So there may not be any need to go higher. If you know of a variable type with a higher range in VB, then please let me know and I will change the code. Basically, it would need the capacity to store a number about 10^2500 to get to 1000 games. Dave S |
|
|