Excel Random Number generation for Lognormal distribution

John Veenstra · Sep 10, 2003

Woould like to know how to have Excel generate random
numbers conforming to lognormal distribution

GB · Sep 10, 2003

To make that completely clear use

=exp(normsinv(Rand()))

Geoff

WorksheetFunction Class - Random values from LogInv needed	0	Feb 2, 2006
Generating random lognormally distributed numbers	1	Jul 5, 2007
size distribution curves	0	Mar 16, 2006
Random Password Generation	0	Jan 20, 2015
Generating random lognormal distribution	3	Sep 29, 2006
Keyboard Mistyping - as if a computer virus - only happens in Outlook (www.portal.office.com)	0	Mar 9, 2022
Lognormal in VBA	1	Jun 11, 2007
Lognormal in VBA	1	Jun 11, 2007

Ask a Question