WEIBULL function

CALC FUNCTIONS

Statistical Functions

< Previous Section

Next Section >

FUNCTIONS

Spreadsheet Lookup functions

• AVEDEV
• AVERAGE
• AVERAGEA
• COUNT
• COUNTA
• GEOMEAN
• HARMEAN
• MEDIAN
• MODE
• TRIMMEAN

Measures of dispersion / spread

• DEVSQ
• KURT
• SKEW
• STDEV
• STEDEVA
• STDEVP
• STDEVPA
• VAR
• VARA
• VARP
• VARPA

Probability and statistics

• B
• BETADIST
• BETAINV
• BINOMDIST
• CHIDIST
• CHIINV
• CHISQINV
• CHITEST
• CONFIDENCE
• CRITBINOM
• EXPONDIST
• FINV
• FISHER
• FISHERINV
• FDIST
• FTEST
• GAMMA
• GAMMAINV
• GAMMALN
• GAMMADIST
• GAUSS
• HYPGEOMDIST
• LOGINV
• LOGNORMDIST
• NEGBINOMDIST
• NORMINV
• NORMDIST
• NORMSINV
• NORMSDIST
• PERMUT
• PERMUTATIONA
• PHI
• POISSON
• PROB
• STANDARDIZE
• TDIST
• TINV
• TTEST
• WEIBULL
• ZTEST

Correlation and line fitting

• CORREL
• COVAR
• FORECAST
• INTERCEPT
• PEARSON
• RSQ
• SLOPE
• STEYX

See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND

Ranking

• LARGE
• MAX
• MAXA
• MIN
• MINA
• PERCENTILE
• PERCENTRANK
• QUARTILE
• RANK
• SMALL

< Previous Page

Next Page >

WEIBULL

Calculates values for a Weibull distribution.

Syntax:

WEIBULL(x; k; λ; mode)

The Weibull distribution is a continuous probability distribution, with parameters k > 0 (shape) and λ > 0 (scale).

If mode is 0, WEIBULL calculates the probability density function of the Weibull distribution:

If mode is 1, WEIBULL calculates the cumulative distribution function of the Weibull distribution:

Example:

WEIBULL(2.5; 3; 4; 1)

returns approximately 0.2166, the value of the probability density function with k = 3 and λ = 4 at x = 2.5.

WEIBULL(2.5; 3; 4; 0)

returns approximately 0.2295, the value of the cumulative distribution function with k = 3 and λ = 4 at x = 2.5.

---

See Also

• EXPONDIST
• NORMSDIST

• Statistical functions

• Functions listed alphabetically
• Functions listed by category