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.