I am searching for a free Excel addon or Excel sheet which allows the conversion of normal distributed datsa into lognormal distributed data.
If data are lognormal distributed, then the log-transformed data are normally distributed.
If data xi are normal distributed, then the transformed data exp(xi) are lognormal distributed.
You do not need an add-on, just transform by the exponential function.
If data are lognormal distributed, then the log-transformed data are normally distributed.
If data xi are normal distributed, then the transformed data exp(xi) are lognormal distributed.
You do not need an add-on, just transform by the exponential function.
Dear Christian,
You can use Johnson's system of distributions (Johnson's translation system) of SL family for the conversion of normal distributed data with zero mean and unit variance into lognormal distributed data. See, for example, the link:
http://onlinelibrary.wiley.com/doi/10.1002/0471667196.ess1309/abstract?systemMessage=Wiley+Online+Library+will+be+unavailable+on+Saturday+17th+December+2016+at+09%3A00+GMT%2F+04%3A00+EST%2F+17%3A00+SGT+for+4hrs+due+to+essential+maintenance.Apologies+for+the+inconvenience
- Badges
- Science topic