RiskVary

Description

RiskVary(base, minimum, maximum, range type, #steps, distribution)specifies a distribution with a range defined by minimum and maximum. If desired, arguments for range type, #steps, and distribution can be entered. If not entered, the default range type, steps and distribution are used. The base value is the value returned by the function when a simulation is not underway. Typically, this is the value that was used in the spreadsheet prior to entering the Vary function.

Examples

RiskVary(100,-10,10,0,8,”Triang”) specifies a distribution with base value 100, a -10% to +10% range, a percentage range type, 8 steps, and a triangular distribution across the min-max range.

RiskVary(100,A1,B1) specifies a distribution with a range from the value in cell A1 to the value in cell B1, around the base value 100. The default range type, #Steps, and distribution are used.

Guidelines

maximum must be greater than base.

base must be greater than minimum

Range Type = 0 indicates a -/+ percentage change from base case is defined by minimum and maximum (e.g., -20% and +20%).  Each percentage should be entered as an absolute percentage value (such as -20 instead of -0.2).

Range Type = 1 indicates a -/+ actual change is defined by minimum and maximum (e.g., -150 and +150).

Range Type = 2 indicates that minimum and maximum are the actual minimum and maximum values in the range.

#Steps must be a positive integer.  This argument is used only when conducting a what-if analysis with TopRank.

distribution must be “Normal”, “Triang”, “Trigen”, “Uniform”, or “Pert”, with the distribution name surrounded by quotes.

The defaults are: Range Type is -/+ percentage change, #Steps =5, and distribution = Triang