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.