# Question: Create an Excel spreadsheet to produce a chart similar to

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.

distribution. Compare the two charts you have produced.

**View Solution:**## Answer to relevant Questions

Suppose that a bank has made a large number loans of a certain type. The one-year probability of default on each loan is 1.2%. The bank uses a Gaussian copula for time to default. It is interested in estimating a “99.97% ...Suppose that we back-test a VaR model using 1,000 days of data. The VaR confidence level is 99% and we observe 15 exceptions. Should we reject the model at the 5% confidence level? Use Kupiec’s two-tailed test. Consider a position consisting of a $300,000 investment in gold and a $500,000 investment in silver. Suppose that the daily volatilities of these two assets are 1.8% and 1.2% respectively, and that the coefficient of ...Why is there an add-on amount in Basel I for derivatives transactions? “Basel I could be improved if the add-on amount for a derivatives transaction depended on the value of the transaction.” How would you argue this ...In Figure 18.3 where the CCP is used, suppose that an extra transaction between A and C which is worth 140 to A is cleared bilaterally. What effect does this have on the tables in Figure 18.3?Post your question