MR_button_Aggregate_Multi_FFT.bmp Aggregate Multivariate FFT

MR_dice_icon.jpg Download a complete copy of this risk analysis resource for free here.

See also: ModelRisk functions and windows, Aggregate modeling in ModelRisk, Aggregate distributions introduction,  Common elements of ModelRisk windows

image1091.gif

 

 

Introduction

MR_window_Aggregate_Multi_FFT_1.jpg
The Aggregate Multivariate FFT window
from ModelRisk

The Aggregate Multivariate FFT window is a lot like the Aggregate FFT window, in that it calculates the sum of a random number of randomly sized distributions.

However, in the Aggregate Multivariate FFT window you can enter multiple pairs of severity/frequency distributions to be added.

So, for example, you could model a portfolio of two related insurance policies (e.g. one for car accidents and one for trucks) aggregating a Poisson number of Lognormal-sized variables together with a Polya number of Normal-sized variables.

A continuous distribution (e.g. a Gamma) can be fitted to the aggregate distribution (by matching moments), and this fitted distribution can in turn be inserted in the spreadsheet (see below).

The FFT method is explained in more mathematical detail here.

To see the output functions of this window, click here.

Window elements

MR_window_Aggregate_Multi_MC_2.jpgOn the upper left of the window is the list of Frequency/Severity distribution pairs. These should be discrete, respectively continuous Vose Distribution Objects.

To add a new distribution to the list, click anywhere in the white area. To remove a frequency/severity distribution pair from the list, select it (by clicking on it) and then click the x button on the right below the list.

Preview graphs for the frequency, severity and resulting aggregate distribution are shown.

image534.gif

Different types of output can be specified by selecting the appropriate option under the preview graph:

The preview graph of the aggregate distribution below has the following special buttons in its graphics toolbar:

 MR_window_Aggregate_MC_3.jpg

From left to right, these allow you to:

Using aggregate moments to check for accuracy

Whilst the aggregate calculation techniques offered by ModelRisk are generally very accurate, it is wise for the user to ensure that the numerical result is within the level of accuracy required.

The most direct way of testing the required accuracy is to compare the moments of the constructed aggregate distribution to the exact values that can be determined through manipulation of the frequency and claim size distributions.

That is why we have included the exact aggregate moment values for comparison in the ModelRisk aggregate De Pril, Panjer and FFT windows, in the exact column of the summary statistics table:

image621.gif

For explanations about other fields, buttons, graphs and summary statistics tables in this window, see Common elements of ModelRisk windows.

Useful tips and tricks

See also: Graphics, workflow and error handling in ModelRisk

Using View Function to return to a window

The output of ModelRisk windows always corresponds to VoseFunctions (the functions ModelRisk adds to Excel) being entered into one or more spreadsheet cells.

You can always re-open the window for a ModelRisk function that is in a spreadsheet cell by using View Function. Select the spreadsheet cell and then select View Function from the ModelRisk menu/toolbar/ribbon.