next up previous contents index
Next: HEXTONUM Up: A. Function Reference Previous: GMEAN, GEOMEAN   Contents   Index


GRAND

Syntax: GRAND()

GRAND returns a 12th-degree binomial approximation to a Gaussian random number. A set of these numbers will approximate a normal (bell-shaped) distribution with a mean of 0 and a variance of 1. The number will change with every recalculation.

Examples:

GRAND() = 1.2255531

GRAND() = 1.5264478

GRAND() = -0.98732934

Excel function: N/A


next up previous contents index
Next: HEXTONUM Up: A. Function Reference Previous: GMEAN, GEOMEAN   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003