Statistical
★ 90 · ◉ 76 · All versions
=MAX()
Returns the largest value in a set of values.
=MAX(number1, [number2], ...)
Daily Tasks
Reporting
Descriptive Statistics
42 functions for this use case · out of 12 defined
Statistical
★ 90 · ◉ 72 · All versions
=MIN()
Returns the smallest number in a set of values.
=MIN(number1, [number2], ...)
Daily Tasks
Reporting
Compatibility
★ 30 · ◉ 58 · All versions
=STDEV()
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
=STDEV(number1,[number2],...)
Descriptive Statistics
Statistical
★ 15 · ◉ 52 · All versions
=AVEDEV()
Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.
=AVEDEV(number1, [number2], ...)
Descriptive Statistics
Statistical
★ 75 · ◉ 52 · All versions
=COUNT()
How to use the COUNT function in Excel to count the number of cells that contain numbers, and to count numbers within a list of arguments.
=COUNT(value1, [value2], ...)
Daily Tasks
Reporting
Statistical
★ 8 · ◉ 52 · All versions
=SKEW()
Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean. Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values. Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.
=SKEW(number1, [number2], ...)
Descriptive Statistics
Compatibility
★ 25 · ◉ 51 · All versions
=QUARTILE()
Returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE to find the top 25 percent of incomes in a population. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, you should consider using the new functions from now on, it may not be available in future versions of Excel.
=QUARTILE(array,quart)
Ranking & Top N
Descriptive Statistics
Statistical
★ 55 · ◉ 50 · Excel 2010
=STDEV.S()
Estimates standard deviation based on a sample (ignores logical values and text in the sample).
=STDEV.S(number1,[number2],...)
Descriptive Statistics
Statistical
★ 40 · ◉ 48 · Excel 2010
=PERCENTILE.INC()
PERCENTILE.INC returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. You can use this function to establish a threshold of acceptance.
=PERCENTILE.INC(array,k)
Ranking & Top N
Descriptive Statistics
Statistical
★ 4 · ◉ 45 · All versions
=STDEVPA()
Calculates standard deviation based on the entire population given as arguments, including text and logical values. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
=STDEVPA(value1, [value2], ...)
Descriptive Statistics
Statistical
★ 45 · ◉ 44 · All versions
=MEDIAN()
Returns the median of the given numbers. The median is the number in the middle of a set of numbers.
=MEDIAN(number1, [number2], ...)
Descriptive Statistics
Statistical
★ 25 · ◉ 44 · Excel 2010
=MODE.SNGL()
Returns the most frequently occurring, or repetitive, value in an array or range of data.
=MODE.SNGL(number1,[number2],...)
Descriptive Statistics
Compatibility
★ 35 · ◉ 43 · All versions
=MODE()
The MODE function returns the most frequently occurring, or repetitive, value in an array or range of data.
=MODE(number1,[number2],...)
Descriptive Statistics
Statistical
★ 10 · ◉ 43 · All versions
=PEARSON()
Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.
=PEARSON(array1, array2)
Descriptive Statistics
Compatibility
★ 25 · ◉ 43 · All versions
=PERCENTILE()
Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile. If k is non-numeric, PERCENTILE returns the #VALUE! error value. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
=PERCENTILE(array,k)
Ranking & Top N
Descriptive Statistics
Statistical
★ 40 · ◉ 43 · Excel 2010
=STDEV.P()
Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).
=STDEV.P(number1,[number2],...)
Descriptive Statistics
Statistical
★ 25 · ◉ 42 · All versions
=GEOMEAN()
Returns the geometric mean of an array or range of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates.
=GEOMEAN(number1, [number2], ...)
Descriptive Statistics
Forecasting & Trends
Statistical
★ 15 · ◉ 42 · Excel 2010
=PERCENTILE.EXC()
The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
=PERCENTILE.EXC(array,k)
Ranking & Top N
Descriptive Statistics
Statistical
★ 6 · ◉ 42 · All versions
=STDEVA()
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
=STDEVA(value1, [value2], ...)
Descriptive Statistics
Compatibility
★ 14 · ◉ 41 · Excel 2007 (Compatibility)
=EXPONDIST()
Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPONDIST to determine the probability that the process takes at most 1 minute.
=EXPONDIST(x,lambda,cumulative)
Descriptive Statistics
Statistical
★ 35 · ◉ 41 · All versions
=FREQUENCY()
The FREQUENCY function calculates how often values occur within a range of values, and then returns a vertical array of numbers. For example, use FREQUENCY to count the number of test scores that fall within ranges of scores.
=FREQUENCY(data_array, bins_array)
Conditional Aggregation
Reporting
Statistical
★ 65 · ◉ 40 · All versions
=AVERAGE()
Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
=AVERAGE(number1, [number2], ...)
Daily Tasks
Reporting
Statistical
★ 12 · ◉ 40 · Excel 2010
=COVARIANCE.S()
Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
=COVARIANCE.S(array1,array2)
Descriptive Statistics
Statistical
★ 15 · ◉ 40 · Excel 2010
=MODE.MULT()
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
=MODE.MULT((number1,[number2],...)
Descriptive Statistics
Statistical
★ 12 · ◉ 39 · Excel 2010
=QUARTILE.EXC()
QUARTILE.EXC returns the quartile of the data set, based on percentile values from 0..1, exclusive.
=QUARTILE.EXC(array, quart)
Ranking & Top N
Descriptive Statistics
Statistical
★ 10 · ◉ 38 · All versions
=AVERAGEA()
Calculates the average (arithmetic mean) of the values in the list of arguments.
=AVERAGEA(value1, [value2], ...)
Descriptive Statistics
Statistical
★ 20 · ◉ 38 · All versions
=TRIMMEAN()
Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set. You can use this function when you wish to exclude outlying data from your analysis.
=TRIMMEAN(array, percent)
Descriptive Statistics
Statistical
★ 20 · ◉ 38 · Excel 2010
=VAR.P()
Calculates variance based on the entire population (ignores logical values and text in the population).
=VAR.P(number1,[number2],...)
Descriptive Statistics
Statistical
★ 12 · ◉ 36 · All versions
=MAXA()
Returns the largest value in a list of arguments. MAXA is similar to MINA. For more information, see the examples for the MINA function.
=MAXA(value1,[value2],...)
Descriptive Statistics
Statistical
★ 12 · ◉ 36 · All versions
=STANDARDIZE()
Returns a normalized value from a distribution characterized by mean and standard_dev.
=STANDARDIZE(x, mean, standard_dev)
Descriptive Statistics
Probability & Hypothesis Testing
Statistical
★ 10 · ◉ 35 · All versions
=MINA()
Returns the smallest value in the list of arguments.
=MINA(value1, [value2], ...)
Descriptive Statistics
Statistical
★ 6 · ◉ 34 · All versions
=HARMEAN()
Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals.
=HARMEAN(number1, [number2], ...)
Descriptive Statistics
Statistical
★ 35 · ◉ 34 · Excel 2010
=QUARTILE.INC()
QUARTLE.INC returns the quartile of a data set, based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups.
=QUARTILE.INC(array,quart)
Ranking & Top N
Descriptive Statistics
Statistical
★ 45 · ◉ 33 · All versions
=CORREL()
The CORREL function returns the correlation coefficient of two cell ranges. Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location's average temperature and the use of air conditioners.
=CORREL(array1, array2)
Descriptive Statistics
Forecasting & Trends
Statistical
★ 6 · ◉ 33 · All versions
=DEVSQ()
Returns the sum of squares of deviations of data points from their sample mean.
=DEVSQ(number1, [number2], ...)
Descriptive Statistics
Statistical
★ 4 · ◉ 33 · Excel 2013
=SKEW.P()
1, number 2,… Number 1 is , subsequent numbers are Number 1, number 2,… are 1 to 254 numbers or names, arrays, or reference that contain numbers for which you want the population skewness.
=SKEW.P(number 1, [number 2],…)
Descriptive Statistics
Compatibility
★ 15 · ◉ 33 · All versions
=VAR()
Estimates variance based on a sample. VAR assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance by using VARP. Arguments can either be numbers or names, arrays, or references that contain numbers. This function has been replaced with one or more new functions. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
=VAR(number1,[number2],...)
Descriptive Statistics
Statistical
★ 5 · ◉ 31 · All versions
=KURT()
Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution.
=KURT(number1, [number2], ...)
Descriptive Statistics
Statistical
★ 25 · ◉ 31 · Excel 2010
=VAR.S()
The VAR.S function estimates variance based on a sample (ignores logical values and text in the sample).
=VAR.S(number1,[number2],...)
Descriptive Statistics
Statistical
★ 3 · ◉ 31 · All versions
=VARPA()
Calculates variance based on the entire population.
=VARPA(value1, [value2], ...)
Descriptive Statistics
Statistical
★ 12 · ◉ 30 · Excel 2010
=COVARIANCE.P()
Returns population covariance, the average of the products of deviations for each data point pair in two data sets. Use covariance to determine the relationship between two data sets.
=COVARIANCE.P(array1,array2)
Descriptive Statistics
Statistical
★ 4 · ◉ 28 · All versions
=VARA()
Estimates variance based on a sample.
=VARA(value1, [value2], ...)
Descriptive Statistics