Multivariate Copula

See also: Modeling correlation , Help on ModelRisk, Copulas in ModelRisk, Vose Bivariate Copula, Common elements of ModelRisk windows

Introduction

Copulas are used for correlating two or more random variables and allow for greater flexibility than older correlation methods, like rank_order_correlation.

Associated with every Multivariate Copula is its copula density, which is much like the probability density of a (multivariate) distribution.

The output of a multivariate Copula in ModelRisk is an array of spreadsheet cells. These cells will contain Uniform(0,1) random variables with a pattern of correlation defined by the copula.

The following multivariate copulas are available for use in spreadsheet models in ModelRisk :

These correlated Uniform(0,1) variables are used as the U-parameter in the desired distributions. The result is that the final spreadsheet cells will contain variables sampled from your chosen distributions and correlated (through the Uniform(0,1) variables as U-parameter) by the chosen copula.

You can read more about the mathematical details of copulas here.

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

Window elements

Copula parameters, Correlation matrix and correlated distributions

In the Copulas section, you can choose between a number of different copulas:

The Correlation matrix is shown, and dimensions can be added or removed by clicking the + and - buttons. When an element of the matrix is selected, a distribution to be correlated can be chosen for it.

In the Correlated distributions area, the distributions to be correlated can be selected. These can be either typed directly, chosen from the Select Distribution window, or inserted from a spreadsheet cell.

Copula graph

In the middle pane, a scatter plot of the copula is shown. Of course, a copula of dimension greater than 2 is hard to visualize. The points represent randomly generated (x,y) values generated by two distributions in the copula: the X- and the Y- axis represent the correlated variables associated with the first and second selected distribution, respectively.

By default, the percentiles of these 2 correlated variables can be shown: these are values between 0 and 1. As explained above, certain pairs will have a higher probability of being generated, as determined by their correlation (i.e. the copula used).

Optionally, the actual values of sampled random variables can be shown, with both axes rescaling appropriately. This goes one step further: the (x,y) pairs represent sampled random variables from the chosen distributions, with the percentiles now being driven by the copula. Internally, this is the U-parameter in action: it takes the random value generated by the copula.

The zero-axes are shown with grey lines.

 

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.

 

 

ModelRisk

Monte Carlo simulation in Excel. Learn more

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Navigation

FREE MONTE CARLO SIMULATION SOFTWARE

For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now

FREE PROJECT RISK SOFTWARE

For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now
-->