---
title: Statistics
slug: statistics
docTags: 
createdAt: 2025-09-22T04:59:12.000Z
---

### AVEDEV

**Description: **Returns average deviation.

**Example: **

*AVEDEV(number1, number2, ...)*

### AVERAGE

**Description: **Returns the arithmetic mean.

**Example: **

*AVERAGE(number1, number2, ...)*

### AVERAGEA

**Description: **Returns the arithmetic mean.

**Example: **

*AVERAGEA(value1, value2,...)*

### AVERAGEIF

**Description: **Finds the average of the values in a given array that satisfy a given criteria, and returns the average value of the corresponding values in a second given array

**Example: **

*AVERAGEIF(range, criteria, average\_range)*

### AVERAGEIFS

**Description: **Finds the average of the values in a given array that satisfy a set of given criteria.

**Example: **

*AVERAGEIFS(average\_range, criteria\_range1, criteria1, \[criteria\_range2, criteria2], ...)*

### BINOMDIST

**Description: **Returns the cumulative beta probability density function.

**Example: **

*BINOMDIST(number\_s, trials, probability\_s, cumulative)*

### CHIDIST

**Description: **Returns the chi-squared distribution.

**Example: **

*CHIDIST(x, degrees\_freedom)*

### CHIINV

**Description: **Returns the inverse of Chidist.

**Example: **

*CHIINV(probability, degrees\_freedom)*

### CHITEST

**Description: **Returns the test for independence. CHITEST returns the value from the chi-squared (c2) distribution for the statistic and the appropriate degrees of freedom.

**Example: **

*CHITEST(actual\_range, expected\_range)*

### CONFIDENCE

**Description: **Returns the confidence interval.

**Example: **

*CONFIDENCE(alpha, standard\_dev,size)*

### CORREL

**Description: **Returns the correlation between two sets of data.

**Example: **

*CORREL(array1, array2)*

### COUNT

**Description: **Returns the count of the data listed in the arguments.

**Example: **

*COUNT(value1, value2,...)*

### COUNTA

**Description: **Returns the count of the data listed in the arguments.

**Example: **

*COUNTA(value1, value2,...)*

### COUNTBLANK

**Description: **Returns the count of the empty cells listed in the arguments.

**Example: **

*COUNTBLANK(range)*

### COUNTIF

**Description: **Returns the count of values that meet a specified criteria.

**Example: **

*COUNTIF(range, criteria)*

### COVAR

**Description: **Returns covariance.

**Example: **

*COVAR(array1, array2)*

### CRITBINOM

**Description: **Returns the critical value for the cumulative binomial distribution.

**Example: **

*CRITBINOM(trials, probability\_s, alpha)*

### DEVSQ

**Description: **Returns the sum of the squares of the mean deviation.

**Example: **

*DEVSQ(number1, number2,...)*

### EXPONDIST

**Description: **Returns the exponential distribution.

**Example: **

*EXPONDIST(x, lambda, cumulative)*

### FDIST

**Description: **Returns the F probability distribution.

**Example: **

*FDIST(x, degrees\_freedom1, degrees\_freedom2)*

### Finv

**Description: **Returns the inverse of Fdist.

**Example: **

*FINV(probability,deg\_freedom1,deg\_freedom2)*

### FISHER

**Description: **Returns the Fisher transformation.

**Example: **

*FISHER(x)*

### FISHERINV

**Description: **Returns the inverse of Fisher.

**Example: **

*FISHERINV(y)*

### FORECAST

**Description: **Returns the value forecasted by the linear trend.

**Example: **

*FORECAST(x, known\_ys, known\_xs)*

### GAMMADIST

**Description: **Returns the gamma distribution.

**Example: **

*GAMMADIST(x, alpha,beta, cumulative)*

### Gammainv

**Description: **Returns the inverse of Gammadist.

**Example: **

*Gammainv(p, alpha, beta)*

### GAMMALN

**Description: **Returns the natural logarithm of gamma function.

**Example: **

*GAMMALN(number)*

### GEOMEAN

**Description: **Returns the geometric mean.

**Example: **

*GEOMEAN(number1, number2,...)*

### GROWTH

**Description: **This feature enables you to calculate predicted exponential growth using existing data. This calculates and returns an array of values used for the regression analysis.

**Example: **

*GROWTH(known\_y's, \[known\_x's], \[new\_x's],*

### HARMEAN

**Description: **Returns the harmonic mean.

**Example: **

*HARMEAN(number1, number2,...)*

### HYPGEOM.DIST

**Description: **Returns the probability of a given number of sample successes, given the sample size, population successes and population size.

**Example: **

*HYPGEOM.DIST(sample\_s, number\_sample, population\_s, number\_population, cumulative)*

### HYPGEOMDIST

**Description: **Returns the hypergeometric distribution.

**Example: **

*HYPGEOMDIST(sample, numberofsample, population, numberofpopulation)*

### INTERCEPT

**Description: **Returns the Y intercept of the least squares fit line.

**Example: **

*INTERCEPT(known\_y's, known\_x's)*

### KURT

**Description: **Returns the kurtosis of the set of arguments.

**Example: **

*KURT(number1, number2, ...)*

### LARGE

**Description: **Returns the kth largest value.

**Example: **

*LARGE(array, k)*

### LOGEST

**Description: **This feature enables you to calculate predicted exponential growth using existing data. This calculates and returns an array of values used for the regression analysis.

**Example: **

*LOGEST(known\_y's, \[known\_x's], \[const], \[stats])*

### LOGINV

**Description: **Returns the inverse of the Lognormdist.

**Example: **

*LOGINV(probability, mean, standard\_dev)*

### LOGNORMDIST

**Description: **Returns the cumulative lognormal distribution function.

**Example: **

*LOGNORMDIST(x, mean, standard\_dev)*

### MAX

**Description: **Returns the largest value among the arguments.

**Example: **

*MAX(number1, number2, ...)*

### MAXA

**Description: **Returns the largest value among the arguments.

**Example: **

*MAXA(value1, value2, ...)*

### MEDIAN

**Description: **Returns the median value among the arguments.

**Example: **

*MEDIAN(number1, number2, ...)*

### MIN

**Description: **Returns the smallest value among the arguments.

**Example: **

*MIN(number1, number2, ...)*

### MINA

**Description: **Returns the smallest value among the arguments.

**Example: **

*MINA(value1, value2, ...)*

### MODE

**Description: **Returns the most frequently occurring value.

**Example: **

*MODE(number1, number2, ...)*

### NEGBINOMDIST

**Description: **Returns the negative binomial distribution.

**Example: **

*NEGBINOMDIST(number\_f, number\_s, probability\_s)*

### NORMDIST

**Description: **Returns the normal cumulative distribution.

**Example: **

*NORMDIST(x, mean, standard\_dev, cumulative)*

### NORMINV

**Description: **Returns the inverse of Normdist.

**Example: **

*NORMINV(probability, mean, standard\_dev)*

### NormsDist

**Description: **Returns the probability that the observed value of a standard normal random variable will be less than or equal to the parameter.

**Example: **

*NormsDist(value)*

### NormsInv

**Description: **Returns the standard normal random variable that has Mean 0 and Standard Deviation 1

**Example: **

*NormsDist(value)*

### PEARSON

**Description: **Returns the Pearson product.

**Example: **

*PEARSON(array1, array2)*

### PERCENTILE

**Description: **Returns the kth percentile of the given values.

**Example: **

*PERCENTILE(array, k)*

### PERCENTRANK

**Description: **Returns the position of a value in the range of values.

**Example: **

*PERCENTRANK(array, x, significance)*

### Permut

**Description: **Returns the number of permutations.

**Example: **

*Permut(n, k)*

### POISSON

**Description: **Returns the Poisson distribution.

**Example: **

*POISSON(x, mean, cumulative)*

### PROB

**Description: **Returns a probability.

**Example: **

*PROB(x\_range, prob\_range, lower\_limit, upper\_limit)*

### QUARTILE

**Description: **Returns which quarter a value belongs to within an ordered set of data.

**Example: **

*QUARTILE(array, quart)*

### RANK

**Description: **Returns the position of a value in an ordered list.

**Example: **

*RANK(number, ref, order)*

### RSQ

**Description: **Returns the square of the Pearson product moment correlation coefficients.

**Example: **

*RSQ(known\_y's, known\_x's)*

### SKEW

**Description: **Returns the skewness of a distribution.

**Example: **

*SKEW(number1, number2, ...)*

### SLOPE

**Description: **Returns the slope of the linear regression line.

**Example: **

*SLOPE(known\_y's, known\_x's)*

### SMALL

**Description: **Returns the kth smallest value.

**Example: **

*SMALL(array, k)*

### STANDARDIZE

**Description: **Returns the normalized value.

**Example: **

*STANDARDIZE(x, mean, standard\_dev)*

### STDEV

**Description: **Returns the sample standard deviation.

**Example: **

*STDEV(number1, number2, ...)*

### STDEVA

**Description: **Returns the sample standard deviation.

**Example: **

*STDEVA(value1, value2 , ...)*

### STDEVP

**Description: **Returns the population standard deviation.

**Example: **

*STDEVP(number1, number2, ...)*

### STDEVPA

**Description: **Returns the population standard deviation.

**Example: **

*STDEVPA(value1, value2, ...)*

### STEYX

**Description: **Returns the standard error.

**Example: **

*STEYX(known\_y's, known\_x's)*

### TRIMMEAN

**Description: **Returns the mean after removing out-liers.

**Example: **

*TRIMMEAN(array, percent)*

### Var

**Description: **Returns the sample variance.

**Example: **

*Var(number1, number2, ... number\_n)*

### VarA

**Description: **Returns the sample variance.

**Example: **

*VarA(value1, value2, ... value\_n)*

### VarP

**Description: **Returns the population variance.

**Example: **

*VarP(listofvalues)*

### VARPA

**Description: **Returns the population variance.

**Example: **

*VARPA(value1, value2, ...)*

### Weibull

**Description: **Returns the Weibull distribution.

**Example: **

*WEIBULL(x,alpha,beta,cumulative)*

### ZTEST

**Description: **Returns the P-value of a z-test.

**Example: **

*ZTEST(array, u0, sigma)*