Multivariate.PERT
RiskAMP Random Distribution Functions
Using this function in Excel:
=Multivariate.PERT(Range of Values, Correlation, Minimum, Most Likely, Maximum, Lambda)
Function arguments:
| Range of Values | Range comprising the multivariate distribution |
| Correlation | Correlation matrix |
| Minimum | Minimum value for the PERT distribution |
| Most Likely | Most likely value for the PERT distribution |
| Maximum | Maximum value for the PERT distribution |
| Lambda | Optional weight parameter for the PERT distribution |
Returns a sample from the Beta-PERT distribtion, as part of a multivariate distribution.
This is a multivariate distribution function. See the page Multivariate Distribution for more information on the Range and Correlation parameters.