Re: Normally Distributed Random Number Generator from Excel
- From: rossum <rossum48@xxxxxxxxxxxx>
- Date: Fri, 28 Mar 2008 09:42:38 +0000
On Thu, 27 Mar 2008 21:06:52 -0700 (PDT), "2.7182818284590..."
<tangent1.57@xxxxxxxxx> wrote:
How do I create a normally distributed number with mean = 10, standardKnuth, Vol 2, Section 3.4.1, Algorithms M or F.
deviation =3, and the tools that I have are:
1. =RANDBETWEEN(X, Y) - returns a uniformally-distributed number
between X to Y
2. =NORMINV(Number; Mean; STDEV)
Number represents the probability value used to determine the inverse
normal distribution.
Mean represents the mean value in the normal distribution.
STDEV represents the standard deviation of the normal distribution.
For example: =NORMDIST(70; 63; 5; 0) returns 0.03.
I would think it would be :=NORMINV(RANDBETWEEN(-2,2), 10, 3)
NOTE: This is only for my interests. I'm not a student!
My goal is to create a process-simulator using MS Excel.
As Ray says, you need to test the RNG in your version of Excel to see
if it is good enough for your purposes.
rossum
.
- References:
- Normally Distributed Random Number Generator from Excel
- From: 2.7182818284590...
- Normally Distributed Random Number Generator from Excel
- Prev by Date: NEW CRANK!
- Next by Date: Re: Reversible "hash" or permutation function?
- Previous by thread: Re: Normally Distributed Random Number Generator from Excel
- Next by thread: Re: Normally Distributed Random Number Generator from Excel
- Index(es):
Relevant Pages
|
