MR_button_extreme_values.bmp Extreme Values Calculation

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

See also: ModelRisk functions and windows, VoseLargest, VoseKthLargest, VoseSmallest, VoseKthSmallest, VoseLargestSet, VoseSmallestSet

image1138.gif

 

 

Introduction

MR_window_Extreme_Values_1.jpg
The Extreme Values Calculation window
from ModelRisk

The Extreme Values Calculation calculates the distribution of the smallest and/or largest sample(s) from a number N of samples drawn from a given distribution.

For distributions of the exponential family (like the Gamma), it is well-known that the extreme values asymptotically follow an Extreme Value Min or Extreme Value Max distribution.

In the case of a general distribution, and for large N this can get extremely complicated to model, though. This is exactly what the Extreme Values calculation from ModelRisk does, in a fast and accurate way.

This is useful for modeling scenarios where special attention has to be given to extreme cases, as is often the case in insurance modeling.

Note how you can insert quite a large value for N (e.g. N=100000). Risk analysts who have modeled this type of situation "manually" before will appreciate the speed with which this calculation is done.

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

Window elements

In the Extreme values parameters section, three (or sometimes four) fields are provided.

In the Extreme values selection field, you can provide the type of extreme values to calculate the distribution for. Note that these make use of VoseFunctions that can be used separately for modeling as well. The options are:

In the Distribution field, you can provide the Distribution (as an Object) from which to take the N samples. This can be filled in manually, chosen from a list or from the spreadsheet.

In the N field, you can provide the number of samples of which the extreme value distribution should be calculated.

When appropriate, a K or number of values field appear, of which the purpose is explained above.

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.