To learn more about EpiX Analytics' work, please visit our modeling applications, white papers, and training schedule.
Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: capitalized @RISK

...

A list of all the public @RISK functions, which are grouped into three types:

Anchor
Distribution functions
Distribution functions
Distribution functions

Functions that generate random values from probability distributions.

...

Expand
titleRiskWeibull

 Returns values from a Weibull distribution.



Anchor
Property functions
Property functions
Property functions

Functions that modify the way that @RISK generates and treats values from its distribution functions. These functions can often be strung together when set within a distributions parameters, for (a rather silly) example:

...

Expand
titleRiskTruncate

Risktruncate(Min,Max) truncates a distribution to lie between the specified Min and Max values. It must obviously increase the probability of the remaining values to compensate. For example:


LaTeX Math Block
=RiskNormal(100,10,RiskTruncate(90,110))

truncates a Normal(100,10) distribution to lie between 90 and 110:


Anchor
Statistics functions
Statistics functions
Statistics functions

Functions that report the simulation results within Excel cells. These functions are very useful, in combination with on-screen recalculation, to monitor some aspect of the simulation. They are also useful for automatically producing reports in Excel, though this can slow down you models.

...