WEIBULL.DIST (Weibull distribution)

<< Click to Display Table of Contents >>

WEIBULL.DIST (Weibull distribution)

Syntax:

WEIBULL.DIST(x, Alpha, Beta, Cumulative)

Description:

Returns the Weibull distribution function.

The Weibull distribution is an extension of the exponential distribution (see function EXPON.DIST/EXPONDIST) to occurrences that are not purely random and do not exactly match the Poisson distribution (see function POISSON.DIST/POISSON).

It is used especially for reliability analysis.

x is the value to be evaluated. Must be ≥ 0.

Alpha is a parameter of distribution. Alpha determines the shape of the distribution curve. If Alpha = 1, the Weibull distribution equals an exponential distribution with Lambda = 1/Beta.

Beta is another parameter of the distribution. Beta determines the scaling of the distribution curve, i.e. it stretches or compresses the function graph.

Both parameters has to be greater than zero.

The logical value Cumulative lets you specify which type of function will be returned:

FALSE: The probability density function is returned.

TRUE: The cumulative distribution function is returned.

Example:

WEIBULL.DIST(42, 2, 100, TRUE) returns 0.16172

WEIBULL.DIST(42, 2, 100, FALSE) returns 0.00704

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.

See also:

WEIBULL, EXPON.DIST/EXPONDIST, POISSON.DIST/POISSON