WEIBULL function - The function returns the Weibull distribution in Excel

GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
POISSON.DIST function - The function returns the Poisson distribution in Excel

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 1

- Weibull cumulative distribution function equation:

WEIBULL 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 3

For example:

Calculate the Weibull distribution when knowing the following parameters:

WEIBULL 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 5

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

WEIBULL 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 7

Press Enter -> Weibull probability density function value is:

WEIBULL 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!

Jessica Tanner

Update 19 May 2020

You should read it

May be interested

T.INV function - The function returns the inverse value of the Student t distribution in Excel
t.inv: the function returns the inverse value of the student t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
T.DIST.RT - The function returns the Student's t-distribution on the right in Excel
t.dist.rt: the function returns the student's t-distribution on the right. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist.rt (x, deg_freedom)
F.DIST - The function returns the probability distribution F in Excel
f.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel
hypgeom.dist: the function returns the hyperinfection distribution, using this function for problems with finite sets of vowismooix observations whether or not they are successful. syntax: hypgeom.dist (sample_s, number_sample, population_s, number_pop, cumulative)
F.INV function - The function returns the inverse of the probability distribution F in Excel
f.inv function: the function returns the inverse of the probability distribution f. support function from the excel 2010 version. syntax: f.inv (probability, deg_freedom1, deg_freedom2)
F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
f.inv.rt function: the function returns the inverse of the right probability distribution f. support functions from the excel 2010 version. syntax: f.inv.rt (probability, deg_freedom1, deg_freedom2)
CHISQ.DIST - Function returns the distribution when squared in Excel
chisq.dist: the function returns the distribution when squared, and this value is often used to understand variations as a percentage of the samples. support function from excel 2010 version. syntax: chisq.dist (x, deg_freedom, cumulative)
LOGNORM.DIST - Function returns the logarithmic distribution of x in Excel
lognorm.dist: the function returns the logarithmic distribution of x. where ln (x) is usually distributed with parameter mean and standard deviation. support functions from excel 2010 onwards. syntax: lognorm.dist (x, mean, standard_dev, cumulative)
T.DIST - The function returns the Student t-distribution on the left in Excel
t.dist: the function returns the student's t-distribution on the left. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist (x, deg_freedom, cumulative)
T.DIST.2T - The function returns the two-tailed Student distribution in Excel
t.dist.2t: the function returns the two-tailed student's t-distribution. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist.2t (x, deg_freedom)