https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm JADELottery's Blog: Random Normal Distribution - The Second Approximation en-us Lottery Post RSS Generator https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72511 https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72511 Thu, 29 Dec 2011 14:34:36 GMT JADELottery note: if you remove the second half addition, you only need one random number.

]]> JADELottery https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72510 https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72510 Thu, 29 Dec 2011 14:21:39 GMT JADELottery <br />If you need something for standard deviations less than 1, remove the second half of the addition:<br /><br />+2*PI()*IF(C1>=0.5,1,-1)*SIN(4*ATAN(SINH(B1/2)))*EXP(-1*((B1^2)+(PI()^2))/PI())<br /><br />Removing the second half of the addition will also work for any range of standard deviation, zero to infinity.

]]> JADELottery https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72508 https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72508 Thu, 29 Dec 2011 13:59:38 GMT JADELottery <br />The Standard Deviation is in Cell A1<br /><br />The two random numbers are in Cells B1 and C1<br />{ to get the random number put this in each --> =rand() }<br /><br />The randomly selected number can be put in Cell D1 by copying the following:<br />=(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

]]> JADELottery https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72502 https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72502 Thu, 29 Dec 2011 12:14:52 GMT JADELottery Thanks. It's just maths, plusesuseses and minusesusesses.

]]> JADELottery https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72500 https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm#c72500 Thu, 29 Dec 2011 04:11:37 GMT paradisenow wow great job ... now I really wish I did not suck at math...

]]> paradisenow https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm https://blogs.lotterypost.com/jadelottery/2011/12/the-second-approximation2.htm Thu, 29 Dec 2011 01:01:25 GMT JADELottery

]]> Blog Entry JADELottery https://www.lotterypost.com/blogentry/61849