Statistical Functions
| AVEDEV | The average deviation of the numbers in a list, table or cell range. |
| AVERAGE | The arithmetic mean of the values in a list, range or array. |
| AVERAGEA | The arithmetic mean of the values in a list, range or array (including logical values and text). |
| AVERAGEIF | (AVERAGEIFS) The arithmetic mean of all the numbers in a range that satisfies one condition. |
| AVERAGEIFS | The arithmetic mean of all the numbers in a range that satisfies multiple conditions. |
| BETA.DIST | The probability of getting a specific value between 0 and 1 for different distribution shapes. |
| BETA.INV | The inverse of the cumulative probability function for a beta distribution. |
| BETADIST | (BETA.DIST) The cumulative probability function for a beta distribution (only cumulative). |
| BETAINV | (BETA.INV) The inverse of the probability distribution function for a beta distribution. |
| BINOM.DIST | The probability of getting a specific number of successes using a binomial distribution. |
| BINOM.DIST.RANGE | (2013) The probability of a trial result using a binomial distribution. |
| BINOM.INV | The number of trials needed for a specific amount of success using a binomial distribution. |
| BINOMDIST | (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |
| CHIDIST | (CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHIINV | (CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed). |
| CHISQ.DIST | The probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed). |
| CHISQ.DIST.RT | The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHISQ.INV | The inverse of the probability distribution function for a chi-squared distribution (left tailed). |
| CHISQ.INV.RT | The inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHISQ.TEST | The probability value from a chi-squared distribution. |
| CHITEST | (CHISQ.TEST) The probability value from a chi-squared distribution. |
| CONFIDENCE | (CONFIDENCE.NORM) The confidence interval for a population mean. |
| CONFIDENCE.NORM | The confidence interval for a population mean. |
| CONFIDENCE.T | The confidence interval for a population mean using a t distribution. |
| CORREL | The correlation coefficient between two data sets. |
| COUNT | The number of values in a list, range or array. |
| COUNTA | The number of values in a list, range or array (including logical values and text). |
| COUNTBLANK | The number of blank cells in a list, table or range. |
| COUNTIF | (COUNTIFS) The number of numerical values in a range that satisfies one condition. |
| COUNTIFS | The number of numerical values in a range that satisfies multiple conditions. |
| COVAR | (COVARIANCE.P) The average of the products of deviations for each data point pair. |
| COVARIANCE.P | The covariance based on an entire population. |
| COVARIANCE.S | The covariance based on a sample. |
| CRITBINOM | (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |
| DEVSQ | The sum of the squared deviations from the mean. |
| EXPON.DIST | The probability distribution function OR the cumulative probability function for an exponential distribution. |
| EXPONDIST | (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution. |
| F.DIST | The probability distribution function OR the cumulative probability function for an f distribution (left tailed). |
| F.DIST.RT | The probability distribution function for an f distribution (right tailed) (no cumulative). |
| F.INV | The inverse of the probability distribution function for an f distribution (left tailed). |
| F.INV.RT | The inverse of the probability distribution function for an f distribution (right tailed). |
| F.TEST | The probability value from an f distribution. |
| FDIST | (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |
| FINV | (F.INV) The inverse of the probability distribution function for an f distribution (left tailed). |
| FISHER | The fisher transformation. |
| FISHERINV | The inverse of the fisher transformation. |
| FORECAST | (FORECAST.LINEAR) The future y-value along a linear trend using existing values. |
| FORECAST.ETS | (2016) The future value based on historical values. |
| FORECAST.LINEAR | (2016) The future y-value along a linear trend using existing values. |
| FREQUENCY | The number of times a particular value occurs in a list, table or cell range. |
| FTEST | (F.TEST) The probability value from an f distribution. |
| GAMMA | (2013) The gamma function value. |
| GAMMA.DIST | The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMA.INV | The inverse of the cumulative probability function for a gamma distribution. |
| GAMMADIST | (GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMAINV | (GAMMA.INV) The inverse of the probability distribution for a gamma distribution. |
| GAMMALN | (GAMMALN.PRECISE) The natural logarithm of the gamma function. |
| GAMMALN.PRECISE | The natural logarithm of the gamma function. |
| GAUSS | (2013) The 0.5 less than the standard normal cumulative distribution. |
| GEOMEAN | The geometric mean of an array of numbers. |
| GROWTH | The predicted exponential growth using existing data. |
| HARMEAN | The harmonic mean of a data set. |
| HYPGEOM.DIST | The probability distribution functon OR the cumulative probability function for a hypergeometric distribution. |
| HYPGEOMDIST | (HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative). |
| INTERCEPT | The intersection with the y-axis using a linear regression plotted through known values. |
| KURT | The kurtosis for a list or array of numbers. |
| LARGE | The kth largest value in a list or array of numbers. |
| LINEST | The array of values for a straight line that best fits your data. |
| LOGEST | The array of values for an exponential curve that best fits your data. |
| LOGINV | (LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution. |
| LOGNORM.DIST | The probability distribution function OR the cumulative probability function for a lognormal distribution. |
| LOGNORM.INV | The inverse of the probability distribution function for a lognormal distribution. |
| LOGNORMDIST | (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |
| MAX | The largest value in a list, range or array. |
| MAXA | The largest value in a list, range or array (including logical values and text). |
| MAXIFS | (2019) The largest value in a list, range or array that satisfies multiple conditions. |
| MEDIAN | The median value in a list or array of numbers. |
| MIN | The smallest value in a list, range or array. |
| MINA | The smallest value in a list, range or array (including logical values and text). |
| MINIFS | (2019) The smallest value in a list, range or array that satisfies multiple conditions. |
| MODE | (MODE.SNGL) The value that occurs most frequently in a list or array of numbers. |
| MODE.MULT | The array of most frequent or repetitive values. |
| MODE.SNGL | The value that occurs most frequently in a list or array of numbers. |
| NEGBINOM.DIST | The probability distribution function OR the cumulative probability function for a negative binomial distribution. |
| NEGBINOMDIST | (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
| NORM.DIST | The probability distribution function OR the cumulative probability function for a normal distribution. |
| NORM.INV | The inverse of the probability distribution function for a normal distribution. |
| NORM.S.DIST | The probability distribution function OR the cumulative probability function for a standard normal distribution. |
| NORM.S.INV | The inverse of the probability distribution function for a standard normal distribution. |
| NORMDIST | (NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution. |
| NORMINV | (NORM.INV) The inverse of the probability distribution function for a normal distribution. |
| NORMSDIST | (NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative). |
| NORMSINV | (NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution. |
| PEARSON | The pearson product moment correlation coefficient. |
| PERCENTILE | (PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive). |
| PERCENTILE.EXC | The number corresponding to a particular percentage from an array of numbers (exclusive). |
| PERCENTILE.INC | The number corresponding to a particular percentage from an array of numbers (inclusive). |
| PERCENTRANK | (PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive). |
| PERCENTRANK.EXC | The percentage rank of a value in an array of numbers (exclusive). |
| PERCENTRANK.INC | The percentage rank of a value in an array of numbers (inclusive). |
| PERMUT | The number of permutations for a subset of objects or events. |
| PERMUTATIONA | (2013) The number of permutations for a subset of objects or events (with repetition). |
| PHI | (2013) The value of the density function for a standard normal distribution. |
| POISSON | (POISSON.DIST) The probability distribution function OR the cumulative probability function for a poisson distribution. |
| POISSON.DIST | The probability distribution function OR the cumulative probability function for a poisson distribution. |
| PROB | The probability that values in a range are between two limits. |
| QUARTILE | (QUARTILE.INC) The quartile of a data set (inclusive). |
| QUARTILE.EXC | The quartile of a data set (exclusive). |
| QUARTILE.INC | The quartile of a data set (inclusive). |
| RANK | (RANK.EQ) The rank of a value in a list, table or cell range (in descending order) (equal ranking). |
| RANK.AVG | The rank of a value in a list, table or cell range (in descending order) (average ranking). |
| RANK.EQ | The rank of a value in a list, table or cell range (in descending order) (equal ranking). |
| RSQ | The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
| SKEW | The number representing the skewness of a distribution based on a sample. |
| SKEW.P | (2013) The number representing the skewness of a distribution based on an entire population. |
| SLOPE | The slope of a linear regression line through the given data points. |
| SMALL | The kth smallest value in a list or array of numbers. |
| STANDARDIZE | The normalized value from a distributed characterised by a mean and a standard deviation. |
| STDEV | (STDEV.S) The standard deviation based on a sample. |
| STDEV.P | The standard deviation based on an entire population. |
| STDEV.S | The standard deviation based on a sample. |
| STDEVA | The standard deviation based on a sample (including logical values and text). |
| STDEVP | (STDEV.P) The standard deviation based on an entire population. |
| STDEVPA | The standard deviation based on an entire population (including logical values and text). |
| STEYX | The standard error of a regression. |
| T.DIST | The probability distribution function for a t distribution (left tailed). |
| T.DIST.2T | The probability distribution function for a two tailed distribution (no cumulative). |
| T.DIST.RT | The probability distribution function for a t distribution (right tailed) (no cumulative). |
| T.INV | The inverse of the probability distribution function for a t distribution (left tailed) |
| T.INV.2T | The inverse of the probability distribution function for a two tailed distribution. |
| T.TEST | The probability value from a t distribution. |
| TDIST | (T.DIST.2T) The percentage points probability for the t distribution. |
| TINV | (T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom. |
| TREND | The y-values along a linear trend given a set of x-values. |
| TRIMMEAN | The mean of the interior of a data set. |
| TTEST | (T.TEST) The probability value from a t distribution. |
| VAR | (VAR.S) The variance based on a sample. |
| VAR.P | The variance based on an entire population. |
| VAR.S | The variance based on a sample. |
| VARA | The variance based on a sample (including logical values and text). |
| VARP | (VAR.P) The variance based on an entire population. |
| VARPA | The variance based on an entire population (including logical values and text). |
| WEIBULL | (WEIBULL.DIST) The probability distribution function OR the cumulative probability function for a weibull distribution. |
| WEIBULL.DIST | The probability distribution function OR the cumulative probability function for a weibull distribution. |
| Z.TEST | The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
| ZTEST | (Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
| AVEDEV The average deviation of the numbers in a list, table or cell range. |
| AVERAGE The arithmetic mean of the values in a list, range or array. |
| AVERAGEA The arithmetic mean of the values in a list, range or array (including logical values and text). |
| AVERAGEIF (AVERAGEIFS) The arithmetic mean of all the numbers in a range that satisfies one condition. |
| AVERAGEIFS The arithmetic mean of all the numbers in a range that satisfies multiple conditions. |
| BETA.DIST The probability of getting a specific value between 0 and 1 for different distribution shapes. |
| BETA.INV The inverse of the cumulative probability function for a beta distribution. |
| BETADIST (BETA.DIST) The cumulative probability function for a beta distribution (only cumulative). |
| BETAINV (BETA.INV) The inverse of the probability distribution function for a beta distribution. |
| BINOM.DIST The probability of getting a specific number of successes using a binomial distribution. |
| BINOM.DIST.RANGE (2013) The probability of a trial result using a binomial distribution. |
| BINOM.INV The number of trials needed for a specific amount of success using a binomial distribution. |
| BINOMDIST (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |
| CHIDIST (CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHIINV (CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed). |
| CHISQ.DIST The probability distribution function OR the cumulative probability function for a chi-squared distribution (left tailed). |
| CHISQ.DIST.RT The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHISQ.INV The inverse of the probability distribution function for a chi-squared distribution (left tailed). |
| CHISQ.INV.RT The inverse of the probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHISQ.TEST The probability value from a chi-squared distribution. |
| CHITEST (CHISQ.TEST) The probability value from a chi-squared distribution. |
| CONFIDENCE (CONFIDENCE.NORM) The confidence interval for a population mean. |
| CONFIDENCE.NORM The confidence interval for a population mean. |
| CONFIDENCE.T The confidence interval for a population mean using a t distribution. |
| CORREL The correlation coefficient between two data sets. |
| COUNT The number of values in a list, range or array. |
| COUNTA The number of values in a list, range or array (including logical values and text). |
| COUNTBLANK The number of blank cells in a list, table or range. |
| COUNTIF (COUNTIFS) The number of numerical values in a range that satisfies one condition. |
| COUNTIFS The number of numerical values in a range that satisfies multiple conditions. |
| COVAR (COVARIANCE.P) The average of the products of deviations for each data point pair. |
| COVARIANCE.P The covariance based on an entire population. |
| COVARIANCE.S The covariance based on a sample. |
| CRITBINOM (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |
| DEVSQ The sum of the squared deviations from the mean. |
| EXPON.DIST The probability distribution function OR the cumulative probability function for an exponential distribution. |
| EXPONDIST (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution. |
| F.DIST The probability distribution function OR the cumulative probability function for an f distribution (left tailed). |
| F.DIST.RT The probability distribution function for an f distribution (right tailed) (no cumulative). |
| F.INV The inverse of the probability distribution function for an f distribution (left tailed). |
| F.INV.RT The inverse of the probability distribution function for an f distribution (right tailed). |
| F.TEST The probability value from an f distribution. |
| FDIST (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |
| FINV (F.INV) The inverse of the probability distribution function for an f distribution (left tailed). |
| FISHER The fisher transformation. |
| FISHERINV The inverse of the fisher transformation. |
| FORECAST (FORECAST.LINEAR) The future y-value along a linear trend using existing values. |
| FORECAST.ETS (2016) The future value based on historical values. |
| FORECAST.LINEAR (2016) The future y-value along a linear trend using existing values. |
| FREQUENCY The number of times a particular value occurs in a list, table or cell range. |
| FTEST (F.TEST) The probability value from an f distribution. |
| GAMMA (2013) The gamma function value. |
| GAMMA.DIST The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMA.INV The inverse of the cumulative probability function for a gamma distribution. |
| GAMMADIST (GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMAINV (GAMMA.INV) The inverse of the probability distribution for a gamma distribution. |
| GAMMALN (GAMMALN.PRECISE) The natural logarithm of the gamma function. |
| GAMMALN.PRECISE The natural logarithm of the gamma function. |
| GAUSS (2013) The 0.5 less than the standard normal cumulative distribution. |
| GEOMEAN The geometric mean of an array of numbers. |
| GROWTH The predicted exponential growth using existing data. |
| HARMEAN The harmonic mean of a data set. |
| HYPGEOM.DIST The probability distribution functon OR the cumulative probability function for a hypergeometric distribution. |
| HYPGEOMDIST (HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative). |
| INTERCEPT The intersection with the y-axis using a linear regression plotted through known values. |
| KURT The kurtosis for a list or array of numbers. |
| LARGE The kth largest value in a list or array of numbers. |
| LINEST The array of values for a straight line that best fits your data. |
| LOGEST The array of values for an exponential curve that best fits your data. |
| LOGINV (LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution. |
| LOGNORM.DIST The probability distribution function OR the cumulative probability function for a lognormal distribution. |
| LOGNORM.INV The inverse of the probability distribution function for a lognormal distribution. |
| LOGNORMDIST (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |
| MAX The largest value in a list, range or array. |
| MAXA The largest value in a list, range or array (including logical values and text). |
| MAXIFS (2019) The largest value in a list, range or array that satisfies multiple conditions. |
| MEDIAN The median value in a list or array of numbers. |
| MIN The smallest value in a list, range or array. |
| MINA The smallest value in a list, range or array (including logical values and text). |
| MINIFS (2019) The smallest value in a list, range or array that satisfies multiple conditions. |
| MODE (MODE.SNGL) The value that occurs most frequently in a list or array of numbers. |
| MODE.MULT The array of most frequent or repetitive values. |
| MODE.SNGL The value that occurs most frequently in a list or array of numbers. |
| NEGBINOM.DIST The probability distribution function OR the cumulative probability function for a negative binomial distribution. |
| NEGBINOMDIST (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
| NORM.DIST The probability distribution function OR the cumulative probability function for a normal distribution. |
| NORM.INV The inverse of the probability distribution function for a normal distribution. |
| NORM.S.DIST The probability distribution function OR the cumulative probability function for a standard normal distribution. |
| NORM.S.INV The inverse of the probability distribution function for a standard normal distribution. |
| NORMDIST (NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution. |
| NORMINV (NORM.INV) The inverse of the probability distribution function for a normal distribution. |
| NORMSDIST (NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative). |
| NORMSINV (NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution. |
| PEARSON The pearson product moment correlation coefficient. |
| PERCENTILE (PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive). |
| PERCENTILE.EXC The number corresponding to a particular percentage from an array of numbers (exclusive). |
| PERCENTILE.INC The number corresponding to a particular percentage from an array of numbers (inclusive). |
| PERCENTRANK (PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive). |
| PERCENTRANK.EXC The percentage rank of a value in an array of numbers (exclusive). |
| PERCENTRANK.INC The percentage rank of a value in an array of numbers (inclusive). |
| PERMUT The number of permutations for a subset of objects or events. |
| PERMUTATIONA (2013) The number of permutations for a subset of objects or events (with repetition). |
| PHI (2013) The value of the density function for a standard normal distribution. |
| POISSON (POISSON.DIST) The probability distribution function OR the cumulative probability function for a poisson distribution. |
| POISSON.DIST The probability distribution function OR the cumulative probability function for a poisson distribution. |
| PROB The probability that values in a range are between two limits. |
| QUARTILE (QUARTILE.INC) The quartile of a data set (inclusive). |
| QUARTILE.EXC The quartile of a data set (exclusive). |
| QUARTILE.INC The quartile of a data set (inclusive). |
| RANK (RANK.EQ) The rank of a value in a list, table or cell range (in descending order) (equal ranking). |
| RANK.AVG The rank of a value in a list, table or cell range (in descending order) (average ranking). |
| RANK.EQ The rank of a value in a list, table or cell range (in descending order) (equal ranking). |
| RSQ The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
| SKEW The number representing the skewness of a distribution based on a sample. |
| SKEW.P (2013) The number representing the skewness of a distribution based on an entire population. |
| SLOPE The slope of a linear regression line through the given data points. |
| SMALL The kth smallest value in a list or array of numbers. |
| STANDARDIZE The normalized value from a distributed characterised by a mean and a standard deviation. |
| STDEV (STDEV.S) The standard deviation based on a sample. |
| STDEV.P The standard deviation based on an entire population. |
| STDEV.S The standard deviation based on a sample. |
| STDEVA The standard deviation based on a sample (including logical values and text). |
| STDEVP (STDEV.P) The standard deviation based on an entire population. |
| STDEVPA The standard deviation based on an entire population (including logical values and text). |
| STEYX The standard error of a regression. |
| T.DIST The probability distribution function for a t distribution (left tailed). |
| T.DIST.2T The probability distribution function for a two tailed distribution (no cumulative). |
| T.DIST.RT The probability distribution function for a t distribution (right tailed) (no cumulative). |
| T.INV The inverse of the probability distribution function for a t distribution (left tailed) |
| T.INV.2T The inverse of the probability distribution function for a two tailed distribution. |
| T.TEST The probability value from a t distribution. |
| TDIST (T.DIST.2T) The percentage points probability for the t distribution. |
| TINV (T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom. |
| TREND The y-values along a linear trend given a set of x-values. |
| TRIMMEAN The mean of the interior of a data set. |
| TTEST (T.TEST) The probability value from a t distribution. |
| VAR (VAR.S) The variance based on a sample. |
| VAR.P The variance based on an entire population. |
| VAR.S The variance based on a sample. |
| VARA The variance based on a sample (including logical values and text). |
| VARP (VAR.P) The variance based on an entire population. |
| VARPA The variance based on an entire population (including logical values and text). |
| WEIBULL (WEIBULL.DIST) The probability distribution function OR the cumulative probability function for a weibull distribution. |
| WEIBULL.DIST The probability distribution function OR the cumulative probability function for a weibull distribution. |
| Z.TEST The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
| ZTEST (Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top