42 functions for this use case · out of 12 defined
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).
Returns the largest value in a set of values.
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.
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.
Returns the smallest number in a set of values.
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.
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.
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).
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.
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
Calculates the average (arithmetic mean) of the values in the list of arguments.
The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).
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.
Returns the most frequently occurring, or repetitive, value in an array or range of data.
Estimates variance based on a sample.
Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.
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.
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.
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.
Returns the largest value in a list of arguments. MAXA is similar to MINA. For more information, see the examples for the MINA function.
Returns the median of the given numbers. The median is the number in the middle of a set of numbers.
The MODE function returns the most frequently occurring, or repetitive, value in an array or range of data.
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.
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.
Returns a normalized value from a distribution characterized by mean and standard_dev.
Estimates standard deviation based on a sample (ignores logical values and text in the sample).
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.
Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals.
Calculates variance based on the entire population.
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.
Returns the smallest value in the list of arguments.
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.
Returns the sum of squares of deviations of data points from their sample mean.
QUARTILE.EXC returns the quartile of the data set, based on percentile values from 0..1, exclusive.
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).
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.
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.
Calculates variance based on the entire population (ignores logical values and text in the population).
The VAR.S function estimates variance based on a sample (ignores logical values and text in the sample).
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.