Statistical

Built-in functions › Spreadsheet formulas › Statistical

97 functions in this category.

Statistical

Function	What it does
avedev	Average of absolute deviations from the mean.
average	Arithmetic mean of numeric arguments (Excel-compatible).
averagea	Arithmetic mean treating text as 0 and TRUE as 1.
averageif	Mean of numbers in a range that meet a criterion.
averageifs	Mean of numbers meeting multiple criteria.
beta_dist	Beta-distribution PDF or CDF.
beta_inv	Inverse beta CDF.
binom_dist	Binomial-distribution PDF or CDF.
binom_dist_range	Probability of binomial successes in a range.
binom_inv	Inverse binomial CDF (smallest k with CDF ≥ alpha).
chisq_dist	Chi-squared left-tail PDF or CDF.
chisq_dist_rt	Chi-squared right-tail CDF.
chisq_inv	Inverse chi-squared left-tail CDF.
chisq_inv_rt	Inverse chi-squared right-tail CDF.
chisq_test	Chi-squared test of independence p-value.
confidence_norm	Half-width of a confidence interval (normal distribution).
confidence_t	Half-width of a confidence interval (t distribution).
count	Count numeric values in the arguments.
counta	Count non-empty values in the arguments.
countblank	Count empty cells in a range.
countif	Count cells in a range that meet a criterion.
countifs	Count cells meeting multiple criteria.
covariance_p	Population covariance.
covariance_s	Sample covariance.
devsq	Sum of squared deviations from the mean.
expon_dist	Exponential-distribution PDF or CDF.
f_dist	F-distribution left-tail PDF or CDF.
f_dist_rt	F-distribution right-tail CDF.
f_inv	Inverse F-distribution left-tail CDF.
f_inv_rt	Inverse F-distribution right-tail CDF.
f_test	F-test for equal variances (two-tailed p-value).
fisher	Fisher transformation of a correlation coefficient.
fisherinv	Inverse Fisher transformation.
forecast_linear	Predict a y value from linear regression at a single x.
frequency	Frequency distribution (counts in bins).
gamma_dist	Gamma-distribution PDF or CDF.
gauss	Probability that a standard-normal value is between 0 and x.
geomean	Geometric mean.
growth	Exponential-trend predictions.
harmean	Harmonic mean.
hypgeom_dist	Hypergeometric distribution PMF or CDF.
intercept	Y-intercept of a linear regression line.
kurt	Sample (excess) kurtosis.
kurt_p	Population (excess) kurtosis.
large	K-th largest value in an array.
linest	Linear regression coefficients (with optional statistics).
logest	Exponential regression coefficients.
lognorm_dist	Log-normal distribution PDF or CDF.
lognorm_inv	Inverse log-normal CDF.
maxa	Maximum value, treating text as 0 and TRUE as 1.
maxifs	Maximum value among cells meeting multiple criteria.
mina	Minimum value, treating text as 0 and TRUE as 1.
minifs	Minimum value among cells meeting multiple criteria.
mode_mult	All most-frequent values (multiple modes).
mode_sngl	Most-frequent value (single mode).
negbinom_dist	Negative-binomial distribution PMF or CDF.
norm_dist	Normal-distribution PDF or CDF.
norm_inv	Inverse normal CDF (quantile function).
norm_s_dist	Standard-normal PDF or CDF.
norm_s_inv	Inverse standard-normal CDF.
pearson	Pearson product-moment correlation coefficient.
percentile_exc	K-th percentile (exclusive of 0% and 100%).
percentile_inc	K-th percentile (inclusive of 0% and 100%).
permut	Number of ordered selections (permutations) of k from n.
permutationa	Number of permutations with repetition allowed.
phi	Standard-normal PDF value.
poisson_dist	Poisson-distribution PMF or CDF.
prob	Probability that a value falls in a range, given a discrete distribution.
quartile_exc	Quartile of a data set (exclusive).
quartile_inc	Quartile of a data set (inclusive).
rank_avg	Rank of a value (ties get the average of the ranks).
rank_eq	Rank of a value (ties get the same rank).
rsq	Square of the Pearson correlation coefficient (R²).
skew	Sample skewness.
skew_p	Population skewness.
slope	Slope of a linear regression line.
small	K-th smallest value in an array.
standardize	Z-score for a value given the population mean and standard deviation.
stdev_p	Population standard deviation (Excel-compatible).
stdev_s	Sample standard deviation (Excel-compatible).
stdeva	Sample standard deviation including text and logicals.
stdevpa	Population standard deviation including text and logicals.
steyx	Standard error of predicted y values from a regression.
t_dist	Student’s t left-tail PDF or CDF.
t_dist_2t	Student’s t two-tailed CDF.
t_dist_rt	Student’s t right-tail CDF.
t_inv	Inverse Student’s t left-tail CDF.
t_inv_2t	Inverse Student’s t two-tailed CDF.
t_test	Student’s t-test p-value.
trend	Linear-trend predictions.
trimmean	Trimmed mean (mean excluding outliers).
var_p	Population variance (Excel-compatible).
var_s	Sample variance (Excel-compatible).
vara	Sample variance including text and logicals.
varpa	Population variance including text and logicals.
weibull_dist	Weibull-distribution PDF or CDF.
z_test	One-sample z-test p-value (right-tail).