- Excel Functions - Home
- Compatibility Functions
- Compatibility Functions
- BETADIST Function
- BETAINV Function
- BINOMDIST Function
- CEILING Function
- CHIDIST Function
- CHIINV Function
- CHITEST Function
- CONFIDENCE Function
- COVAR Function
- CRITBINOM Function
- EXPONDIST Function
- FDIST Function
- FINV Function
- FLOOR Function
- FTEST Function
- GAMMADIST Function
- GAMMAINV Function
- HYPGEOMDIST Function
- LOGINV Function
- LOGNORMDIST Function
- MODE Function
- NEGBINOMDIST Function
- NORMDIST Function
- NORMINV Function
- NORMSDIST Function
- NORMSINV Function
- PERCENTILE Function
- PERCENTRANK Function
- POISSON Function
- QUARTILE Function
- RANK Function
- STDEV Function
- STDEVP Function
- TDIST Function
- TINV Function
- TTEST Function
- VAR Function
- VARP Function
- WEIBULL Function
- ZTEST Function
- Logical Functions
- Logical Functions
- AND Function
- FALSE Function
- IF Function
- IFERROR Function
- IFNA Function
- IFS Function
- NOT Function
- OR Function
- SWITCH Function
- TRUE Function
- XOR Function
- Text Functions
- Text Functions
- ARRAYTOTEXT Function
- BAHTTEXT Function
- CHAR Function
- CLEAN Function
- CODE Function
- CONCAT Function
- CONCATENATE Function
- DBCS Function
- DOLLAR Function
- Exact Function
- FIND Function
- FINDB Function
- FIXED Function
- LEFT Function
- LEFTB Function
- LEN Function
- LENB Function
- LOWER Function
- MID Function
- MIDB Function
- NUMBERVALUE Function
- PHONETIC Function
- PROPER Function
- REPLACE Function
- REPLACEB Function
- REPT Function
- RIGHT Function
- RIGHTB Function
- SEARCH Function
- SEARCHB Function
- SUBSTITUTE Function
- T Function
- TEXT Function
- TEXTAFTER Function
- TEXTBEFORE Function
- TEXTJOIN Function
- TEXTSPLIT Function
- TRIM Function
- UNICHAR Function
- UNICODE Function
- UPPER Function
- VALUE Function
- VALUETOTEXT Function
- Date & Time Functions
- Date & Time Functions
- DATE Function
- DATEDIF Function
- DATEVALUE Function
- DAY Function
- DAYS Function
- DAYS360 Function
- EDATE Function
- EOMONTH Function
- HOUR Function
- ISOWEEKNUM Function
- MINUTE Function
- MONTH Function
- NETWORKDAYS Function
- NETWORKDAYS.INTL Function
- NOW Function
- SECOND Function
- TIME Function
- TIMEVALUE Function
- TODAY Function
- WEEKDAY Function
- WEEKNUM Function
- WORKDAY Function
- WORKDAY.INTL Function
- YEAR Function
- YEARFRAC Function
- Cube Functions
- Cube Functions
- CUBEKPIMEMBER Function
- CUBEMEMBER Function
- CUBEMEMBERPROPERTY Function
- CUBERANKEDMEMBER Function
- CUBESET Function
- CUBESETCOUNT Function
- CUBEVALUE Function
- Math Functions
- Math Functions
- ABS Function
- AGGREGATE Function
- ARABIC Function
- BASE Function
- CEILING.MATH Function
- COMBIN Function
- COMBINA Function
- DECIMAL Function
- DEGREES Function
- EVEN Function
- EXP Function
- FACT Function
- FACTDOUBLE Function
- FLOOR.MATH Function
- GCD Function
- INT Function
- LCM Function
- LN Function
- LOG Function
- LOG10 Function
- MDETERM Function
- MINVERSE Function
- MMULT Function
- MOD Function
- MROUND Function
- MULTINOMIAL Function
- MUNIT Function
- ODD Function
- PI Function
- POWER Function
- PRODUCT Function
- QUOTIENT Function
- RADIANS Function
- RAND Function
- RANDBETWEEN Function
- ROMAN Function
- ROUND Function
- ROUNDDOWN Function
- ROUNDUP Function
- SERIESSUM Function
- SIGN Function
- SQRT Function
- SQRTPI Function
- SUBTOTAL Function
- SUM Function
- SUMIF Function
- SUMIFS Function
- SUMPRODUCT Function
- SUMSQ Function
- SUMX2MY2 Function
- SUMX2PY2 Function
- SUMXMY2 Function
- TRUNC Function
- Trigonometric Functions
- Trigonometric Functions
- ACOS
- ACOSH Function
- ACOT Function
- ACOTH Function
- ASIN Function
- ASINH Function
- ATAN Function
- ATAN2 Function
- ATANH Function
- COS Function
- COSH Function
- COT Function
- COTH Function
- CSC Function
- CSCH Function
- SEC Function
- SECH Function
- SIN Function
- SINH Function
- TAN Function
- TANH Function
- Database Functions
- Database Functions
- DAVERAGE
- DCOUNT
- DCOUNTA
- DGET
- DMAX
- DMIN
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DVAR
- DVARP
- Dynamic Array Functions
- Dynamic Array Functions
- FILTER Function
- RANDARRAY Function
- SEQUENCE Function
- SORT Function
- SORTBY Function
- UNIQUE Function
- XLOOKUP Function
- XMATCH Function
- Engineering Functions
- Engineering Functions
- BESSELI Function
- BESSELJ Function
- BESSELK Function
- BESSELY Function
- BIN2DEC Function
- BIN2HEX Function
- BIN2OCT Function
- BITAND Function
- BITLSHIFT Function
- BITOR Function
- BITRSHIFT Function
- BITXOR Function
- COMPLEX Function
- CONVERT Function
- DEC2BIN Function
- DEC2HEX Function
- DEC2OCT Function
- DELTA Function
- ERF Function
- ERF.PRECISE Function
- ERFC Function
- ERFC.PRECISE Function
- GESTEP Function
- HEX2BIN Function
- HEX2DEC Function
- HEX2OCT Function
- IMABS Function
- IMAGINARY Function
- IMARGUMENT Function
- IMCONJUGATE Function
- IMCOS Function
- IMCOSH Function
- IMCOT Function
- IMCSC Function
- IMCSCH Function
- IMDIV Function
- IMEXP Function
- IMLN Function
- IMLOG2 Function
- IMLOG10 Function
- IMPOWER Function
- IMPRODUCT Function
- IMREAL Function
- IMSEC Function
- IMSECH Function
- IMSIN Function
- IMSINH Function
- IMSQRT Function
- IMSUB Function
- IMSUM Function
- IMTAN Function
- OCT2BIN Function
- OCT2DEC Function
- OCT2HEX Function
- Financial Functions
- Financial Functions
- ACCRINT Function
- ACCRINTM Function
- AMORDEGRC Function
- AMORLINC Function
- COUPDAYBS Function
- COUPDAYS Function
- COUPDAYSNC Function
- COUPNCD Function
- COUPNUM Function
- COUPPCD Function
- CUMIPMT Function
- CUMPRINC Function
- DB Function
- DDB Function
- DISC Function
- DOLLARDE Function
- DOLLARFR Function
- DURATION Function
- EFFECT Function
- FV Function
- FVSCHEDULE Function
- INTRATE Function
- IPMT Function
- IRR Function
- ISPMT Function
- MDURATION Function
- MIRR Function
- NOMINAL Function
- NPER Function
- NPV Function
- ODDFPRICE Function
- ODDFYIELD Function
- ODDLPRICE Function
- ODDLYIELD Function
- PDURATION Function
- PMT Function
- PPMT Function
- PRICE Function
- PRICEDISC Function
- PRICEMAT Function
- PV Function
- RATE Function
- RECEIVED Function
- RRI Function
- SLN Function
- SYD Function
- TBILLEQ Function
- TBILLPRICE Function
- TBILLYIELD Function
- VDB Function
- XIRR Function
- XNPV Function
- YIELD Function
- YIELDDISC Function
- YIELDMAT Function
- Information Functions
- Information Functions
- CELL Function
- ERROR.TYPE Function
- INFO Function
- ISBLANK Function
- ISERR Function
- ISERROR Function
- ISEVEN Function
- ISFORMULA Function
- ISLOGICAL Function
- ISNA Function
- ISNONTEXT Function
- ISNUMBER Function
- ISODD Function
- ISREF Function
- ISTEXT Function
- N Function
- NA Function
- SHEET Function
- SHEETS Function
- TYPE Function
- Lookup & Reference Functions
- Lookup & Reference Functions
- ADDRESS Function
- AREAS Function
- CHOOSE Function
- COLUMN Function
- COLUMNS Function
- FORMULATEXT Function
- GETPIVOTDATA Function
- HLOOKUP Function
- HYPERLINK Function
- INDEX Function
- INDIRECT Function
- LOOKUP Function
- MATCH Function
- OFFSET Function
- ROW Function
- ROWS Function
- RTD Function
- TRANSPOSE Function
- VLOOKUP Function
- Statistical Functions
- Statistical Functions
- AVEDEV Function
- AVERAGE Function
- AVERAGEA Function
- AVERAGEIF Function
- AVERAGEIFS Function
- BETA.DIST Function
- BETA.INV Function
- BINOM.DIST Function
- BINOM.DIST.RANGE Function
- BINOM.INV Function
- CHISQ.DIST Function
- CHISQ.DIST.RT Function
- CHISQ.INV Function
- CHISQ.INV.RT Function
- CHISQ.TEST Function
- CONFIDENCE.NORM Function
- CONFIDENCE.T Function
- CORREL Function
- COUNT Function
- COUNTA Function
- COUNTBLANK Function
- COUNTIF Function
- COUNTIFS Function
- COVARIANCE.P Function
- COVARIANCE.S Function
- DEVSQ Function
- EXPON.DIST Function
- F.DIST Function
- F.DIST.RT Function
- F.INV Function
- F.INV.RT Function
- F.TEST Function
- FISHER Function
- FISHERINV Function
- FORECAST Function
- FORECAST.ETS Function
- FORECAST.ETS.CONFINT Function
- FORECAST.ETS.SEASONALITY Function
- FORECAST.ETS.STAT Function
- FORECAST.LINEAR Function
- FREQUENCY Function
- GAMMA Function
- GAMMA.DIST Function
- GAMMA.INV Function
- GAMMALN Function
- GAMMALN.PRECISE Function
- GAUSS Function
- GEOMEAN
- GROWTH
- HARMEAN
- HYPGEOM.DIST
- INTERCEPT Function
- KURT Function
- LARGE Function
- LINEST Function
- LOGEST Function
- LOGNORM.DIST Function
- LOGNORM.INV Function
- MAX Function
- MAXA Function
- MAXIFS Function
- MEDIAN Function
- MIN Function
- MINA Function
- MINIFS Function
- MODE.MULT Function
- MODE.SNGL Function
- NEGBINOM.DIST Function
- NORM.DIST Function
- NORM.INV Function
- NORM.S.DIST Function
- NORM.S.INV Function
- PEARSON Function
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK.EXC
- PERCENTRANK.INC
- PERMUT
- PERMUTATIONA
- PHI
- POISSON.DIST
- PROB
- QUARTILE.EXC
- QUARTILE.INC
- RANK.AVG
- RANK.EQ
- RSQ
- SKEW
- SKEW.P
- SLOPE
- SMALL
- STANDARDIZE
- STDEV.P
- STDEV.S
- STDEVA
- STDEVPA
- STEYX
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- TREND
- TRIMMEAN Function
- VAR.P Function
- VAR.S Function
- VARA Function
- VARPA Function
- WEIBULL.DIST Function
- Z.TEST Function
- Web Functions
- Web Functions
- ENCODEURL Function
- FILTERXML Function
- WEBSERVICE Function
Excel - Statistical Functions
Statistical functions perform calculations ranging from basic mean, median & mode to the more complex statistical distribution and probability tests.
Statistical Functions
The following table lists all the Statistical functions −
| Sr.No. | Function and Description |
|---|---|
| 1 | AVEDEV
Returns the average of the absolute deviations of data points from their mean |
| 2 | AVERAGE
Returns the average of its arguments |
| 3 | AVERAGEA
Returns the average of its arguments and includes evaluation of text and logical values |
| 4 | AVERAGEIF
Returns the average for the cells specified by a given criterion |
| 5 | AVERAGEIFS
Returns the average for the cells specified by multiple criteria |
| 6 | BETA.DIST
Returns the beta cumulative distribution function |
| 7 | BETA.INV
Returns the inverse of the cumulative distribution function for a specified beta distribution |
| 8 | BINOM.DIST
Returns the individual term binomial distribution probability |
| 9 | BINOM.DIST.RANGE
Returns the probability of a trial result using a binomial distribution |
| 10 | BINOM.INV
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
| 11 | CHISQ.DIST
Returns the cumulative beta probability density function |
| 12 | CHISQ.DIST.RT
Returns the one-tailed probability of the chi-squared distribution |
| 13 | CHISQ.INV
Returns the cumulative beta probability density function |
| 14 | CHISQ.INV.RT
Returns the inverse of the one-tailed probability of the chi-squared distribution |
| 15 | CHISQ.TEST
Returns the test for independence |
| 16 | CONFIDENCE.NORM
Returns the confidence interval for a population mean |
| 17 | CONFIDENCE.T
Returns the confidence interval for a population mean, using a Student's t distribution |
| 18 | CORREL
Returns the correlation coefficient between two data sets |
| 19 | COUNT
Counts how many numbers are in the list of arguments |
| 20 | COUNTA
Counts how many values are in the list of arguments |
| 21 | COUNTBLANK
Counts the number of blank cells in the argument range |
| 22 | COUNTIF
Counts the number of cells that meet the criteria you specify in the argument |
| 23 | COUNTIFS
Counts the number of cells that meet multiple criteria |
| 24 | COVARIANCE.P
Returns covariance, the average of the products of paired deviations |
| 25 | COVARIANCE.S
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets |
| 26 | DEVSQ
Returns the sum of squares of deviations |
| 27 | EXPON.DIST
Returns the exponential distribution |
| 28 | F.DIST
Returns the F probability distribution |
| 29 | F.DIST.RT
Returns the F probability distribution |
| 30 | F.INV
Returns the inverse of the F probability distribution |
| 31 | F.INV.RT
Returns the inverse of the F probability distribution |
| 32 | F.TEST
Returns the result of an F-test |
| 33 | FISHER
Returns the Fisher transformation |
| 34 | FISHERINV
Returns the inverse of the Fisher transformation |
| 35 | FORECAST
Returns a value along a linear trend |
| 36 | FORECAST.ETS
Calculates a future value based on existing values using the Exponential Triple Smoothing (ETS) algorithm |
| 37 | FORECAST.ETS.CONFINT
Returns a confidence interval for the forecast value at the specified target date |
| 38 | FORECAST.ETS.SEASONALITY
Returns the length of the repetitive pattern detected for the specified time series |
| 39 | FORECAST.ETS.STAT
Returns a statistical value as a result of time series forecasting |
| 40 | FORECAST.LINEAR
Calculates a future value by using existing values, using linear regression. |
| 41 | FREQUENCY
Returns a frequency distribution as a vertical array |
| 42 | GAMMA
Returns the Gamma function value |
| 43 | GAMMA.DIST
Returns the gamma distribution |
| 44 | GAMMA.INV
Returns the inverse of the gamma cumulative distribution |
| 45 | GAMMALN
Returns the natural logarithm of the gamma function, G(x) |
| 46 | GAMMALN.PRECISE
Returns the natural logarithm of the gamma function, G(x) |
| 47 | GAUSS
Returns 0.5 less than the standard normal cumulative distribution |
| 48 | GEOMEAN
Returns the geometric mean |
| 49 | GROWTH
Returns values along an exponential trend |
| 50 | HARMEAN
Returns the harmonic mean |
| 51 | HYPGEOM.DIST
Returns the hypergeometric distribution |
| 52 | INTERCEPT
Returns the intercept of the linear regression line |
| 53 | KURT
Returns the kurtosis of a data set |
| 54 | LARGE
Returns the kth largest value in a data set |
| 55 | LINEST
Returns the parameters of a linear trend |
| 56 | LOGEST
Returns the parameters of an exponential trend |
| 57 | LOGNORM.DIST
Returns the cumulative lognormal distribution |
| 58 | LOGNORM.INV
Returns the inverse of the lognormal cumulative distribution |
| 59 | MAX
Returns the maximum value in a list of arguments, ignoring logical values and text |
| 60 | MAXA
Returns the maximum value in a list of arguments, including logical values and text |
| 61 | MAXIFS
Returns the maximum value among cells specified by a given set of conditions or criteria. |
| 62 | MEDIAN
Returns the median of the given numbers |
| 63 | MIN
Returns the minimum value in a list of arguments, ignoring logical values and text |
| 64 | MINA
Returns the minimum value in a list of arguments, including logical values and text |
| 65 | MINIFS
Returns the minimum value among cells specified by a given set of conditions or criteria. |
| 66 | MODE.MULT
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data |
| 67 | MODE.SNGL
Returns the most common value in a data set |
| 68 | NEGBINOM.DIST
Returns the negative binomial distribution |
| 69 | NORM.DIST
Returns the normal cumulative distribution |
| 70 | NORM.INV
Returns the inverse of the normal cumulative distribution |
| 71 | NORM.S.DIST
Returns the standard normal cumulative distribution |
| 72 | NORM.S.INV
Returns the inverse of the standard normal cumulative distribution |
| 73 | PEARSON
Returns the Pearson product moment correlation coefficient |
| 74 | PERCENTILE.EXC
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive |
| 75 | PERCENTILE.INC
Returns the k-th percentile of values in a range |
| 76 | PERCENTRANK.EXC
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set |
| 77 | PERCENTRANK.INC
Returns the percentage rank of a value in a data set |
| 78 | PERMUT
Returns the number of permutations for a given number of objects |
| 79 | PERMUTATIONA
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |
| 80 | PHI
Returns the value of the density function for a standard normal distribution |
| 81 | POISSON.DIST
Returns the Poisson distribution |
| 82 | PROB
Returns the probability that values in a range are between two limits |
| 83 | QUARTILE.EXC
Returns the quartile of the data set, based on percentile values from 0..1, exclusive |
| 84 | QUARTILE.INC
Returns the quartile of a data set |
| 85 | RANK.AVG
Returns the rank of a number in a list of numbers |
| 86 | RANK.EQ
Returns the rank of a number in a list of numbers |
| 87 | RSQ
Returns the square of the Pearson product moment correlation coefficient |
| 88 | SKEW
Returns the skewness of a distribution |
| 89 | SKEW.P
Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean |
| 90 | SLOPE
Returns the slope of the linear regression line |
| 91 | SMALL
Returns the kth smallest value in a data set |
| 92 | STANDARDIZE
Returns a normalized value |
| 93 | STDEV.P
Calculates standard deviation based on the entire population |
| 94 | STDEV.S
Estimates standard deviation based on a sample |
| 95 | STDEVA
Estimates standard deviation based on a sample, including text and logical values |
| 96 | STDEVPA
Calculates standard deviation based on the entire population, including text and logical values |
| 97 | STEYX
Returns the standard error of the predicted y-value for each x in the regression |
| 98 | T.DIST
Returns the Percentage Points (probability) for the Student t-distribution |
| 99 | T.DIST.2T
Returns the Percentage Points (probability) for the Student t-distribution |
| 100 | T.DIST.RT
Returns the Student's t-distribution |
| 101 | T.INV
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom |
| 102 | T.INV.2T
Returns the inverse of the Student's t-distribution |
| 103 | T.TEST
Returns the probability associated with a Student's t-test |
| 104 | TREND
Returns values along a linear trend |
| 105 | TRIMMEAN
Returns the mean of the interior of a data set |
| 106 | VAR.P
Calculates variance based on the entire population |
| 107 | VAR.S
Estimates variance based on a sample |
| 108 | VARA
Estimates variance based on a sample, including logical values and text |
| 109 | VARPA
Calculates variance based on the entire population, including logical values and text |
| 110 | WEIBULL.DIST
Returns the Weibull distribution |
| 111 | Z.TEST
Returns the one-tailed probability-value of a z-test |