Comments

GASMETERGUY - Dec 29, 2011, 2:06 pm

#1

You must be on to something. Under a normal distribution curve, most of the sample would fall in the center of the curve. I see that you have samples that fall at either end of the curve. This skewness is important. May I ask how you derive your samples?

JADELottery - Dec 29, 2011, 2:16 pm

#2

the equation (excel function) is displayed in the top graph.

it's from the previous blog post - Random Normal Distribution - The Second Approximation.

it is similar to the Normal Distribution, hence the word, Approximation.

JADELottery - Dec 29, 2011, 2:23 pm

#3

the Normal Distribution curve is based on a Standard Deviation of 20 and a Sample count of 1500; which comes from the top graph as well.

the equation for the curve is =1500*(1/(20*SQRT(2*PI())))*EXP(-1*("x-axis-value"^2)/(2*20^2))

the "x-axis-value" is replaced by whatever cell has the x-axis numbers.

Post a Comment

Please Log In

To use this feature you must be logged into your Lottery Post account.

Log In

Not a member yet?

If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.

Register