To learn more about EpiX Analytics' work, please visit our modeling applications, white papers, and training schedule.

Page tree

The envelope method offers a more flexible technique for modeling dependent variables that are both intuitive and easy to control. It models the logic whereby the value of the independent variable statistically determines the value of the dependent variable.

 

This problem shows a way of creating a correlation between two random variables.

For example, we may have both next year's interest rate and next year's mortgage rate represented as distributions. The figure below gives an example of two distributions modeling these interest rate and mortgage rate predictions.

 Clearly, these two components are strongly positively correlated, i.e. if the interest rate turns out to be at the high end of the distribution, the mortgage rate should show a correspondingly high value. If we neglect to model the inter-dependency between these two components, the joint probabilities of the various combinations of these two parameters will be incorrect.  Impossible combinations will also be generated.  For example a value for the interest rate of 6.5% could occur with a value for the mortgage rate of 5.5%.

We will model the interest rate as an  independent random variable, which is correlated with the random samples for the mortgage rate.

Let's model the interest rate as a PERT distribution with three parameters - the minimum of 3%, the most likely of 5% and the maximum of 8%. Let's assume these values were determined from some previous expert elicitation. Now we ask the experts the following questions: if the interest rate was as low as 3% what could the mortgage rate be? The answers we get are minimum 6%, most likely 8% and maximum 10%. Ditto if the interest rate was 5%, the mortgage rate would be minimum 8%, most likely 10% and maximum 13% and if the interest rate were as high as 8% then the mortgage rate would be minimum 10%, most likely 13% and maximum 16%:

 

 

Interest rate

Mortgage rate

Minimum

Most likely

Maximum

3%

6%

8%

10%

5%

8%

10%

13%

8%

10%

13%

16%

 

The solution to the problem is provided in the model correlating interest and mortgage rates

The links to the correlating interest and mortgage rates software specific models are provided here:

  correlating_interest_and_mortgage_rates

Here is a screenshot of the model:

 

 

 

 

 

 

 

 

 

 

 

 

 

The independent variable (interest rate) is in cell C18, the polynomial equations in cells C20, C21 and C22; and the minimum most likely and maximum of those mortgage rates are in cell C24.

  correlating_interest_and_mortgage_rates 

 Here is a screenshot of the model:

The independent variable (interest rate) is in cell C18, the polynomial equations in cells C20, C21 and C22; and the minimum most likely and maximum of those mortgage rates are in cell C24.

 

First we need to find 3 polynomial functions that run through the interest rate combined with the mortgage rate minimum line then the mortgage rate most likely and the mortgage rate maximum lines:

 

 

They give us 3 polynomial equations, which run through the 3 sets of dots. We can now use these equations to calculate for a given value of the interest rate being simulated, what that mortgage rate minimum most likely and maximum are.

 

With the independent variable (interest rate) and the polynomial equations (Min, Most Likely and Max), we can finally sample from a PERT distribution constructed from the minimum most likely and maximum of those mortgage rates. Simulation will produce the following chart of interest rate vs. mortgage rate:

 

 

 

  • No labels