This reference table lists all officially documented Statistical Functions. It is based on the Excel Help documentation and linked in each row when clicking on the function name. Export the table and/or display additional columns via the symbols to the top right of the table. Please report errors or inconsistencies via the comment function at the bottom of this page. Also check the main table with List of all Excel Functions.
# | Excel Function | Description | Syntax with Arguments | Syntax only | Arguments only |
---|---|---|---|---|---|
1 | AVEDEV | Returns the average of the absolute deviations of data points from their mean | =AVEDEV(number1number1 [required]: Number for which you want the average of the absolute deviations., [number2], ...) | =AVEDEV(number1, [number2], ...) |
|
2 | AVERAGE | returns the average of those numbers | =AVERAGE(number1number1 [required]: The first number, cell reference, or range for which you want the average., [number2number2 [optional]: Number for which you want the average of the absolute deviations.], ...) | =AVERAGE(number1, [number2], ...) |
|
3 | AVERAGEA | Calculates the average (arithmetic mean) of the values in the list of arguments | =AVERAGEA(value1value1 [required]: Calculates the average of the values in the list of arguments, [value2value2 [optional]: Optional additional value], ...) | =AVERAGEA(value1, [value2], ...) |
|
4 | AVERAGEIF | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | =AVERAGEIF(rangerange [required]: One or more cells to average, including numbers or names, arrays, or references that contain numbers., criteriacriteria [required]: The criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged., [average_rangeaverage_range [optional]: The actual set of cells to average.]) | =AVERAGEIF(range, criteria, [average_range]) |
|
5 | AVERAGEIFS | Returns the average (arithmetic mean) of all cells that meet multiple criteria | =AVERAGEIFS(average_rangeaverage_range [required]: One or more cells to average, including numbers or names, arrays, or references that contain numbers., criteria_range1criteria_range1 [required]: Range in which to evaluate the associated crite. Additional ranges are optional, criteria1criteria1 [required]: Criteria in the form of a number, expression, cell reference, or text that define which cells will be averaged., [criteria_range2, criteria2criteria_range2, criteria2 [optional]: Additional optional range/criteria], ...) | =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) |
|
6 | BETA.DIST | Returns the beta distribution | =BETA.DIST(xx [required]: The value between A and B at which to evaluate the function , alphaalpha [required]: A parameter of the distribution., betabeta [required]: A parameter of the distribution., cumulativecumulative [required]: A logical value that determines the form of the function., [aa [optional]: A lower bound to the interval of x.], [bb [optional]: An upper bound to the interval of x.]) | =BETA.DIST(x, alpha, beta, cumulative, [a], [b]) |
|
7 | BETA.INV | Returns the inverse of the beta cumulative probability density function (BETA | =BETA.INV(probabilityprobability [required]: A probability associated with the beta distribution., alphaalpha [required]: A parameter of the distribution., betabeta [required]: A parameter the distribution., [aa [optional]: A lower bound to the interval of x.], [bb [optional]: An upper bound to the interval of x.]) | =BETA.INV(probability, alpha, beta, [a], [b]) |
|
8 | BINOM.DIST | Returns the individual term binomial distribution probability | =BINOM.DIST(number_snumber_s [required]: The number of successes in trials., trialstrials [required]: The number of independent trials., probability_sprobability_s [required]: The probability of success on each trial., cumulativecumulative [required]: A logical value that determines the form of the function.) | =BINOM.DIST(number_s, trials, probability_s, cumulative) |
|
9 | BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution | =BINOM.DIST.RANGE(trialstrials [required]: The number of independent trials., probability_sprobability_s [required]: The probability of success in each trial., number_snumber_s [required]: The number of successes in trials., [number_s2number_s2 [optional]: If provided, returns the probability that the number of successful trials will fall between Number_s and number_s2.]) | =BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2]) |
|
10 | BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value | =BINOM.INV(trialstrials [required]: The number of Bernoulli trials., probability_sprobability_s [required]: The probability of a success on each trial., alphaalpha [required]: The criterion value.) | =BINOM.INV(trials, probability_s, alpha) |
|
11 | CHISQ.DIST | Returns the chi-squared distribution | =CHISQ.DIST(xx [required]: The value at which you want to evaluate the distribution., deg_freedomdeg_freedom [required]: The number of degrees of freedom., cumulativecumulative [required]: A logical value that determines the form of the function.) | =CHISQ.DIST(x, deg_freedom, cumulative) |
|
12 | CHISQ.DIST.RT | Returns the right-tailed probability of the chi-squared distribution | =CHISQ.DIST.RT(xx [required]: The value at which you want to evaluate the distribution., deg_freedomdeg_freedom [required]: The number of degrees of freedom.) | =CHISQ.DIST.RT(x, deg_freedom) |
|
13 | CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution | =CHISQ.INV(probabilityprobability [required]: A probability associated with the chi-squared distribution., deg_freedomdeg_freedom [required]: The number of degrees of freedom.) | =CHISQ.INV(probability, deg_freedom) |
|
14 | CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution | =CHISQ.INV.RT(probabilityprobability [required]: A probability associated with the chi-squared distribution., deg_freedomdeg_freedom [required]: The number of degrees of freedom.) | =CHISQ.INV.RT(probability, deg_freedom) |
|
15 | CHISQ.TEST | Returns the test for independence | =CHISQ.TEST(actual_rangeactual_range [required]: The range of data that contains observations to test against expected values., expected_rangeexpected_range [required]: The range of data that contains the ratio of the product of row totals and column totals to the grand total.) | =CHISQ.TEST(actual_range, expected_range) |
|
16 | CONFIDENCE.NORM | Returns the confidence interval for a population mean, using a normal distribution | =CONFIDENCE.NORM(alphaalpha [required]: The significance level used to compute the confidence level., standard_devstandard_dev [required]: The population standard deviation for the data range and is assumed to be known., sizesize [required]: The sample size.) | =CONFIDENCE.NORM(alpha, standard_dev, size) |
|
17 | CONFIDENCE.T | Returns confidence interval for a population mean, using t distribution | =CONFIDENCE.T(alphaalpha [required]: The significance level used to compute the confidence level., standard_devstandard_dev [required]: The population standard deviation for the data range and is assumed to be known., sizesize [required]: The sample size.) | =CONFIDENCE.T(alpha, standard_dev, size) |
|
18 | CORREL | Returns the correlation coefficient of two cell ranges | =CORREL(array1array1 [required]: A range of cell values., array2array2 [required]: A second range of cell values.) | =CORREL(array1, array2) |
|
19 | COUNT | Count the number of cells that contain numbers | =COUNT(value1value1 [required]: The first item, cell reference, or range within which you want to count numbers., [value2value2 [optional]: Additional items to count.], ...) | =COUNT(value1, [value2], ...) |
|
20 | COUNTA | Count the number of cells that are not empty in a range | =COUNTA(value1value1 [required]: The first item, cell reference, or range within which you want to count numbers., [value2value2 [optional]: Additional items to count.], ...) | =COUNTA(value1, [value2], ...) |
|
21 | COUNTBLANK | Counts the number of empty cells in a range of cells | =COUNTBLANK(rangerange [required]: The range from which you want to count the blank cells.) | =COUNTBLANK(range) |
|
22 | COUNTIF | Count the number of cells that meet a citeria | =COUNTIF(rangerange [required]: The range from which you want to count the blank cells., criteriacriteria [required]: The criteria in the form of a number, expression, cell reference, or text.) | =COUNTIF(range, criteria) |
|
23 | COUNTIFS | Applies criteria to cells across multiple ranges and counts the number of times all criteria are met | =COUNTIFS(criteria_range1criteria_range1 [required]: The first range in which to evaluate the associated criteria., criteria1criteria1 [required]: The criteria in the form of a number, expression, cell reference, or text., [criteria_range2, criteria2criteria_range2, criteria2 [optional]: Additional ranges and their associated criteria], ...) | =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...) |
|
24 | COVARIANCE.P | Returns population covariance, the average of the products of deviations for each data point pair in two data sets | =COVARIANCE.P(array1array1 [required]: The first cell range of integers., array2array2 [required]: The second cell range of integers.) | =COVARIANCE.P(array1, array2) |
|
25 | COVARIANCE.S | Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets | =COVARIANCE.S(array1array1 [required]: The first cell range of integers., array2array2 [required]: The second cell range of integers.) | =COVARIANCE.S(array1, array2) |
|
26 | DEVSQ | Returns the sum of squares of deviations of data points from their sample mean | =DEVSQ(number1number1 [required]: Number for which you want to calculate the sum of squared deviations, [number2number2 [optional]: Additional numbers], ...) | =DEVSQ(number1, [number2], ...) |
|
27 | EXPON.DIST | Returns the exponential distribution | =EXPON.DIST(xx [required]: The value of the function., lambdalambda [required]: The parameter value., cumulativecumulative [required]: A logical value that indicates which form of the exponential function to provide.) | =EXPON.DIST(x, lambda, cumulative) |
|
28 | F.DIST | Returns the F probability distribution (degree of diversity) for two data sets | =F.DIST(xx [required]: The value at which to evaluate the function., deg_freedom1deg_freedom1 [required]: The numerator degrees of freedom., deg_freedom2deg_freedom2 [required]: The denominator degrees of freedom., cumulativecumulative [required]: A logical value that determines the form of the function.) | =F.DIST(x, deg_freedom1, deg_freedom2, cumulative) |
|
29 | F.DIST.RT | Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets | =F.DIST.RT(xx [required]: The value at which to evaluate the function., deg_freedom1deg_freedom1 [required]: The numerator degrees of freedom., deg_freedom2deg_freedom2 [required]: The denominator degrees of freedom.) | =F.DIST.RT(x, deg_freedom1, deg_freedom2) |
|
30 | F.INV | Returns the inverse of the F probability distribution | =F.INV(probabilityprobability [required]: A probability associated with the F cumulative distribution., deg_freedom1deg_freedom1 [required]: The numerator degrees of freedom., deg_freedom2deg_freedom2 [required]: The denominator degrees of freedom.) | =F.INV(probability, deg_freedom1, deg_freedom2) |
|
31 | F.INV.RT | Returns the inverse of the (right-tailed) F probability distribution | =F.INV.RT(probabilityprobability [required]: A probability associated with the F cumulative distribution., deg_freedom1deg_freedom1 [required]: The numerator degrees of freedom., deg_freedom2deg_freedom2 [required]: The denominator degrees of freedom.) | =F.INV.RT(probability, deg_freedom1, deg_freedom2) |
|
32 | F.TEST | Returns the result of an F-test, the two-tailed probability that the variances in array1 and array2 are not significantly different | =F.TEST(array1array1 [required]: The first array or range of data., array2array2 [required]: The second array or range of data.) | =F.TEST(array1, array2) |
|
33 | FINV | Returns the inverse of the (right-tailed) F probability distribution | =FINV(probabilityprobability [required]: A probability associated with the F cumulative distribution., deg_freedom1deg_freedom1 [required]: The numerator degrees of freedom., deg_freedom2deg_freedom2 [required]: The denominator degrees of freedom.) | =FINV(probability, deg_freedom1, deg_freedom2) |
|
34 | FISHER | Returns the Fisher transformation at x | =FISHER(xx [required]: A numeric value for which you want the transformation.) | =FISHER(x) |
|
35 | FISHERINV | Returns the inverse of the Fisher transformation | =FISHERINV(yy [required]: The value for which you want to perform the inverse of the transformation.) | =FISHERINV(y) |
|
36 | FORECAST | Calculate, or predict, a future value by using existing values | =FORECAST(xx [required]: The data point for which you want to predict a value., known_y'sknown_y's [required]: The dependent array or range of data., known_x'sknown_x's [required]: The independent array or range of data.) | =FORECAST(x, known_y's, known_x's) |
|
37 | FORECAST.ETS | Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm | =FORECAST.ETS(target_datetarget_date [required]: The data point for which you want to predict a value., valuesvalues [required]: Values are the historical values, for which you want to forecast the next points., timelinetimeline [required]: The independent array or range of numeric data. , [seasonalityseasonality [optional]: Numeric value indicating seasonality.], [data_completiondata_completion [optional]: Numeric value indicating algorithm to account for for missing points.], [aggregationaggregation [optional]: Numeric value indicating which method will be used to aggregate several values with the same time stamp]) | =FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation]) |
|
38 | FORECAST.ETS.CONFINT | Returns a confidence interval for the forecast value at the specified target date. | =FORECAST.ETS.CONFINT(target_datetarget_date [required]: The data point for which you want to predict a value., valuesvalues [required]: Values are the historical values, for which you want to forecast the next points., timelinetimeline [required]: The independent array or range of numeric data. , [confidence_levelconfidence_level [optional]: A numerical value between 0 and 1 (exclusive), indicating a confidence level for the calculated confidence interval.], [seasonalityseasonality [optional]: Numeric value indicating seasonality.], [data_completiondata_completion [optional]: Numeric value indicating algorithm to account for for missing points.], [aggregationaggregation [optional]: Numeric value indicating which method will be used to aggregate several values with the same time stamp]) | =FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation]) |
|
39 | FORECAST.ETS.SEASONALITY | Returns the length of the repetitive pattern Excel detects for the specified time series | =FORECAST.ETS.SEASONALITY(valuesvalues [required]: Values are the historical values, for which you want to forecast the next points., timelinetimeline [required]: The independent array or range of numeric data. , [data_completiondata_completion [optional]: Numeric value indicating algorithm to account for for missing points.], [aggregationaggregation [optional]: Numeric value indicating which method will be used to aggregate several values with the same time stamp]) | =FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation]) |
|
40 | FORECAST.ETS.STAT | Returns a statistical value as a result of time series forecasting | =FORECAST.ETS.STAT(valuesvalues [required]: Values are the historical values, for which you want to forecast the next points., timelinetimeline [required]: The independent array or range of numeric data. , statistic_typestatistic_type [required]: A numeric value between 1 and 8, indicating which statistic will be returned for the calculated forecast., [seasonalityseasonality [optional]: Numeric value indicating seasonality.], [data_completiondata_completion [optional]: Numeric value indicating algorithm to account for for missing points.], [aggregationaggregation [optional]: Numeric value indicating which method will be used to aggregate several values with the same time stamp]) | =FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation]) |
|
41 | FORECAST.LINEAR | Returns a statistical value as a result of time series forecasting | =FORECAST.LINEAR(xx [required]: The data point for which you want to predict a value., known_y'sknown_y's [required]: The dependent array or range of data., known_x'sknown_x's [required]: The independent array or range of data.) | =FORECAST.LINEAR(x, known_y's, known_x's) |
|
42 | FREQUENCY | Calculates how often values occur within a range of values, and then returns a vertical array of numbers | =FREQUENCY(data_arraydata_array [required]: An array of or reference to a set of values for which you want to count frequencies., bins_arraybins_array [required]: An array of or reference to intervals into which you want to group the values in data_array.) | =FREQUENCY(data_array, bins_array) |
|
43 | GAMMA | Return the gamma function value | =GAMMA(numbernumber [required]: Returns a number.) | =GAMMA(number) |
|
44 | GAMMA.DIST | Returns the gamma distribution | =GAMMA.DIST(xx [required]: The value at which you want to evaluate the distribution., alphaalpha [required]: A parameter to the distribution., betabeta [required]: A parameter to the distribution., cumulativecumulative [required]: A logical value that determines the form of the function.) | =GAMMA.DIST(x, alpha, beta, cumulative) |
|
45 | GAMMA.INV | Returns the inverse of the gamma cumulative distribution | =GAMMA.INV(probabilityprobability [required]: The probability associated with the gamma distribution., alphaalpha [required]: A parameter to the distribution., betabeta [required]: A parameter to the distribution.) | =GAMMA.INV(probability, alpha, beta) |
|
46 | GAMMALN | Returns the natural logarithm of the gamma function | =GAMMALN(xx [required]: The value for which you want to calculate GAMMALN.) | =GAMMALN(x) |
|
47 | GAMMALN.PRECISE | Returns the natural logarithm of the gamma function | =GAMMALN.PRECISE(xx [required]: The value for which you want to calculate GAMMALN.) | =GAMMALN.PRECISE(x) |
|
48 | GAUSS | Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean | =GAUSS(zz [required]: Returns a number.) | =GAUSS(z) |
|
49 | GEOMEAN | Returns the geometric mean of an array or range of positive data | =GEOMEAN(number1number1 [required]: The first number arguments for which you want to calculate the mean., [number2number2 [optional]: Additional optional numbers], ...) | =GEOMEAN(number1, [number2], ...) |
|
50 | GROWTH | Calculates predicted exponential growth by using existing data | =GROWTH(known_y'sknown_y's [required]: The set of y-values you already know in the relationship y = b*m^x., [known_x'sknown_x's [optional]: An optional set of x-values that you may already know in the relationship y = b*m^x.], [new_x'snew_x's [optional]: Are new x-values for which you want GROWTH to return corresponding y-values.], [constconst [optional]: A logical value specifying whether to force the constant b to equal 1.]) | =GROWTH(known_y's, [known_x's], [new_x's], [const]) |
|
51 | HARMEAN | Returns the harmonic mean of a data set | =HARMEAN(number1number1 [required]: Number arguments for which you want to calculate the mean. , [number2number2 [optional]: Additional optional number arguments. ], ...) | =HARMEAN(number1, [number2], ...) |
|
52 | HYPGEOM.DIST | Returns the hypergeometric distribution/ probability of a given number of sample successes, given the sample size, population successes, and population size. | =HYPGEOM.DIST(sample_ssample_s [required]: The number of successes in the sample., number_samplenumber_sample [required]: The size of the sample., population_spopulation_s [required]: The number of successes in the population., number_popnumber_pop [required]: The population size., cumulativecumulative [required]: A logical value that determines the form of the function.) | =HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative) |
|
53 | INTERCEPT | Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values | =INTERCEPT(known_y'sknown_y's [required]: The dependent set of observations or data., known_x'sknown_x's [required]: The independent set of observations or data.) | =INTERCEPT(known_y's, known_x's) |
|
54 | KURT | Returns the kurtosis of a data set | =KURT(number1number1 [required]: Number for which you want to calculate kurtosis., [number2number2 [optional]: Additional optional numbers.], ...) | =KURT(number1, [number2], ...) |
|
55 | LARGE | Returns the k-th largest value in a data set | =LARGE(arrayarray [required]: The array or range of data for which you want to determine the k-th largest value., kk [required]: The position (from the largest) in the array or cell range of data to return.) | =LARGE(array, k) |
|
56 | LINEST | Calculate the statistics for other types of models that are linear in the unknown parameters, including polynomial, logarithmic, exponential, and power series | =LINEST(known_y'sknown_y's [required]: The et of y-values that you already know in the relationship y = mx + b., [known_x'sknown_x's [optional]: A set of x-values that you may already know in the relationship y = mx + b.], [constconst [optional]: A logical value specifying whether to force the constant b to equal 0.], [statsstats [optional]: A logical value specifying whether to return additional regression statistics.]) | =LINEST(known_y's, [known_x's], [const], [stats]) |
|
57 | LOGEST | Calculates an exponential curve that fits your data and returns an array of values that describes the curve. | =LOGEST(known_y'sknown_y's [required]: The set of y-values you already know in the relationship y = b*m^x., [known_x'sknown_x's [optional]: An optional set of x-values that you may already know in the relationship y = b*m^x.], [constconst [optional]: A logical value specifying whether to force the constant b to equal 1.], [statsstats [optional]: A logical value specifying whether to return additional regression statistics.]) | =LOGEST(known_y's, [known_x's], [const], [stats]) |
|
58 | LOGNORM.DIST | Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev | =LOGNORM.DIST(xx [required]: The value at which to evaluate the function., meanmean [required]: The mean of ln(x)., standard_devstandard_dev [required]: The standard deviation of ln(x)., cumulativecumulative [required]: A logical value that determines the form of the function.) | =LOGNORM.DIST(x, mean, standard_dev, cumulative) |
|
59 | LOGNORM.INV | Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev | =LOGNORM.INV(probabilityprobability [required]: A probability associated with the lognormal distribution., meanmean [required]: The mean of ln(x)., standard_devstandard_dev [required]: The standard deviation of ln(x).) | =LOGNORM.INV(probability, mean, standard_dev) |
|
60 | MAX | Returns the largest value in a set of values | =MAX(number1number1 [required]: First numbers for which you want to find the maximum value., [number2number2 [optional]: Additional numbers.], ...) | =MAX(number1, [number2], ...) |
|
61 | MAXA | Returns the largest value in a list of arguments | =MAXA(value1value1 [optional]: Additional number arguments.value1 [required]: The first number argument for which you want to find the largest value., [value2], ...) | =MAXA(value1, [value2], ...) |
|
62 | MAXIFS | Returns the maximum value among cells specified by a given set of conditions or criteria | =MAXIFS(max_rangemax_range [required]: The actual range of cells in which the maximum will be determined., criteria_range1criteria_range1 [required]: Is the set of cells to evaluate with the criteria., criteria1criteria1 [required]: Is the criteria in the form of a number, expression, or text that defines which cells will be evaluated as maximum., [criteria_range2, criteria2criteria_range2, criteria2 [optional]: Additional optional ranges/criterias], ...) | =MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) |
|
63 | MEDIAN | Returns the median of the given numbers | =MEDIAN(number1, [number2], ...) | =MEDIAN(number1, [number2], ...) | |
64 | MIN | Returns the smallest number in a set of values | =MIN(number1number1 [required]: First numbers for which you want to find the smallest value., [number2number2 [optional]: Additional numbers.], ...) | =MIN(number1, [number2], ...) |
|
65 | MINA | Returns the smallest value in the list of arguments | =MINA(value1value1 [required]: The first number argument for which you want to find the smallest value., [value2value2 [optional]: Additional number arguments.], ...) | =MINA(value1, [value2], ...) |
|
66 | MINIFS | Returns the minimum value among cells specified by a given set of conditions or criteria | =MINIFS(min_rangemin_range [required]: The actual range of cells in which the smallest number will be determined., criteria_range1criteria_range1 [required]: Is the set of cells to evaluate with the criteria., criteria1criteria1 [required]: Is the criteria in the form of a number, expression, or text that defines which cells will be evaluated as minimum., [criteria_range2, criteria2criteria_range2, criteria2 [optional]: Additional optional ranges/criterias], ...) | =MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) |
|
67 | MODE.MULT | Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data | =MODE.MULT((number1number1 [required]: The first number argument for which you want to calculate the mode., [number2number2 [optional]: Additional numbers to calculate the mode.], ...) | =MODE.MULT((number1, [number2], ...) |
|
68 | MODE.SNGL | Returns the most frequently occurring, or repetitive, value in an array or range of data | =MODE.SNGL(number1number1 [required]: The first argument for which you want to calculate the mode., [number2number2 [optional]: Additional numbers to calculate the mode.], ...) | =MODE.SNGL(number1, [number2], ...) |
|
69 | NEGBINOM.DIST | Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success | =NEGBINOM.DIST(number_fnumber_f [required]: The number of failures., number_snumber_s [required]: The threshold number of successes., probability_sprobability_s [required]: The probability of a success., cumulativecumulative [required]: A logical value that determines the form of the function.) | =NEGBINOM.DIST(number_f, number_s, probability_s, cumulative) |
|
70 | NORM.DIST | Returns the normal distribution for the specified mean and standard deviation | =NORM.DIST(xx [required]: The value for which you want the distribution., meanmean [required]: The arithmetic mean of the distribution., standard_devstandard_dev [required]: The standard deviation of the distribution., cumulativecumulative [required]: A logical value that determines the form of the function.) | =NORM.DIST(x, mean, standard_dev, cumulative) |
|
71 | NORM.S.DIST | Returns the standard normal distribution (has a mean of zero and a standard deviation of one) | =NORM.S.DIST(zz [required]: The value for which you want the distribution., cumulativecumulative [required]: Cumulative is a logical value that determines the form of the function.) | =NORM.S.DIST(z, cumulative) |
|
72 | NORM.S.INV | Returns the inverse of the standard normal cumulative distribution | =NORM.S.INV(probabilityprobability [required]: A probability corresponding to the normal distribution.) | =NORM.S.INV(probability) |
|
73 | NORMINV | Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation | =NORMINV(probabilityprobability [required]: A probability corresponding to the normal distribution., meanmean [required]: The arithmetic mean of the distribution., standard_devstandard_dev [required]: The standard deviation of the distribution.) | =NORMINV(probability, mean, standard_dev) |
|
74 | PEARSON | Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1 | =PEARSON(array1array1 [required]: A set of independent values., array2array2 [required]: A set of dependent values.) | =PEARSON(array1, array2) |
|
75 | PERCENTILE.EXC | Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1 | =PERCENTILE.EXC(arrayarray [required]: The array or range of data that defines relative standing., kk [required]: The array or range of data that defines relative standing.) | =PERCENTILE.EXC(array, k) |
|
76 | PERCENTILE.INC | Returns the k-th percentile of values in a range, where k is in the range 0 | =PERCENTILE.INC(arrayarray [required]: The array or range of data that defines relative standing., kk [required]: The percentile value in the range 0.) | =PERCENTILE.INC(array, k) |
|
77 | PERCENTRANK.EXC | Returns the rank of a value in a data set as a percentage (0 | =PERCENTRANK.EXC(arrayarray [required]: The array or range of data with numeric values that defines relative standing , xx [required]: The value for which you want to know the rank., [significancesignificance [optional]: A value that identifies the number of significant digits for the returned percentage value.]) | =PERCENTRANK.EXC(array, x, [significance]) |
|
78 | PERCENTRANK.INC | Returns the rank of a value in a data set as a percentage (0 | =PERCENTRANK.INC(arrayarray [required]: The array or range of data with numeric values that defines relative standing., xx [required]: The value for which you want to know the rank., [significancesignificance [optional]: A value that identifies the number of significant digits for the returned percentage value.]) | =PERCENTRANK.INC(array, x, [significance]) |
|
79 | PERMUT | Returns the number of permutations for a given number of objects that can be selected from number objects | =PERMUT(numbernumber [required]: An integer that describes the number of objects., number_chosennumber_chosen [required]: An integer that describes the number of objects in each permutation.) | =PERMUT(number, number_chosen) |
|
80 | PERMUTATIONA | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects | =PERMUTATIONA(numbernumber [required]: An integer that describes the total number of objects., number_chosennumber_chosen [required]: An integer that describes the number of objects in each permutation.) | =PERMUTATIONA(number, number_chosen) |
|
81 | PHI | Returns the value of the density function for a standard normal distribution | =PHI(xx [required]: X is the number for which you want the density of the standard normal distribution.) | =PHI(x) |
|
82 | POISSON.DIST | Returns the Poisson distribution | =POISSON.DIST(xx [required]: The number of events., meanmean [required]: The expected numeric value., cumulativecumulative [required]: A logical value that determines the form of the probability distribution returned.) | =POISSON.DIST(x, mean, cumulative) |
|
83 | PROB | Returns the probability that values in a range are between two limits | =PROB(x_rangex_range [required]: The range of numeric values of x with which there are associated probabilities., prob_rangeprob_range [required]: A set of probabilities associated with values in x_range., [lower_limitlower_limit [optional]: The lower bound on the value for which you want a probability.], [upper_limitupper_limit [optional]: The optional upper bound on the value for which you want a probability.]) | =PROB(x_range, prob_range, [lower_limit], [upper_limit]) |
|
84 | QUARTILE.EXC | Returns the quartile of the data set, based on percentile values from 0 | =QUARTILE.EXC(arrayarray [required]: The array or cell range of numeric values for which you want the quartile value., quartquart [required]: Indicates which value to return.) | =QUARTILE.EXC(array, quart) |
|
85 | QUARTILE.INC | Returns the quartile of a data set, based on percentile values from 0 | =QUARTILE.INC(arrayarray [required]: The array or cell range of numeric values for which you want the quartile value., quartquart [required]: Indicates which value to return.) | =QUARTILE.INC(array, quart) |
|
86 | RANK.AVG | Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned | =RANK.AVG(numbernumber [required]: The number whose rank you want to find., refref [required]: An array of, or a reference to, a list of numbers., [orderorder [optional]: A number specifying how to rank number.]) | =RANK.AVG(number, ref, [order]) |
|
87 | RANK.EQ | Returns the rank of a number in a list of numbers | =RANK.EQ(numbernumber [required]: The number whose rank you want to find., refref [required]: An array of, or a reference to, a list of numbers., [orderorder [optional]: A number specifying how to rank number.]) | =RANK.EQ(number, ref, [order]) |
|
88 | RSQ | Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's | =RSQ(known_y'sknown_y's [required]: An array or range of data points., known_x'sknown_x's [required]: An array or range of data points.) | =RSQ(known_y's, known_x's) |
|
89 | SKEW | Returns the skewness of a distribution | =SKEW(number1number1 [required]: Number for which you want to calculate skewness., [number2number2 [optional]: Additional optional numbers.], ...) | =SKEW(number1, [number2], ...) |
|
90 | SKEW.P | Returns the skewness of a distribution based on a population | =SKEW.P(number1number1 [required]: Number for which you want to calculate population skewness., [number2number2 [optional]: Additional optional numbers.], ...) | =SKEW.P(number1, [number2], ...) |
|
91 | SLOPE | Returns the slope of the linear regression line through data points in known_y's and known_x's | =SLOPE(known_y'sknown_y's [required]: An array or cell range of numeric dependent data points., known_x'sknown_x's [required]: The set of independent data points.) | =SLOPE(known_y's, known_x's) |
|
92 | SMALL | Returns the k-th smallest value in a data set | =SMALL(arrayarray [required]: An array or range of numerical data for which you want to determine the k-th smallest value., kk [required]: The position (from the smallest) in the array or range of data to return.) | =SMALL(array, k) |
|
93 | STANDARDIZE | Returns a normalized value from a distribution characterized by mean and standard_dev | =STANDARDIZE(xx [required]: The value you want to normalize., meanmean [required]: The arithmetic mean of the distribution., standard_devstandard_dev [required]: The standard deviation of the distribution.) | =STANDARDIZE(x, mean, standard_dev) |
|
94 | STDEV.P | Calculates standard deviation based on the entire population given as arguments (ignores logical values and text) | =STDEV.P(number1number1 [required]: The first number argument corresponding to a population., [number2number2 [optional]: Additional numbers arguments], ...) | =STDEV.P(number1, [number2], ...) |
|
95 | STDEV.S | Estimates standard deviation based on a sample (ignores logical values and text in the sample) | =STDEV.S(number1number1 [required]: The first number argument corresponding to a sample of a population., [number2number2 [optional]: Additional optional numbers], ...) | =STDEV.S(number1, [number2], ...) |
|
96 | STDEVA | Estimates standard deviation based on a sample | =STDEVA(value1, [value2], ...) | =STDEVA(value1, [value2], ...) | |
97 | STDEVPA | Calculates standard deviation based on the entire population given as arguments, including text and logical values | =STDEVPA(value1value1 [required]: The first value corresponding to a sample of a population., [value2value2 [optional]: Additional optional values], ...) | =STDEVPA(value1, [value2], ...) |
|
98 | STEYX | Returns the standard error of the predicted y-value for each x in the regression | =STEYX(known_y'sknown_y's [required]: An array or range of dependent data points., known_x'sknown_x's [required]: An array or range of independent data points.) | =STEYX(known_y's, known_x's) |
|
99 | T.DIST | Returns the Student's left-tailed t-distribution | =T.DIST(xx [required]: The numeric value at which to evaluate the distribution , deg_freedomdeg_freedom [required]: An integer indicating the number of degrees of freedom., cumulativecumulative [required]: A logical value that determines the form of the function.) | =T.DIST(x, deg_freedom, cumulative) |
|
100 | T.DIST.2T | Returns the two-tailed Student's t-distribution | =T.DIST.2T(xx [required]: The numeric value at which to evaluate the distribution., deg_freedomdeg_freedom [required]: An integer indicating the number of degrees of freedom.) | =T.DIST.2T(x, deg_freedom) |
|
101 | T.DIST.RT | Returns the right-tailed Student's t-distribution | =T.DIST.RT(xx [required]: The numeric value at which to evaluate the distribution., deg_freedomdeg_freedom [required]: An integer indicating the number of degrees of freedom.) | =T.DIST.RT(x, deg_freedom) |
|
102 | T.INV | Returns the two-tailed inverse of the Student's t-distribution | =T.INV(probabilityprobability [required]: The probability associated with the Student's t-distribution., deg_freedomdeg_freedom [required]: The number of degrees of freedom with which to characterize the distribution.) | =T.INV(probability, deg_freedom) |
|
103 | T.INV.2T | Returns the two-tailed inverse of the Student's t-distribution | =T.INV.2T(probabilityprobability [required]: The probability associated with the Student's t-distribution., deg_freedomdeg_freedom [required]: The number of degrees of freedom with which to characterize the distribution.) | =T.INV.2T(probability, deg_freedom) |
|
104 | T.TEST | Returns the probability associated with a Student's t-Test | =T.TEST(array1array1 [required]: The first data set., array2array2 [required]: The second data set., tailstails [required]: Specifies the number of distribution tails., typetype [required]: The kind of t-Test to perform.) | =T.TEST(array1, array2, tails, type) |
|
105 | TREND | Returns values along a linear trend | =TREND(known_y'sknown_y's [required]: The set of y-values you already know in the relationship y = mx + b, [known_x'sknown_x's [optional]: An optional set of x-values that you may already know in the relationship y = mx + b], [new_x'snew_x's [optional]: New x-values for which you want TREND to return corresponding y-values], [constconst [optional]: A logical value specifying whether to force the constant b to equal 0]) | =TREND(known_y's, [known_x's], [new_x's], [const]) |
|
106 | TRIMMEAN | Returns the mean of the interior of a data set | =TRIMMEAN(arrayarray [required]: The array or range of values to trim and average., percentpercent [required]: The fractional number of data points to exclude from the calculation.) | =TRIMMEAN(array, percent) |
|
107 | VAR.P | Calculates variance based on the entire population (ignores logical values and text in the population) | =VAR.P(number1number1 [required]: The first number argument corresponding to a population., [number2number2 [optional]: Additional optional numbers.], ...) | =VAR.P(number1, [number2], ...) |
|
108 | VAR.S | Estimates variance based on a sample (ignores logical values and text in the sample) | =VAR.S(number1number1 [required]: The first number argument corresponding to a sample of a population., [number2number2 [optional]: Additional optional numbers.], ...) | =VAR.S(number1, [number2], ...) |
|
109 | VARA | Estimates variance based on a sample | =VARA(value1value1 [required]: The first value arguments corresponding to a sample of a population., [value2value2 [optional]: Additional optional value arguments.], ...) | =VARA(value1, [value2], ...) |
|
110 | VARPA | Calculates variance based on the entire population | =VARPA(value1value1 [required]: The first value arguments corresponding to a sample of a population., [value2value2 [optional]: Additional optional value arguments.], ...) | =VARPA(value1, [value2], ...) |
|
111 | WEIBULL.DIST | Returns the Weibull distribution | =WEIBULL.DIST(xx [required]: The value at which to evaluate the function., alphaalpha [required]: A parameter to the distribution., betabeta [required]: A parameter to the distribution., cumulativecumulative [required]: Determines the form of the function.) | =WEIBULL.DIST(x, alpha, beta, cumulative) |
|
112 | Z.TEST | Returns the one-tailed P-value of a z-test | =Z.TEST(arrayarray [required]: The array or range of data against which to test x., xx [required]: The value to test., [sigmasigma [optional]: The population (known) standard deviation.]) | =Z.TEST(array, x, [sigma]) |
|
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy