RANDOMNORMAL
generates random values from normal distribution · a deepcalc original · no excel equivalent · no sheets equivalent
signature
RANDOMNORMAL(mean, std_dev, [count])
returns: number · volatile — recomputes on every evaluation
| argument | required |
|---|---|
| mean | required |
| std_dev | required |
| count | optional |
usage
=RANDOMNORMAL(100, 15, 5)
related
- FROMBYTES converts byte array to integer
- GENERATEID generates unique ID with prefix and random suffix
- HASH hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321)
- IMAGE shows an image from a url — the browser loads it, the engine does not fetch
- ISIN checks if value is in a range or comma-separated list
- RANDOMCHOICE random pick from a range (with replacement); count > 1 spills a column