There are total 110 Statistical functions in MS Excel . These functions are given below : 1.) AVEDEV : Returns the average of the absolute deviations of data points from their mean . Arguments can be numbers or names , arrays , or references that contain numbers . 2.) AVERAGE : Returns the average ( arithmetic mean ) of its arguments , which can be numbers or names, arrays, or references that contain numbers . 3.) AVERAGEA : Returns the average (arithmetic mean) of its arguments , evaluating text and False in arguments as 0 ; TRUE evaluates as 1 . Arguments can be numbers , names , arrays , or references . 4.) AVERAGEIF : Finds average (arithmetic mean) for the cells specified by a given condition or criteria . 5.) AVERAGEIFS : Finds average (arithmetic mean) for the cells specified by a given set of conditions or criteria . 6.) BETA.DIST : Returns the beta probability distribution function . 7.) BETA.INV : Returns the inverse of the cumulative beta probability density function (BETA.DIST) . 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 greater than or equal to a criterion value . 11.) CHISQ.DIST : Returns the left-tailed probability of the chi-squared distribution . 12.) CHISQ.DIST.RT : Returns the right-tailed probability of the chi-squared distribution . 13.) CHISQ.INV : Returns the inverse of the left-tailed probability of the chi-squared distribution . 14.) CHISQ.INV.RT : Returns the inverse of the right-tailed probability of the chi-squared distribution . 15.) CHISQ.TEST : Returns the test for independence: the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom. 16.) CONFIDENCE.NORM : Returns the confidence interval for a population mean, using a normal distribution . 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 the number of cells in a range that contain numbers . 20.) COUNTA : Counts the number of cells in a range that are not empty . 21.) COUNTBLANK : Counts the number of empty cells in a specified range of cells . 22.) COUNTIF : Counts the number of cells within a range that meet the given condition . 23.) COUNTIFS : Counts the number of cells specified by a given set of conditions or criteria . 24.) COVARIANCE.P : Returns population covariance, the average of the products of deviations for each data point pair in two data sets . 25.) COVARIANCE.S : Returns sample covariance, the average of the products of deviations for each data point pair in two data sets . 26.) DEVSQ : Returns the sum of squares of deviations of data points from their sample mean . 27.) EXPON.DIST : Returns the exponential distribution . 28.) F.DIST : Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets . 29.) F.DIST.RT : Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets . 30.) F.INV : Returns the inverse of the (left-tailed) F probability distribution: if p= F.DIST (x,..), then F.INV(p,...) = x . 31.) F.INV.RT : Returns the inverse of the (right-tailed) F probability distribution: if p =F.DIST.RT(x,...), then F.INV.RT(p,...) = x . 32.) F.TEST : Returns the result of an F-test, the two-tailed probability that the variance in Array1 and Array2 are not significantly different . 33.) FISHER : Returns the Fisher transformation . 34.) FISHERINV : Returns the inverse of the Fisher transformation: if y=FISHER(x), then FISHERINV(y)=x . 35.) FORECAST.ETS : Returns the forecasted value for a specific future target date using exponential smoothing method . 36.) FORECAST.ETS.CONFINT : Returns the confidence interval for the forecast value at the specified target date. 37.) FORECAST.ETS.SEASONALITY : Returns the length of the repetitive pattern Microsoft Excel detects for the specified time series . 38.) FORECAST.ETS.STAT : Returns the requested statistics for the forecast . 39.) FORECAST.LINEAR : Calculates, or predicts, a future value along a linear trend by using existing values . 40.) FREQUENCY : Calculates how often values occur within the range of values and then returns a vertical array of numbers having once more element than Bins_array . 41.) GAMMA : Returns the Gamma function value . 42.) GAMMA.DIST : Returns the gamma distribution . 43.) GAMMA.INV : Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x . 44.) GAMMALN : Returns the natural logarithm of the gamma function . 45.) GAMMALN.PRECISE : Returns the natural logarithm of the gamma function . 46.) GAUSS : Returns 0.5 less than the standard normal cumulative distribution . 47.) GEOMEAN : Returns the geometric mean of an array or range of positive numeric data . 48.) GROWTH : Returns numbers in an exponential growth trend matching known data points . 49.) HARMEAN : Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals . 50.) HYPGEOM.DIST : Returns the hypergeometric distribution . 51.) INTERCEPT : Calculates the point at which a line will intersect they y-axis by using a best-fit regression line plotted through the known x-values and y-values . 52.) KURT : Returns the kurtosis of a data set . 53.) LARGE : Returns the k-th largest value in a data set . For example, the fifth largest number . 54.) LINEST : Returns statistics that describe a linear trend matching known data points, by fitting a straight line using the least squares method . 55.) LOGEST : Returns statistics that describe an exponential curve matching known data points . 56.) LOGNORM.DIST : Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev . 57.) 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 . 58.) MAX : Returns the largest value in a set of values . Ignores logical values and text . 59.) MAXA : Returns the largest value in a set of values . Does not ignore logical values and text . 60.) MAXIFS : Returns the maximum value among cells specified by a given set of conditions or criteria . 61.) MEDIAN : Returns the median, or the number in the middle of the set of given numbers . 62.) MIN : Returns the smallest number in a set of values . Ignores logical values and text . 63.) MINA : Returns the smallest value in a set of values . Does not ignore logical values and text . 64.) MINIFS : Returns the minimum value among cells specified by a given set of conditions or criteria . 65.) MODE.MULT : Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of data . For a horizontal array , use = TRANSPOSE(MODE.MULT(number1.number2,...)) . 66.) MODE.SNGL : Returns the most frequently occurring, or repetitive, value in an array or range of data . 67.) 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 . 68.) NORM.DIST : Returns the normal distribution for the specified mean and standard deviation . 69.) NORM.INV : Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation . 70.) NORM.S.DIST : Returns the standard normal distribution (has a mean of zero and a standard deviation of one) . 71.) NORM.S.INV : Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one ) . 72.) PEARSON : Returns the Pearson product moment correlation coefficient, r . 73.) PERCENTILE.EXC : Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive . 74.) PERCENTILE.INC : Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive . 75.) PERCENTRANK.EXC : Returns the rank of a value in a data set as a percentage of the data set as a percentage (0..1, exclusive) of the data set . 76.) PERCENTRANK.INC : Returns the rank of a value in a data set as a percentage of the data set as a percentage (0..1, inclusive) of the data set . 77.) PERMUT : Returns the number of permutations for a given number of objects that can be selected from the total objects . 78.) PERMUTATIONA : Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects . 79.) PHI : Returns the value of density function for a standard normal distribution . 80.) POISSON.DIST : Returns the Poisson distribution . 81.) PROB : Returns the probability that values in a range are between two limits or equal to a lower limit . 82.) QUARTILE.EXC : Returns the quartile of a data set, based on percentile values from 0..1, exclusive . 83.) QUARTILE.INC : Returns the quartile of data set, based on percentile values from 0..1, inclusive . 84.) 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 . 85.) RANK.EQ : 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 top rank of that set of values is returned . 86.) RSQ : Returns the square of the Pearson product moment correlation coefficient through the given data points . 87.) SKEW : Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean . 88.) 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 . 89.) SLOPE : Returns the slope of the linear regression line through the given data points . 90.) SMALL : Returns the k-th smallest value in a data set. For example, the fifth smallest number . 91.) STANDARDIZE : Returns a normalized value from a distribution characterized by a mean and standard deviation . 92.) STDEV.P : Calculates standard deviation based on the entire population given as arguments (ignores logical values and text) . 93.) STDEV.S : Estimates standard deviation based on a sample (ignores logical values and text in the sample) . 94.) STDEVA : Estimates standard deviation based on a sample, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1 . 95.) STDEVPA : Calculates standard deviation based on an entire population, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1 . 96.) STEYX : Returns the standard error of the predicted y-value for each x in a regression . 97.) T.DIST : Returns the left-tailed Student's t-distribution . 98.) T.DIST.2T : Returns the two-tailed Student's t-distribution . 99.) T.DIST.RT : Returns the right-tailed Student's t-distribution . 100.) T.INV : Returns the left-tailed inverse of the Student's t-distribution . 101.) T.INV.2T : Returns the two-tailed inverse of the Student's t-distribution . 102.) T.TEST : Returns the probability associated with a Student's t-Test . 103.) TREND : Returns numbers in a linear trend matching known data points, using the least squares method . 104.) TRIMMEAN : Returns the mean of the interior portion of a set of data values . 105.) VAR.P: Calculates variance based on the entire population (ignores logical values and text in the population) . 106.) VAR.S : Estimates variance based on a sample (ignores logical values and text in the sample) . 107.) VARA : Estimates variance based on a sample, including logical values and text . Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1 . 108.) VARPA : Calculates variance based on the entire population, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1 . 109.) WEIBULL.DIST : Returns the Weibull distribution . 110.) Z.TEST : Returns the one-tailed P-value of a z-test .
Visit our blogs to know more about excel formulas & functions
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
0 Comments