Excel functions · 145 functions
Excel statistical and counting functions
Averages, counts, largest and smallest values, ranking, standard deviation and probability distributions. COUNTIF, COUNTIFS and AVERAGEIF are the most used for conditional counts and averages.
Functions explained in full
- AVERAGEArithmetic mean.
- AVERAGEIFAverage of the cells that meet a condition.
- AVERAGEIFSAverage of cells meeting multiple conditions.
- COUNTCounts cells that contain numbers.
- COUNTACounts non-empty cells.
- COUNTBLANKCounts empty cells.
- COUNTIFCounts cells that meet a condition.
- COUNTIFSCounts rows meeting multiple conditions.
- LARGEk-th largest value.
- MAXLargest value.
- MAXIFSLargest value among rows meeting conditions.
- MEDIANMedian (the middle number when sorted).
- MINSmallest value.
- MINIFSSmallest value among rows meeting conditions.
- RANK.EQRank; ties share the same rank.
- SMALLk-th smallest value.
- STDEV.SSample standard deviation.
All functions
Arithmetic mean.
=AVERAGE(number1, [number2], ...)Average of the cells that meet a condition.
=AVERAGEIF(range, criteria, [average_range])Average of cells meeting multiple conditions.
=AVERAGEIFS(average_range, criteria_range1, criteria1, ...)Counts cells that contain numbers.
=COUNT(value1, [value2], ...)Counts non-empty cells.
=COUNTA(value1, [value2], ...)Counts empty cells.
=COUNTBLANK(range)Counts cells that meet a condition.
=COUNTIF(range, criteria)Counts rows meeting multiple conditions.
=COUNTIFS(criteria_range1, criteria1, ...)k-th largest value.
=LARGE(array, k)Largest value.
=MAX(number1, [number2], ...)Largest value among rows meeting conditions.
=MAXIFS(max_range, criteria_range1, criteria1, ...)Median (the middle number when sorted).
=MEDIAN(number1, [number2], ...)Smallest value.
=MIN(number1, [number2], ...)Smallest value among rows meeting conditions.
=MINIFS(min_range, criteria_range1, criteria1, ...)Rank; ties share the same rank.
=RANK.EQ(number, ref, [order])k-th smallest value.
=SMALL(array, k)Sample standard deviation.
=STDEV.S(number1, [number2], ...)- AVEDEVORTSAP
Average absolute deviation.
=AVEDEV(number1, [number2], ...) - AVERAGEAORTALAMAA
Mean counting text as 0 and logicals as 1/0.
=AVERAGEA(value1, [value2], ...) - BETA.DISTBETA.DAĞ
Beta distribution.
=BETA.DIST(x, alpha, beta, cumulative, [A], [B]) - BETA.INVBETA.TERS
Inverse beta distribution.
=BETA.INV(probability, alpha, beta, [A], [B]) - BETADISTBETADAĞ
Cumulative beta distribution.
=BETADIST(x, alpha, beta, [A], [B]) - BETAINVBETATERS
Inverse beta distribution.
=BETAINV(probability, alpha, beta, [A], [B]) - BINOM.DISTBİNOM.DAĞ
Binomial distribution.
=BINOM.DIST(number_s, trials, probability_s, cumulative) - BINOM.DIST.RANGEBİNOM.DAĞ.ARALIK
Probability of a trial result in a range.
=BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2]) - BINOM.INVBİNOM.TERS
Smallest value whose cumulative binomial is ≥ alpha.
=BINOM.INV(trials, probability_s, alpha) - BINOMDISTBİNOMDAĞ
Binomial distribution.
=BINOMDIST(number_s, trials, probability_s, cumulative) - CHIDISTKİKAREDAĞ
Right-tailed chi-squared distribution.
=CHIDIST(x, deg_freedom) - CHIINVKİKARETERS
Inverse right-tailed chi-squared.
=CHIINV(probability, deg_freedom) - CHISQ.DISTKİKARE.DAĞ
Chi-squared distribution (left tail).
=CHISQ.DIST(x, deg_freedom, cumulative) - CHISQ.DIST.RTKİKARE.DAĞ.SAĞK
Right-tailed chi-squared distribution.
=CHISQ.DIST.RT(x, deg_freedom) - CHISQ.INVKİKARE.TERS
Inverse left-tailed chi-squared.
=CHISQ.INV(probability, deg_freedom) - CHISQ.INV.RTKİKARE.TERS.SAĞK
Inverse right-tailed chi-squared.
=CHISQ.INV.RT(probability, deg_freedom) - CHISQ.TESTKİKARE.TEST
Test for independence (p-value).
=CHISQ.TEST(actual_range, expected_range) - CHITESTKİKARETEST
Test for independence (p-value).
=CHITEST(actual_range, expected_range) - CONFIDENCEGÜVENİRLİK
Confidence interval half-width (normal).
=CONFIDENCE(alpha, standard_dev, size) - CONFIDENCE.NORMGÜVENİLİRLİK.NORM
Confidence interval half-width (normal).
=CONFIDENCE.NORM(alpha, standard_dev, size) - CONFIDENCE.TGÜVENİLİRLİK.T
Confidence interval half-width (t).
=CONFIDENCE.T(alpha, standard_dev, size) - CORRELKORELASYON
Correlation coefficient.
=CORREL(array1, array2) - COVARKOVARYANS
Population covariance.
=COVAR(array1, array2) - COVARIANCE.PKOVARYANS.P
Population covariance.
=COVARIANCE.P(array1, array2) - COVARIANCE.SKOVARYANS.S
Sample covariance.
=COVARIANCE.S(array1, array2) - CRITBINOMKRİTİKBİNOM
Smallest value whose cumulative binomial is ≥ alpha.
=CRITBINOM(trials, probability_s, alpha) - DEVSQSAPKARE
Sum of squared deviations.
=DEVSQ(number1, [number2], ...) - EXPON.DISTÜSTEL.DAĞ
Exponential distribution.
=EXPON.DIST(x, lambda, cumulative) - EXPONDISTÜSTELDAĞ
Exponential distribution.
=EXPONDIST(x, lambda, cumulative) - F.DISTF.DAĞ
F probability distribution (left tail).
=F.DIST(x, deg_freedom1, deg_freedom2, cumulative) - F.DIST.RTF.DAĞ.SAĞK
Right-tailed F distribution.
=F.DIST.RT(x, deg_freedom1, deg_freedom2) - F.INVF.TERS
Inverse left-tailed F distribution.
=F.INV(probability, deg_freedom1, deg_freedom2) - F.INV.RTF.TERS.SAĞK
Inverse right-tailed F distribution.
=F.INV.RT(probability, deg_freedom1, deg_freedom2) - F.TEST
F-test result.
=F.TEST(array1, array2) - FDISTFDAĞ
Right-tailed F distribution.
=FDIST(x, deg_freedom1, deg_freedom2) - FINVFTERS
Inverse right-tailed F distribution.
=FINV(probability, deg_freedom1, deg_freedom2) - FISHER
Fisher transformation.
=FISHER(x) - FISHERINVFISHERTERS
Inverse Fisher transformation.
=FISHERINV(y) - FORECASTTAHMİN
Predicts y for x by linear trend.
=FORECAST(x, known_ys, known_xs) - FORECAST.LINEARTAHMİN.DOĞRUSAL
Predicts y for x by linear trend.
=FORECAST.LINEAR(x, known_ys, known_xs) - FREQUENCYSIKLIK
Frequency distribution (vertical array).
=FREQUENCY(data_array, bins_array) - FTEST
F-test result.
=FTEST(array1, array2) - GAMMAGAMA
Gamma function.
=GAMMA(x) - GAMMA.DISTGAMA.DAĞ
Gamma distribution.
=GAMMA.DIST(x, alpha, beta, cumulative) - GAMMA.INVGAMA.TERS
Inverse gamma distribution.
=GAMMA.INV(probability, alpha, beta) - GAMMADISTGAMADAĞ
Gamma distribution.
=GAMMADIST(x, alpha, beta, cumulative) - GAMMAINVGAMATERS
Inverse gamma distribution.
=GAMMAINV(probability, alpha, beta) - GAMMALNGAMALN
Natural log of the gamma function.
=GAMMALN(x) - GAMMALN.PRECISEGAMALN.DUYARLI
Natural log of the gamma function.
=GAMMALN.PRECISE(x) - GAUSS
Probability between the mean and z.
=GAUSS(z) - GEOMEANGEOORT
Geometric mean.
=GEOMEAN(number1, [number2], ...) - GROWTHBÜYÜME
Values along an exponential trend (array).
=GROWTH(known_ys, [known_xs], [new_xs], [const]) - HARMEANHARORT
Harmonic mean.
=HARMEAN(number1, [number2], ...) - HYPGEOM.DISTHİPERGEOM.DAĞ
Hypergeometric distribution.
=HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative) - HYPGEOMDISTHİPERGEOMDAĞ
Hypergeometric distribution.
=HYPGEOMDIST(sample_s, number_sample, population_s, number_pop) - INTERCEPTKESMENOKTASI
Intercept of the linear regression line.
=INTERCEPT(known_ys, known_xs) - KURTBASIKLIK
Kurtosis.
=KURT(number1, [number2], ...) - LINESTDOT
Linear regression coefficients (array).
=LINEST(known_ys, [known_xs], [const], [stats]) - LOGESTLOT
Exponential curve coefficients (array).
=LOGEST(known_ys, [known_xs], [const], [stats]) - LOGINVLOGTERS
Inverse lognormal distribution.
=LOGINV(probability, mean, standard_dev) - LOGNORM.DISTLOGNORM.DAĞ
Lognormal distribution.
=LOGNORM.DIST(x, mean, standard_dev, cumulative) - LOGNORM.INVLOGNORM.TERS
Inverse lognormal distribution.
=LOGNORM.INV(probability, mean, standard_dev) - LOGNORMDISTLOGNORMDAĞ
Cumulative lognormal distribution.
=LOGNORMDIST(x, mean, standard_dev) - MAXAMAKA
Largest value including text and logicals.
=MAXA(value1, [value2], ...) - MINAMİNA
Smallest value including text and logicals.
=MINA(value1, [value2], ...) - MODEENÇOK_OLAN
Most frequent value.
=MODE(number1, [number2], ...) - MODE.MULTENÇOK_OLAN.ÇOK
All most frequent values (vertical array).
=MODE.MULT(number1, [number2], ...) - MODE.SNGLENÇOK_OLAN.TEK
Most frequent value.
=MODE.SNGL(number1, [number2], ...) - NEGBINOM.DISTNEGBİNOM.DAĞ
Negative binomial distribution.
=NEGBINOM.DIST(number_f, number_s, probability_s, cumulative) - NEGBINOMDISTNEGBİNOMDAĞ
Negative binomial distribution.
=NEGBINOMDIST(number_f, number_s, probability_s) - NORM.DISTNORM.DAĞ
Normal distribution.
=NORM.DIST(x, mean, standard_dev, cumulative) - NORM.INVNORM.TERS
Inverse of the normal distribution.
=NORM.INV(probability, mean, standard_dev) - NORM.S.DISTNORM.S.DAĞ
Standard normal distribution.
=NORM.S.DIST(z, cumulative) - NORM.S.INVNORM.S.TERS
Inverse of the standard normal distribution.
=NORM.S.INV(probability) - NORMDISTNORMDAĞ
Normal distribution.
=NORMDIST(x, mean, standard_dev, cumulative) - NORMINVNORMTERS
Inverse of the normal distribution.
=NORMINV(probability, mean, standard_dev) - NORMSDISTNORMSDAĞ
Standard normal cumulative distribution.
=NORMSDIST(z) - NORMSINVNORMSTERS
Inverse of the standard normal distribution.
=NORMSINV(probability) - PEARSON
Pearson correlation coefficient.
=PEARSON(array1, array2) - PERCENTILEYÜZDEBİRLİK
k-th percentile (0–1).
=PERCENTILE(array, k) - PERCENTILE.EXCYÜZDEBİRLİK.HRC
k-th percentile, exclusive.
=PERCENTILE.EXC(array, k) - PERCENTILE.INCYÜZDEBİRLİK.DHL
k-th percentile, inclusive.
=PERCENTILE.INC(array, k) - PERCENTRANKYÜZDERANK
Percentage rank of a value.
=PERCENTRANK(array, x, [significance]) - PERCENTRANK.EXCYÜZDERANK.HRC
Percentage rank, exclusive.
=PERCENTRANK.EXC(array, x, [significance]) - PERCENTRANK.INCYÜZDERANK.DHL
Percentage rank, inclusive.
=PERCENTRANK.INC(array, x, [significance]) - PERMUTPERMÜTASYON
Number of permutations.
=PERMUT(number, number_chosen) - PERMUTATIONAPERMÜTASYONA
Permutations with repetitions.
=PERMUTATIONA(number, number_chosen) - PHI
Standard normal density.
=PHI(x) - POISSON
Poisson distribution.
=POISSON(x, mean, cumulative) - POISSON.DISTPOISSON.DAĞ
Poisson distribution.
=POISSON.DIST(x, mean, cumulative) - PROBOLASILIK
Probability that values are between two limits.
=PROB(x_range, prob_range, lower_limit, [upper_limit]) - QUARTILEDÖRTTEBİRLİK
Quartile (0–4).
=QUARTILE(array, quart) - QUARTILE.EXCDÖRTTEBİRLİK.HRC
Quartile (1–3), exclusive.
=QUARTILE.EXC(array, quart) - QUARTILE.INCDÖRTTEBİRLİK.DHL
Quartile (0–4), inclusive.
=QUARTILE.INC(array, quart) - RANK
Rank of a number in a list (0 = descending).
=RANK(number, ref, [order]) - RANK.AVGRANK.ORT
Rank; ties get the average rank.
=RANK.AVG(number, ref, [order]) - RSQRKARE
Coefficient of determination (R²).
=RSQ(known_ys, known_xs) - SKEWÇARPIKLIK
Sample skewness.
=SKEW(number1, [number2], ...) - SKEW.PÇARPIKLIK.P
Population skewness.
=SKEW.P(number1, [number2], ...) - SLOPEEĞİM
Slope of the linear regression line.
=SLOPE(known_ys, known_xs) - STANDARDIZESTANDARTLAŞTIRMA
Normalized value (z-score).
=STANDARDIZE(x, mean, standard_dev) - STDEVSTDSAPMA
Sample standard deviation.
=STDEV(number1, [number2], ...) - STDEV.PSTDSAPMA.P
Population standard deviation.
=STDEV.P(number1, [number2], ...) - STDEVASTDSAPMAA
Sample std. deviation including text and logicals.
=STDEVA(value1, [value2], ...) - STDEVPSTDSAPMAS
Population standard deviation.
=STDEVP(number1, [number2], ...) - STDEVPASTDSAPMASA
Population std. deviation including text and logicals.
=STDEVPA(value1, [value2], ...) - STEYXSTHYX
Standard error of the predicted y.
=STEYX(known_ys, known_xs) - T.DISTT.DAĞ
Student's t-distribution (left tail).
=T.DIST(x, deg_freedom, cumulative) - T.DIST.2TT.DAĞ.2K
Two-tailed Student's t-distribution.
=T.DIST.2T(x, deg_freedom) - T.DIST.RTT.DAĞ.SAĞK
Right-tailed Student's t-distribution.
=T.DIST.RT(x, deg_freedom) - T.INVT.TERS
Inverse left-tailed t-distribution.
=T.INV(probability, deg_freedom) - T.INV.2TT.TERS.2K
Inverse two-tailed t-distribution.
=T.INV.2T(probability, deg_freedom) - T.TEST
Probability of Student's t-test.
=T.TEST(array1, array2, tails, type) - TDISTTDAĞ
Student's t-distribution (1 or 2 tails).
=TDIST(x, deg_freedom, tails) - TINVTTERS
Inverse two-tailed t-distribution.
=TINV(probability, deg_freedom) - TRENDEĞİLİM
Values along a linear trend (array).
=TREND(known_ys, [known_xs], [new_xs], [const]) - TRIMMEANKIRPORTALAMA
Mean excluding a percentage of outliers.
=TRIMMEAN(array, percent) - TTEST
Probability of Student's t-test.
=TTEST(array1, array2, tails, type) - VAR
Sample variance.
=VAR(number1, [number2], ...) - VAR.P
Population variance.
=VAR.P(number1, [number2], ...) - VAR.S
Sample variance.
=VAR.S(number1, [number2], ...) - VARA
Sample variance including text and logicals.
=VARA(value1, [value2], ...) - VARPVARS
Population variance.
=VARP(number1, [number2], ...) - VARPAVARSA
Population variance including text and logicals.
=VARPA(value1, [value2], ...) - WEIBULL
Weibull distribution.
=WEIBULL(x, alpha, beta, cumulative) - WEIBULL.DISTWEIBULL.DAĞ
Weibull distribution.
=WEIBULL.DIST(x, alpha, beta, cumulative) - Z.TEST
One-tailed z-test probability.
=Z.TEST(array, x, [sigma]) - ZTEST
One-tailed z-test probability.
=ZTEST(array, x, [sigma])
Stop memorising formulas. Describe them.
Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.
Try it free