Hey all,
I've set up a lognormal distribution in Excel, to represent my data, but it is not doing what it should, as its peak is not as high as I know it should be. The following formula I obtained from Wikipedia.

=EXP(-((LN(A5)-$J$5)/$J$6)^2)/A5*$J$5*SQRT(2*PI())

where J5= mean of the raw data &
J6 = standard deviatation

Are there missing parameters that are not accounted for in this formula, and how would I estimate them from my data? I fitted the model to my data in R.

cheers
ajmac