Syntax
=WEIBULL.DIST(x, alpha, beta, cumulative)Arguments
| Argument | Required | Description |
|---|---|---|
x | Required | The value (0 or more) |
alpha | Required | The shape (positive) |
beta | Required | The scale (positive) |
cumulative | Required | TRUE for the cumulative distribution, FALSE for the density |
How to use WEIBULL.DIST
WEIBULL.DIST takes 4 required arguments. Type =WEIBULL.DIST( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=WEIBULL.DIST(105, 20, 100, TRUE)Result =WEIBULL.DIST(105, 20, 100, FALSE)Result Related statistical functions
- T.INV.2TReturns the two tailed inverse of the Student's t distribution.
- T.TESTReturns the probability from a Student's t test that two samples come from populations with the same mean.
- TRENDReturns values along the least squares straight line that fits the known data.
- TRIMMEANReturns the mean of the values after leaving out a percentage of the smallest and largest ones.
- VAR.PReturns the variance of a whole population.
- VAR.SEstimates the variance from a sample.
- VARAEstimates the variance from a sample, counting text as 0 and TRUE as 1.
- VARPAReturns the population variance, counting text as 0 and TRUE as 1.
- Z.TESTReturns the one tailed probability of a z test for a hypothesised population mean.