RANDGAUSSIAN

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

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()

AB
1-0.016375461
2-0.474685504
31.2762378257
41.3304408702
5-0.172384979
61.5170906593
70.8719007714
....1000

...


Histogram of results from Flip Side sheet.