WEIBULL.DIST

Definition

Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure.

Sample Usage

Syntax

WEIBULL.DIST(x,alpha,beta,cumulative)

The WEIBULL.DIST function syntax has the following arguments:

• X     Required. The value at which to evaluate the function.

• Alpha     Required. A parameter to the distribution.

• Beta     Required. A parameter to the distribution.

• Cumulative     Required. Determines the form of the function.

Remarks

• If x, alpha, or beta is nonnumeric, WEIBULL.DIST returns the #VALUE! error value.

• If x < 0, WEIBULL.DIST returns the #NUM! error value.

• If alpha ≤ 0 or if beta ≤ 0, WEIBULL.DIST returns the #NUM! error value.

• The equation for the Weibull cumulative distribution function is:

  

• The equation for the Weibull probability density function is:

  

• When alpha = 1, WEIBULL.DIST returns the exponential distribution with:

  

In order to use the WEIBULL.DIST formula, start with your edited Excellentable

Then type in the WEIBULL.DIST formula in the area you would like to display the outcome:

By adding the values you would like to calculate the WEIBULL.DIST formula for, Excellentable will generate the outcome: