Menu
EXCEL WEIBULL FUNCTION
Excel WEIBULL Function Introduction
The Excel WEIBULL function computes the Weibull Probability Density Function or the Weibull Cumulative Distribution Function for a given criterion.
Description of Excel WEIBULL Function
Syntax :
=WEIBULL( x, alpha, beta, cumulative)
Parameters :
- x – The value at which the function is to be computed (must be 0).
- alpha – The distribution’s shape parameter (must be greater than 0).
- beta – The distribution’s Scale parameter (must be greater than 0).
- cumulative – A logical argument that defines the type of distribution to be employed;
–
| TRUE | = | Weibull Cumulative Distribution Function |
| FALSE | = | Weibull Probability Density Function |
Step By Step Guide of WEIBULL Function
Example :
The graphic in below side shows the Weibull Probability Density Function with the shape parameter, alpha, set to 3 and the scale parameter, beta, set to 1.
If you wish to determine the value of this function at x = 1, you may use the Excel Weibull function.
=WEIBULL( 1, 3, 1, FALSE )
This yields the answer 1.10363832351433.
Key Points
- #NUM! – Occurs if either the supplied x value is zero or the supplied alpha or beta parameter is zero.
- #VALUE! – This error occurs if any of the supplied parameters is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
