/
RANDGAUSSIAN
RANDGAUSSIAN
Syntax
RANDGAUSSIAN()
Description
This function generates normal distributed random values with mean of 0 and standard deviation of 1.
For each line in the current worksheet, a normally distributed random number is returned based on the Gaussian function.
Example
Column A:
fx=EXPLODE_RANGE(1;10000)
A |
---|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
... 1000 |
Column B:
fx=RANDGAUSSIAN()
A | B |
---|---|
1 | -0.016375461 |
2 | -0.474685504 |
3 | 1.2762378257 |
4 | 1.3304408702 |
5 | -0.172384979 |
6 | 1.5170906593 |
7 | 0.8719007714 |
....1000 | ... |
Histogram of results from Flip Side sheet.
, multiple selections available,
Related content
RANDGAUSSIAN
RANDGAUSSIAN
More like this
RANDGAUSSIAN
RANDGAUSSIAN
More like this
RANDBETWEEN
RANDBETWEEN
More like this
RANDBETWEEN
RANDBETWEEN
More like this
NORMDIST
NORMDIST
More like this
NORMDIST
NORMDIST
More like this