Saturday, September 1, 2018

WEIBULL function

WEIBULL function

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

Syntax

WEIBULL(x,alpha,beta,cumulative)

X     is the value at which to evaluate the function.

Alpha     is a parameter to the distribution.

Beta     is a parameter to the distribution.

Cumulative     determines the form of the function.

Remarks

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

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

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

  • The equation for the Weibull cumulative distribution function is:

    Equation

  • The equation for the Weibull probability density function is:

    Equation

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

    Equation

Examples

X

Alpha

Beta

Formula

Description (Result)

105

20

100

=WEIBULL([X],[Alpha],[Beta],TRUE)

Weibull cumulative distribution function for the specified arguments (0.929581)

105

20

100

=WEIBULL([X],[Alpha],[Beta],FALSE)

Weibull probability density function for the specified arguments (0.035589)

No comments:

Post a Comment