RiskCollect
|
Description
|
RiskCollect() identifies specific distribution functions whose samples are collected during a simulation and whose:
When RiskCollect is used and Inputs Marked With Collect is selected for Collect Distribution Samples in the Simulation Settings dialog, only functions identified by RiskCollect are displayed in the Results Summary window. Earlier versions of @RISK had the RiskCollect function entered by placing it in the cell formula, immediately preceding the distribution function for which samples will be collected, e.g.: =RiskCollect()+RiskNormal(10,10) RiskCollect is typically used when a large number of distribution functions are present in a simulated worksheet, but sensitivities and scenario analyses are desired on only a pre-identified subset of important distributions. It can also be used to bypass Windows memory constraints that might prevent sensitivity analysis on all inputs in a large simulation model.
|
|
Examples
|
RiskNormal(10,2,RiskCollect()) collects samples from the probability distribution RiskNormal(10,2).
|
|
Guidelines |
The Inputs Marked With Collect option in the Simulation Settings dialog must be checked for RiskCollect functions to take effect. |