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
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. |
Step by Step Solution
There are 3 Steps involved in it
The detailed answer for the above question is provided below When determining which RNGs Random Number Generators to employ in a spreadsheet simulatio... View full answer
Get step-by-step solutions from verified subject matter experts
