MM_DISTRIBUTIONSLIST function

Returns a range that contains all supported probability distributions.

Written By Son Nguyen (Administrator)

Updated at March 12th, 2024

Description

Returns a range that contains all supported probability distributions.

The output values are the names of the probability distributions meant to be used in other functions of the add-in MMforExcel (for instance, MM_CDF, MM_PDF, MM_SIMULATE, ...).

Syntax

=MM_DISTRIBUTIONSLIST()

No parameters.

Remark 

Notice that the function MM_GETRANGE will automatically appear in your table. This function is used as an intermediate step by some functions from the add-in. It has no other purpose.

Example

Formula 1: =MM_DISTRIBUTIONSLIST() in cell A2
Generates a list of supported probability distributions. 

Formula 2: =MM_SIMULATE(A2, 0.8) simulates a Bernoulli distribution of parameter 0.8 - see MM_SIMULATE function for further details.