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

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.

Related content

RANDGAUSSIAN
RANDGAUSSIAN
More like this
RANDGAUSSIAN
RANDGAUSSIAN
More like this
RANDBETWEEN
RANDBETWEEN
More like this
RANDBETWEEN
RANDBETWEEN
More like this
NORMDIST
More like this
NORMDIST
More like this