deepcalc
DocsStatistics

Statistics

Distributions, averages, spread and regression.

FunctionWhat it does
AVEDEV Average of absolute deviations from the mean.
AVERAGE.WEIGHTED Average of values weighted by a second range.
AVERAGEA Averages values including text and logicals.
AVERAGEIF Averages cells that match a condition.
AVERAGEIFS Averages cells matching multiple conditions.
BETA.DIST Beta distribution.
BETA.INV Inverse of the beta distribution.
BETADIST Legacy form of BETA.DIST (cumulative).
BETAINV Legacy form of BETA.INV.
BINOM.DIST Binomial distribution probability.
BINOM.DIST.RANGE Probability of a trial result range.
BINOM.INV Smallest value with cumulative binomial at or above a criterion.
BINOMDIST Legacy form of BINOM.DIST.
CHIDIST Legacy form of CHISQ.DIST.RT.
CHIINV Legacy form of CHISQ.INV.RT.
CHISQ.DIST Returns the chi-squared distribution.
CHISQ.DIST.RT Returns the right-tailed chi-squared distribution.
CHISQ.INV Returns the inverse of the chi-squared distribution.
CHISQ.INV.RT Returns the inverse of the right-tailed chi-squared distribution.
CHISQ.TEST Chi-squared test for independence.
CHITEST Legacy form of CHISQ.TEST.
CONFIDENCE Legacy form of CONFIDENCE.NORM.
CONFIDENCE.NORM Confidence interval for a population mean, normal.
CONFIDENCE.T Confidence interval for a population mean, Student's t.
CORREL Correlation coefficient between two data sets.
COUNT Counts cells containing numbers.
COUNTA Counts non-empty cells in a range.
COUNTBLANK Counts empty cells in a range.
COUNTIF Counts cells that match a condition.
COUNTIFS Counts cells matching multiple conditions.
COUNTUNIQUE Counts distinct non-empty values.
COVAR Legacy form of COVARIANCE.P: population covariance.
COVARIANCE.P Population covariance.
COVARIANCE.S Sample covariance.
CRITBINOM Legacy form of BINOM.INV.
DEVSQ Sum of squared deviations from the mean.
EXPON.DIST Exponential distribution.
EXPONDIST Legacy form of EXPON.DIST.
F.DIST F probability distribution.
F.DIST.RT Right-tailed F probability distribution.
F.INV Inverse of the F distribution.
F.INV.RT Inverse of the right-tailed F distribution.
F.TEST F-test for equality of variances.
FDIST Legacy form of F.DIST.RT.
FINV Legacy form of F.INV.RT.
FISHER Returns the Fisher transformation.
FISHERINV Inverse of the Fisher transformation.
FORECAST Predicts a value along a linear trend.
FORECAST.ETS Forecasts a value using exponential smoothing.
FORECAST.ETS.CONFINT Confidence interval for an ETS forecast.
FORECAST.ETS.SEASONALITY Season length detected by ETS.
FORECAST.ETS.STAT Statistic from the ETS model.
FORECAST.LINEAR Predicts a value on the linear regression line.
FREQUENCY Counts values falling into bins, spilled as a column.
FTEST Legacy form of F.TEST.
GAMMA.DIST Gamma distribution.
GAMMA.INV Inverse of the gamma distribution.
GAMMADIST Legacy form of GAMMA.DIST.
GAMMAINV Legacy form of GAMMA.INV.
GAMMALN Natural logarithm of the gamma function.
GAMMALN.PRECISE Natural logarithm of the gamma function.
GAUSS Probability a standard normal member falls between the mean and z.
GEOMEAN Returns geometric mean of positive values.
GROWTH Values along an exponential trend.
HARMEAN Returns the harmonic mean.
HYPGEOM.DIST Hypergeometric distribution.
HYPGEOMDIST Legacy form of HYPGEOM.DIST.
INTERCEPT Y-intercept of the linear regression line.
KURT Returns the kurtosis of a data set.
LARGE Returns the k-th largest value in a data set.
LINEST Parameters of the least-squares linear fit.
LOGEST Parameters of the exponential curve fit.
LOGINV Legacy form of LOGNORM.INV.
LOGNORM.DIST Lognormal distribution.
LOGNORM.INV Inverse of the lognormal distribution.
LOGNORMDIST Legacy form of LOGNORM.DIST (cumulative).
MARGINOFERROR Margin of error of a sample at a confidence level.
MAXA Returns the largest value, counting text and logicals.
MAXIFS Returns largest value matching conditions.
MEDIAN Returns the median of a set of numbers.
MINA Returns the smallest value, counting text and logicals.
MINIFS Returns smallest value matching conditions.
MODE Legacy form of MODE.SNGL: most frequent value in a data set.
MODE.MULT Returns an array of the most frequently occurring values.
MODE.SNGL Returns the most frequently occurring value.
NEGBINOM.DIST Negative binomial distribution.
NEGBINOMDIST Legacy form of NEGBINOM.DIST.
NORM.DIST Normal distribution.
NORM.INV Inverse of the normal distribution.
NORM.S.DIST Standard normal distribution.
NORM.S.INV Inverse of the standard normal distribution.
NORMDIST Legacy form of NORM.DIST.
NORMINV Legacy form of NORM.INV.
NORMSDIST Legacy form of NORM.S.DIST (cumulative).
NORMSINV Legacy form of NORM.S.INV.
PEARSON Pearson product moment correlation coefficient.
PERCENTILE Legacy form of PERCENTILE.INC: k-th percentile.
PERCENTILE.EXC K-th percentile, exclusive.
PERCENTILE.INC Returns the k-th percentile, inclusive.
PERCENTOF Share of a data subset within a whole.
PERCENTRANK Legacy form of PERCENTRANK.INC: rank as a percentage.
PERCENTRANK.EXC Percentage rank, exclusive.
PERCENTRANK.INC Percentage rank, inclusive.
PERMUT Returns the number of permutations of a set of objects.
PERMUTATIONA Returns the number of permutations with repetitions allowed.
PHI Density function value for the standard normal distribution.
POISSON Legacy form of POISSON.DIST.
POISSON.DIST Poisson distribution.
PROB Probability that values fall within limits.
QUARTILE Legacy form of QUARTILE.INC: quartile of a data set.
QUARTILE.EXC Returns a quartile, excluding the median.
QUARTILE.INC Returns a quartile, including the median.
RANK Legacy form of RANK.EQ: rank of a number in a list.
RANK.AVG Rank of a number, average rank for ties.
RANK.EQ Rank of a number, top rank for ties.
RSQ Square of the Pearson correlation coefficient.
SKEW Returns the skewness of a distribution.
SKEW.P Skewness based on the entire population.
SLOPE Slope of the linear regression line.
SMALL Returns the k-th smallest value in a data set.
STANDARDIZE Normalized value from a distribution.
STDEV Legacy form of STDEV.S: sample standard deviation.
STDEV.P Population standard deviation.
STDEV.S Sample standard deviation.
STDEVA Sample standard deviation, counting text and logicals.
STDEVP Legacy form of STDEV.P: population standard deviation.
STDEVPA Population standard deviation, counting text and logicals.
STEYX Standard error of the predicted y for each x.
T.DIST Student's t-distribution.
T.DIST.2T Two-tailed Student's t-distribution.
T.DIST.RT Right-tailed Student's t-distribution.
T.INV Left-tailed inverse of the t-distribution.
T.INV.2T Two-tailed inverse of the t-distribution.
T.TEST Probability from Student's t-test.
TDIST Legacy form of T.DIST.RT / T.DIST.2T.
TINV Legacy form of T.INV.2T.
TREND Values along a linear trend.
TRIMMEAN Mean of the interior of a data set.
TTEST Legacy form of T.TEST.
VAR Legacy form of VAR.S: sample variance.
VAR.P Population variance.
VAR.S Sample variance.
VARA Sample variance, counting text and logicals.
VARP Legacy form of VAR.P: population variance.
VARPA Population variance, counting text and logicals.
WEIBULL Legacy form of WEIBULL.DIST.
WEIBULL.DIST Weibull distribution.
Z.TEST One-tailed p-value of a z-test.
ZTEST Legacy form of Z.TEST.