VoseCopulaBiNormal | Vose Software

# VoseCopulaBiNormal

{=VoseCopulaBiNormal(Correlation)}

Example model

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

• Correlation - linear correlation coefficient. Must be on [-1,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.