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:
A
|
B
|
|
|---|---|---|
1
|
||
2
|
||
3
|
||
4
|
||
5
|
||
6
|
