VoseCopulaBiNormal

Download a pdf copy of this help file  here

See also: Copulas in ModelRisk, Bivariate Copula window, Vose Multivariate Copula, VoseCopulaMultiNormal, Elliptical copulas - Normal and T

{=VoseCopulaBiNormal(covariance)}

Example model

The bivariate copula window  

Array function that returns random variables from a bivariate Normal copula.

• covariance - the covariance parameter. should be a real number between -1 and 1.

The output is an array of two cells, with randomly generated copula values between [0,1]. Link the U-parameter of distribution functions to these to generate values of these distributions correlated by this copula.

Note that a negating the sign of the covariance parameter corresponds to changing the direction of the copula.

For the multivariate version of this copula see VoseCopulaMultiNormal.

Example: correlating variables with a bivariate Normal copula

For example, to generate a normal(0,1) and a beta(2,1) value correlated by a Normal(0.5) copula, you would do the following:

• Select the A1 and B1 spreadsheet cells.

• Type =VoseCopulaBiNormal(5) in the Excel formula bar and press CTRL+SHIFT+ENTER - Excel now inserts this as an array function over the two selected cells, indicated by curly brackets.

• Insert =VoseNormal(0,1,A1) in the cell A2, and =VoseBeta(2,1, B1) in the cell B2. The cell references are U parameters that refer to the copula values generated in the first cell.

• Now the A2 and B2 cell contain random values correlated by the copula.

VoseFunctions for this copula

VoseCopulaBiNormal generates values from this distribution or calculates a percentile.

VoseCopulaBiNormalFit fits this copula to data.

VoseCopulaBiNormalFitP returns the parameter(s) of this copula fitted to data.