Multivariate distributions introduction


Multivariate distributions describe several parameters whose values are probabilistically linked in some way. In most cases, we create the probabilistic links via one of several correlation methods. However, there are a few specific multivariate distributions that have specific, very useful purposes and are therefore worth studying more.

Multivariate distributions are inserted in the spreadsheet as array functions. For example, to insert random values from a Dirichlet distribution in the spreadsheet:

  • Select 3 spreadsheet cells.

  • Type =VoseDirichlet({1,2,3}) in the formula bar

  • Press CTRL+SHIFT+ENTER

  • Now the function is inserted as array function over the 3 selected cells (inserted by the {} around the formula) which now contain randomly sampled values from the Dirichlet distribution.

The multivariate distributions available in ModelRisk are:

 

ModelRisk

Monte Carlo simulation in Excel. Learn more

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Navigation

FREE MONTE CARLO SIMULATION SOFTWARE

For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now

FREE PROJECT RISK SOFTWARE

For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now
-->