How to create a random number following a lognormal distribution in excel?
Lognormal is e^N(m,s). So the answer, using your construct for normal, would be
=EXP( NORMINV(RAND(),Mean,Stdev) )However that will give you very large values. Next step is to scale the mean and standard deviation. In pseudocode,
scaled mean = ln( m^2 / sqrt( m^2 + s^2 ))scaled sd = sqrt( ln(( m^2 + s^2 ) / m^2 ))