SheetFX
≡
<< Go back to all functions

WEIBULL

The WEIBULL function in Google Sheets returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.

Function Syntax and Parameters

Syntax: WEIBULL(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: [Optional] A logical value that determines the form of the function to be evaluated.

Step-by-Step Tutorial

  1. Using WEIBULL function:
    • Example: =WEIBULL(2, 3, 4, TRUE)
    • Result: Returns the Weibull cumulative distribution function value for x = 2, shape = 3, scale = 4.

Use Cases and Scenarios

  1. Reliability Analysis: Determine the failure rates of a system using the Weibull distribution.
  2. Life Expectancy Calculation: Estimate the life expectancy of a set of products using Weibull parameters.
  3. Survival Analysis: Analyze the probability of survival or failure based on time-related variables.

Related Functions

  • None

Related Articles

  • None