- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 11:24 pm
You last visited
May 1, 2024, 10:11 pm
All times shown are
Eastern Time (GMT-5:00)
Random Normal Distribution - The Second Approximation
Published:
Updated:
Comments
The Standard Deviation is in Cell A1
The two random numbers are in Cells B1 and C1
{ to get the random number put this in each --> =rand() }
The randomly selected number can be put in Cell D1 by copying the following:
=(2/PI())*A1*LN(TAN((PI()/2)*B1))+2*PI()*IF(C1>=0.5,1,-1)*SIN(4*ATAN(SINH(B1/2)))*EXP(-1*((B1^2)+(PI()^2))/PI())
If you need something for standard deviations less than 1, remove the second half of the addition:
+2*PI()*IF(C1>=0.5,1,-1)*SIN(4*ATAN(SINH(B1/2)))*EXP(-1*((B1^2)+(PI()^2))/PI())
Removing the second half of the addition will also work for any range of standard deviation, zero to infinity.
Post a Comment
Please Log In
To use this feature you must be logged into your Lottery Post account.
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