MR_button_wilkie_models.bmp Wilkie Models

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

See also: The Wilkie model, Time series in ModelRisk, the Vose Time Series window

image1103.gif

 

Introduction

MR_window_Wilkie_Models_1.jpg
The Wilkie Models window
from ModelRisk

The Wilkie Model - named after A.D. Wilkie - models the behavior of various economic series over time. As it is currently widely being used in actuarial work.

For a detailed explanation about Wilkie models see the Wilkie models topic.

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

Window elements

Output

MR_window_Wilkie_Models_2.jpg

Each of these takes a certain set of parameters, which can be inserted manually by typing in the appropriate field, or dynamically link to a value in a spreadsheet.

The output to your spreadsheet will be a number of columns equal to the number of selected models.

Check the Show Descriptions checkbox to have the name of each Wilkie Model on top of its column with generated values.

Models
MR_window_Wilkie_Models_3.jpg
The Models
pane in the Wilkie Models window.

In the models pane (shown in the image on the right), you can select what models to generate data for. For each selected model, some summary data are shown. The Wilkie models to choose from are:

Wilkie models graphs

MR_window_Wilkie_Models_4.jpg

In the middle pane, the graphs with generated lines from (only) the selected Wilkie model(s) are shown.

To save screen space, the toolbar for Wilkie models graphs is hidden by default. While this might give the impression less customization is allowed, the opposite is actually true: you can customize each graph shown seperately!

By right-clicking anywhere in the graph area, you are presented a context menu from which you can hide/unhide the toolbar, change the color of the item selected, add/change the graphs title, point labels, font and show the advanced display properties (3D, border, gridlines...).

The buttons on a graph toolbar allow you to, from left to right:

When you hold your mouse pointer on a line, it comes "in focus" and all other visible elements are greyed out, for easily pointing somebody to a certain line.

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.