 |
Download a pdf copy of this help file here |
|
Download a pdf copy of this help file here |
See also: Accident insurance, VoseAggregateMC
VoseExpression(FormatString,Distribution1,Distribution2,...)
Allows you to create complex frequency and severity distributions for use as argument in the VoseAggregateMC function.
Formatstring - a string expression (between "") with #1,#2,... where #n refers to the nth DistributionN argument.
DistributionN - a distribution object
Insurance policies are becoming ever more flexible in their terms, and more complex to model as a result.
For example, we might have a policy with a deductible of 5, and a limit of 20 beyond which the insurer pays only half the damages. Using a cost distribution of Lognormal(31,23) and an accident frequency distribution of Delaporte(3,5,40) we can model this as follows:
A1: =VoseLognormalObject(31,23)
A2: =VoseExpression("IF(#1>20,(#1-25)/2,IF(#1<5,0,#1))",A1)
A3 (output): =VoseAggregateMC(VoseDelaporte(3,5,40),A2)
The VoseExpression function allows one a great deal of flexibility. The '#1' refers to the distribution linked to Cell A1. Each time the VoseExpression function is called it will generate a new value from the Lognormal distribution and perform the calculation replacing '#1' with the generated value. The Delaporte function will generate a value (call it n) from this distribution, and the AggregateMC function will then call the VoseExpression function n times, adding as it goes along and returning the sum into the spreadsheet.
The VoseExpression allows several random variables to take part in the calculation. For example:
=VoseExpression("#1*#2",VoseBernoulliObject(0.3),VoseLognormalObject(20,7))
will model a cost that follows a Lognormal(20,7) distribution with 30% probability and zero with 70% probability;
=VoseExpression("#1*(#2+#3)",VoseBernoulliObject(0.3),VoseLognormalObject(20,7),VoseParetoObject(4,7))
will model a cost that follows a (Lognormal(20,7)+ VosePareto(4,7)) distribution with 30% probability and zero with 70% probability.
Example model