MM_PARAMNAME function

Returns the name of one of the parameters of a specified probability distribution.

Written By Nikolas Ethoré (Super Administrator)

Updated at November 24th, 2021

Description

Returns the name of one of the parameters of a specified probability distribution.

Syntax

=MM_PARAMNAME("DistName", ParamNumber)
  • "Distname"
    String. Name of the probability distribution. 

  • ParamNumber
    Index of the distribution parameter whose name you wish to return. The value must be an integer from 1 to the total number of parameters for the specified distribution. Maximum is 3.

Example

  • Formula in B3: =MM_PARAMNAME($A3,B$2) returns the name of the first (and only) parameter of the Bernoulli distribution.

  • The above formula is copied from cell B3 to D25. The table gives the list of parameters for all supported probability distributions.