How should one determine which RNGs (Random Number Generators) to employ in a spreadsheet simulation model? Use
Fantastic news! We've Found the answer you've been seeking!
Question:
How should one determine which RNGs (Random Number Generators) to employ in a spreadsheet simulation model?
Use the Analytic Solver Platform gallery and pick a distribution. | ||
Generate thousands of samples and compare the resulting histogram to ensure the distribution is correct. | ||
Solve the deterministic model repeatedly and use Analytic Solver Platform distribution fitting tools. | ||
The distributions selected should represent the underlying pool of values expected to occur. |
Related Book For
Quantitative Methods for Business
ISBN: 978-0840062345
12th edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam
Posted Date: