In Google Sheets, the function WEIBULL.DIST is used to calculate the probability density or cumulative distribution function (CDF) of the Weibull distribution. It provides information about the probability of an event occurring at a specific value (x) in the Weibull distribution.

The syntax for the WEIBULL.DIST function is as follows: WEIBULL.DIST(x, alpha, beta, cumulative)

x: This is the value at which you want to evaluate the Weibull distribution. alpha: This parameter represents the shape parameter of the Weibull distribution. It must be a positive number. beta: This parameter represents the scale parameter of the Weibull distribution. It must be a positive number. cumulative: This is an optional logical argument that specifies whether you want to calculate the probability density (FALSE or 0) or the cumulative distribution function (TRUE or 1) of the Weibull distribution. By default, cumulative is set to TRUE.

The Weibull distribution is commonly used in reliability analysis to model the failure or survival time of a system or component. It is characterized by its shape and scale parameters.

If the cumulative argument is set to TRUE, the WEIBULL.DIST function calculates the cumulative probability that the Weibull-distributed random variable is less than or equal to the given value (x). If cumulative is set to FALSE, it calculates the probability density at the given value (x).