How should one determine which RNGs to employ in a spreadsheet simulation model?
A) Use the Analytic Solver Platform gallery and pick a distribution.
B) Generate thousands of samples and compare the resulting histogram to ensure the distribution is correct.
C) Solve the deterministic model repeatedly and use Analytic Solver Platform distribution fitting tools.
D) The distributions selected should represent the underlying pool of values expected to occur.

Question

Quizplus · Accepted Answer

The best choice is to select RNGs that represent the underlying pool of values expected to occur. This requires understanding of the nature of the data and selecting the appropriate distribution accordingly. Option A may not always have the ideal distribution available for the data. Option B may not be practical in terms of time and resources, and may not guarantee the best distribution. Option C is not ideal as the deterministic model may not accurately represent the stochastic nature of the data.

How Should One Determine Which RNGs to Employ in a Spreadsheet