For a given and , the parameter defines the long run average value of a variance or a
covariance. There is no reason why we should expect the long run average daily variance for X
11.17. (Spreadsheet Provided)
The probability density function for an exponential distribution is e−x where x is the value of
the variable and is a parameter. The cumulative probability distribution is 1− e−x. Suppose
that two variables V1 and V2 have exponential distributions with parameters of 1.0 and 2.0,
respectively. Use a Gaussian copula to define the correlation structure between V1 and V2 with a
copula correlation of –0.2. Produce a table similar to Table 11.3 using values of 0.25, 0.5, 0.75,
1, 1.25, and 1.5 for V1 and V2. A spreadsheet for calculating the cumulative bivariate normal
distribution is on the author’s website: www-2.rotman.utoronto.ca/∼hul/riskman.
(using software on the author’s website). The other cumulative probabilities are shown in the
table below and are calculated similarly.
V1
V2
0.25 0.50 0.75 1.00 1.25 1.50
0.25 0.065 0.117 0.153 0.177 0.193 0.203
11.18. (Spreadsheet Provided)
Create an Excel spreadsheet to produce a chart similar to Figure 11.5 showing samples from a
bivariate Student’s t-distribution with four degrees of freedom where the correlation is 0.5. Next
suppose that the marginal distributions of V1 and V2 are Student’s t with four degrees of freedom
but that a Gaussian copula with a copula correlation parameter of 0.5 is used to define the
correlation between the two variables. Construct a chart showing samples from the joint
distribution. Compare the two charts you have produced.