Hello, I'm currently updating a distribution fitting template used in simulation based on historical data. I found the formula for Gumbel distribution from this thread, which is Location - Scale * LN(-LN(RAND())), for generating x https://www.mrexcel.com/forum/excel-questions/613545-stochastic-modeling-left-skewed-extreme-value-distribution.html?highlight=gumbel+min However, I'm looking for a substitute for the Rand() function as this would always generate data every after calculation and will always change the distribution fitting. Any help will be appreciated. Thanks!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

[Excel] Need help in generating formula for Distribution Fitting(Gumbel)

Thread starter tumble25
Start date Aug 2, 2018
Tags

data distribution fitting formula gumbel

tumble25

New Member

Aug 2, 2018

Hello, I'm currently updating a distribution fitting template used in simulation based on historical data.

I found the formula for Gumbel distribution from this thread, which is Location - Scale * LN(-LN(RAND())), for generating x

https://www.mrexcel.com/forum/excel...-value-distribution.html?highlight=gumbel+min

However, I'm looking for a substitute for the Rand() function as this would always generate data every after calculation and will always change the distribution fitting.

Any help will be appreciated. Thanks!