SheetFX
≡
<< Go back to all functions

WEIBULL.DIST

The WEIBULL.DIST function in Google Sheets is used to calculate the Weibull distribution. It is commonly used in reliability analysis to model the time it takes for a certain event to occur. Learn how to apply this function effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: WEIBULL.DIST(x, shape, scale, cumulative)

Parameters:

  • x: The value at which to evaluate the function.
  • shape: The shape parameter of the Weibull distribution.
  • scale: The scale parameter of the Weibull distribution.
  • cumulative: A logical value that determines the form of the function.

Step-by-Step Tutorial

  1. Calculating Weibull distribution:
    • Example: =WEIBULL.DIST(10, 3, 2, TRUE)
    • Result: Returns the cumulative probability of x in the Weibull distribution with shape = 3 and scale = 2.

Use Cases and Scenarios

  1. Reliability Analysis: Model the time it takes for a particular event to occur.
  2. Failure Rate Prediction: Analyze failure rates of different products or systems.
  3. Extreme Value Analysis: Study extreme values in various fields such as finance or weather.

Related Functions

  • WEIBULL: Calculate the Weibull distribution probability density function.

Related Articles