log standard deviation

  • This may be a little off topic, but i have a data series that i am trying to get the log normal standard deviation for. Ive tried using the lognormdist function but am unsure how to derive the standard deviation from there. If anybody has an idea for this please let me know.


    Thanks

  • Create a new column and take the log of each of your data points. Then take the mean and standard deviation of those values. That will give you the parameter estimates needed for a lognormal distribution. Use the LN function, not the LOG function.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!