How to make a cumulative distribution function of the log-normal distribution on excel?

358 Views Asked by At

I would like to program or make on my own a cumulative distribution function of the log-normal distribution on a computer. How to do it ? is it possible on excel ?

1

There are 1 best solutions below

0
On BEST ANSWER

Use the formula =NORM.DIST((LOG(X)-MEAN)/VAR,0,1,TRUE), replacing X, MEAN and VAR with the appropriate values or cell references.