Statistical
WEIBULL function
Weibull distribution (legacy). WEIBULL works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=WEIBULL(x, alpha, beta, cumulative) | Argument | Use |
|---|---|
x | required |
alpha | required |
beta | required |
cumulative | required |
On live data
In Sheets, WEIBULL sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
More statistical functions
AVERAGEMean of valuesAVERAGEIFMean where one criterion matchesAVERAGEIFSConditional meanCOUNTCount numbersCOUNTACount non-emptyCOUNTIFCount where one criterion matchesCOUNTIFSConditional countMAXMaximum valueMAXIFSLargest value where all criteria matchMEDIANMiddle valueMINMinimum valueMINIFSSmallest value where all criteria match
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.