Select the distribution and parameters for Inverse Cumulative Distribution Function (ICDF)

In the Inverse Cumulative Distribution Function (ICDF) dialog box, specify the distribution and the parameters.

Binomial

Complete the following steps to enter the parameters for the binomial distribution.

  1. In Number of trials, enter the sample size.
  2. In Event probability, enter a number between 0 and 1 for the probability that the outcome you are interested in occurs. An occurrence is called an "event".

Chi-square

Complete the following steps to enter the parameters for the chi-square distribution.
  1. In Degrees of freedom, enter the degrees of freedom to define the chi-square distribution.
  2. If you are calculating cumulative probability or inverse cumulative probability, in Noncentrality parameter, enter the noncentrality parameter. Usually, the noncentrality parameter is 0.

Discrete

Complete the following steps to enter the parameters for the discrete distribution.

  1. In Values in, enter the column that contains the values to include in the distribution. Usually, values are discrete events or counts that are represented by numeric values.
  2. In Probabilities in, enter the column that contains the probabilities for each value. Probabilities must be between 0 and 1, and must sum to 1.

Exponential

Complete the following steps to enter the parameters for the exponential distribution.

  1. In Scale, enter the scale parameter. The scale parameter equals the mean when the threshold parameter equals 0.
  2. In Threshold, enter the lower bound of the distribution.

F

Complete the following steps to enter the parameters for the F-distribution.
  1. In Numerator degrees of freedom and Denominator degrees of freedom, enter the numerator and denominator degrees of freedom to define the F-distribution.
  2. If you are calculating cumulative probability or inverse cumulative probability, in Noncentrality parameter, enter the noncentrality parameter. Usually, the noncentrality parameter is 0.

Geometric

Complete the following steps to enter the parameters for the Geometric distribution.

  1. In Event probability, enter a number between 0 and 1 for the probability of an occurrence on each trial. An occurrence is called an "event".
  2. From Model, select one of the following to specify the number to model.
    • Total number of trials: The number of trials includes both events and nonevents.
    • Only the number of non-events: Do not count the event.

For example, this plot shows a geometric distribution that has an event probability of 0.5 and models the total number of trials.

Integer

Complete the following steps to enter the parameters for the integer distribution.

  1. In Minimum value, enter the lower end point of the distribution.
  2. In Maximum value, enter the upper end point of the distribution.

Lognormal

Complete the following steps to enter the parameters for the lognormal distribution.

  1. In Location, enter a value that represents the location of the peak of the related normal distribution.
  2. In Scale, enter a value that represents the spread of the related normal distribution.
  3. In Threshold, enter the lower bound of the distribution.

Normal

Complete the following steps to enter the parameters for the normal distribution.

  1. In Mean, enter the value for the center of the distribution.
  2. In Standard deviation, enter the value for the spread of the distribution.

Poisson

In Mean, enter the average rate of occurrence. For more information, go to Poisson distribution.

t

Complete the following steps to enter the parameters for the t-distribution.
  • In Degrees of freedom, enter the degrees of freedom to define the t-distribution.
  • If you are calculating cumulative probability or inverse cumulative probability, in Noncentrality parameter, enter the noncentrality parameter. Usually, the noncentrality parameter is 0.

Uniform

Complete the following steps to enter the parameters for the uniform distribution.
  1. In Lower endpoint, enter the minimum value for the distribution.
  2. In Upper endpoint, enter the maximum value for the distribution.

Weibull

Complete the following steps to enter the parameters for the Weibull distribution.

  1. In Shape parameter, enter the shape parameter to define the Weibull distribution.
  2. In Scale parameter, enter the scale parameters to define the Weibull distribution.
  3. In Threshold parameter, enter the lower bound of the Weibull distribution.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy