How Should One Determine Which RNGs to Employ in a Spreadsheet

question 58

Multiple Choice

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.

---

Definitions:

Connected Knowing

An approach to knowledge and learning emphasizing the relevance of context and personal experience.

Field Dependence

A cognitive style that refers to an individual's tendency to perceive and rely on the visual field as a whole for information processing, as opposed to focusing on details independently from the background.

Effect Size

Effect size is a quantitative measure of the strength of a phenomenon or the magnitude of a difference between groups in an experiment, often used in statistical analysis.

Statistical Significance

Indicates the likelihood that an observed effect or relationship exists because of chance within a predefined level of confidence, typically through a p-value.