1) My random number generator generates the same output sequence for the same seed.
2) My random number generator is not recalculated if somewhere else on the spreadsheet an (unlinked) cell is recalculated.

Quote from: mman on June 27, 2014, 09:20:58 AM

Quote from: 375CT on June 27, 2014, 08:36:48 AM
Makes sense, but how to be sure? I get and agree to the point you made, but making no sense, well, that's the hard part out of this, because we are not dealing with any way to test the actual implementation.

Litz speaks about standard deviations when he mentions distribution factors. This alone tells us that probability distribution can't be flat. Another proof is that litz's tool gives approx. same results as mine. And mine is based on normal distributions.

Quote from: 375CT on June 27, 2014, 08:36:48 AM
I understand you are recomending going CEP for a more realistic simulation, am I right on my assumption?

No, I'm only recommending CEP for group size measuring. For wez tool you can use monte carlo or CEP depending which properties you value. I decided to go with CEP because for me it was more important to compare different calibers, bullets and conditions than get absolutely accurate results in hitting probability. Problem with monte carlo is that you get slightly different results for every calculation. That's not desirable if you try to compare something.

In practise you can never accurately calculate hitting probability anyway. That's simply because you don't know exact standard daviations for distribution factors. WEZ tool is always at it's best for comparing not for absolute probabilities.

Mman, thanks for the tips, they are much appreciated for sure.

Quote from: 375CT on June 27, 2014, 08:36:48 AM
Makes sense, but how to be sure? I get and agree to the point you made, but making no sense, well, that's the hard part out of this, because we are not dealing with any way to test the actual implementation.

Litz speaks about standard deviations when he mentions distribution factors. This alone tells us that probability distribution can't be flat. Another proof is that litz's tool gives approx. same results as mine. And mine is based on normal distributions.

Quote from: 375CT on June 27, 2014, 08:36:48 AM
I understand you are recomending going CEP for a more realistic simulation, am I right on my assumption?

No, I'm only recommending CEP for group size measuring. For wez tool you can use monte carlo or CEP depending which properties you value. I decided to go with CEP because for me it was more important to compare different calibers, bullets and conditions than get absolutely accurate results in hitting probability. Problem with monte carlo is that you get slightly different results for every calculation. That's not desirable if you try to compare something.

In practise you can never accurately calculate hitting probability anyway. That's simply because you don't know exact standard daviations for distribution factors. WEZ tool is always at it's best for comparing not for absolute probabilities.

Quote from: mman on June 27, 2014, 06:20:11 AM

Quote from: 375CT on June 26, 2014, 11:44:10 PM
Well, so far the original questions remains, is Litz's WEZ (a term taken from Air Combat for budget error analysis) flat or not?

That's easy one. It must be normal distribution. No sense to use flat distribution, that would lead to strange results.

Makes sense, but how to be sure? I get and agree to the point you made, but making no sense, well, that's the hard part out of this, because we are not dealing with any way to test the actual implementation.

http://ballistipedia.com/index.php?title=Main_Page

Useful link for further discussion.

I understand you are recomending going CEP for a more realistic simulation, am I right on my assumption?

Quote from: 375CT on June 26, 2014, 11:44:10 PM
Well, so far the original questions remains, is Litz's WEZ (a term taken from Air Combat for budget error analysis) flat or not?

That's easy one. It must be normal distribution. No sense to use flat distribution, that would lead to strange results.

Confirmed here

http://msdn.microsoft.com/en-us/library/2dx6wyd4(v=vs.110).aspx

Random in VB.net yields an uniform distribution...now, I need to figure out how bad this could be for creating something akin a WEZ run.

Anyway, like Robert pointed out, a RNG can be easily programmed if such need ever arises with for instance the Ziggurat algorithm.

Mman, thanks for the links, they just confirmed my suspicions on this too.

Now will also review CEP. Well, so far the original questions remains, is Litz's WEZ (a term taken from Air Combat for budget error analysis) flat or not?

http://office.microsoft.com/en-gb/excel-help/rand-function-HP010342816.aspx
This is flat. You can convert it into gaussian if you want.

There is discussion about it:
http://elsmar.com/Forums/showthread.php?t=22358

There seems to be an agreement what robert said about it. It would be interesting to hear why and how bad rand() actually is.

Quote from: admin on June 25, 2014, 01:47:55 PM
In visual basic and as an Excel function I have published random number generators, two of them generate numbers with a constant probability ("flat").
The other one. =bfx_rang(....) generates numbers according to a gaussian distribution.
The properties of Excels random generators did not suit my purpose.

The "flat" distribution is the basis for generating numbers distributed according to another distribution.
For gaussian distributions efficient algorithms can be googled.

Nevertheless, the more random variables involved in a simulation, the less details of a certain random variable matter.

Understood the last part, but it's not clear why RANDOM in VB is not good enough. I got the point on Gaussian but I read somewhere that random() is indeed gaussian, so more confussion for me at least

What's wrong with excel's RAND ( ) ? My monte carlo is based on that and I got same averages as some references I used...

In visual basic and as an Excel function I have published random number generators, two of them generate numbers with a constant probability ("flat").
The other one. =bfx_rang(....) generates numbers according to a gaussian distribution.
The properties of Excels random generators did not suit my purpose.

The "flat" distribution is the basis for generating numbers distributed according to another distribution.
For gaussian distributions efficient algorithms can be googled.

Nevertheless, the more random variables involved in a simulation, the less details of a certain random variable matter.