# Documentation/Calc Functions/WEIBULL.DIST

WEIBULL.DIST

## Category:

Statistical Analysis

## Summary:

Calculates either a probability density function or a cumulative distribution function for the Weibull distribution for a given data sample.

## Syntax:

WEIBULL.DIST(Number; Alpha; Beta; C)

## Returns:

Returns a real number which is either a probability density function or a cumulative distribution function for the Weibull distribution for Number with alpha value as Alpha and beta value as Beta.

## Arguments:

Number is a non-negative real number or a reference to a cell containing that number which is the value at which to calculate the Weibull distribution.

Alpha is a positive real number or a reference to the cell containing that number which is the shape parameter of the Weibull distribution. It is the shape.

Beta is a positive real number or a reference to the cell containing that number which is the scale parameter of the Weibull distribution. It is the scale.

C is a logical value that determines the form of the function. C = 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function.

• If Alpha or Beta is less than equal to zero then the function returns an error value.
• If Number is less than zero then the function will return an error value.

• The formula for WEIBULL.DIST is:

If C is 0, WEIBULL.DIST calculates the probability density function

If C is 1, WEIBULL.DIST calculates the cumulative distribution function.

• WEIBULL.DIST will give the same result as an exponential distribution when the value of the Alpha parameter is 1. This will mean the Lambda parameter in EXPON.DIST and EXPONDIST will be equal to (1/β).

λ = (1/β)

• For more details on weibull distribution, visit Wikipedia.

## Examples:

Formula Description Returns
=WEIBULL.DIST(5.8;2.2;3.7;0) The function calculates the probability density function for the weibull distribution on the given parameters. 0.069330557687019
=WEIBULL.DIST(5.8;2.2;3.7;1) The function calculates the cumulative distribution function for the weibull distribution on the given parameters. 0.932012008181695
=WEIBULL.DIST(-5.8;2.2;3.7;1) The function returns an error value since Number is less than 0. Err:502
=WEIBULL.DIST(5.8;0;3.7;1) The function returns an error value when either Alpha or Beta is less than equal to 0. Err:502

WEIBULL

EXPON.DIST

EXPONDIST

None

WEIBULL.DIST