WEIBULL function - The function returns the Weibull distribution in Excel

The function performs the calculation and returns the Weibull distribution. Based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.

The following article details how to use the WEIBULL function, the function returns the Weibull distribution.

Description : The function performs calculations and returns the Weibull distribution. Based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.

Syntax : WEIBULL (x, alpha, beta, cumulative) .

Inside:

- x : Value used to evaluate the function, is a required parameter.

- alpha : A parameter to the distribution, is a required parameter.

- beta : A parameter to the distribution, a required parameter.

- cumulative : Logical value to determine the form of the function, is a required parameter. Cumulative has the following 2 values:

+ cumulative = True -> calculates the Weibull cumulative distribution function.

+ cumulative = False -> perform calculation of the distribution function of the Weibull probability density function.

Attention:

- Case 1 of 3 parameters x , alpha , beta are not numbers -> function returns the error value #VALUE !

- x <0 -> function returns the #NUM! error value

- If alpha ≤ 0 or beta ≤ 0 -> the function returns the #NUM! Error value

- When alpha = 1 function returns exponential distribution with:

WEIBULL function - The function returns the Weibull distribution in Excel Picture 1WEIBULL function - The function returns the Weibull distribution in Excel Picture 1

- Weibull cumulative distribution function equation:

WEIBULL function - The function returns the Weibull distribution in Excel Picture 2WEIBULL function - The function returns the Weibull distribution in Excel Picture 2

- Weibull probability density function equation:

WEIBULL function - The function returns the Weibull distribution in Excel Picture 3WEIBULL function - The function returns the Weibull distribution in Excel Picture 3

For example:

Calculate the Weibull distribution when knowing the following parameters:

WEIBULL function - The function returns the Weibull distribution in Excel Picture 4WEIBULL function - The function returns the Weibull distribution in Excel Picture 4

1. Calculate the Weibull cumulative distribution function value with the value that determines the function = TRUE

In the cell to calculate enter the formula: = WEIBULL (D6, D7, D8, D9) .

WEIBULL function - The function returns the Weibull distribution in Excel Picture 5WEIBULL function - The function returns the Weibull distribution in Excel Picture 5

Press Enter -> the cumulative distribution function value WEIBULL is:

WEIBULL function - The function returns the Weibull distribution in Excel Picture 6WEIBULL function - The function returns the Weibull distribution in Excel Picture 6

2. Calculate the value of the Weibull probability density function with the value that determines the function = FALSE

In the cell to calculate enter the formula: = WEIBULL (D6, D7, D8, E9) .

WEIBULL function - The function returns the Weibull distribution in Excel Picture 7WEIBULL function - The function returns the Weibull distribution in Excel Picture 7

Press Enter -> Weibull probability density function value is:

WEIBULL function - The function returns the Weibull distribution in Excel Picture 8WEIBULL function - The function returns the Weibull distribution in Excel Picture 8

Above is how to use the Weibull function and the notes while using. Hope to help you.

Good luck!

3.7 ★ | 3 Vote