Excel provides a variety of Statistical Functions that helps in analyzing data within a worksheet
What is TRIMMEAN function in Excel? TRIMMEAN function is one of Statistical functions in Microsoft Excel that 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 …
What is CORREL function in Excel? CORREL function is one of Statistical functions in Microsoft Excel that returns the correlation coefficient of the Array1 and Array2 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 …
What is TREND function in Excel? TREND function in Excel is a Statistical Function that computes the linear trend line based on the given linear set of data. TREND in Excel calculates the predictive values of Y for given array values of X and uses the least square method based on the given two data …
What is COUNTBLANK function in Excel? COUNTBLANK function is one of Statistical functions in Microsoft Excel used to count the number of empty cells in a range of cells. Syntax of COUNTBLANK function COUNTBLANK(range) The COUNTBLANK function syntax has the following arguments: Range Required. The range from which you want to count the blank cells. COUNTBLANK formula explanation Cells with formulas that return …
What is LOGNORM.DIST function in Excel? LOGNORM.DIST function is one of Statistical functions in Microsoft Excel that returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. Use this function to analyze data that has been logarithmically transformed. Syntax of LOGNORM.DIST function LOGNORM.DIST(x,mean,standard_dev,cumulative) The LOGNORM.DIST function syntax has the following …
What is MINA function in Excel? MINA function is one of Statistical functions in Microsoft Excel that returns the smallest value in the list of arguments. Syntax of MINA function MINA(value1, [value2], …) The MINA function syntax has the following arguments: Value1, value2, … Value1 is required, subsequent values are optional. 1 to 255 values for which …
What is STDEVPA function in Excel? STDEVPA function is one of Statistical functions in Microsoft Excel that 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). Syntax of STDEVPA function STDEVPA(value1, [value2], …) …
What is FORECAST function in Excel? FORECAST function is one of Statistical functions in Microsoft Excel that calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. …
What is LOGEST function in Excel? LOGEST function is one of Statistical functions in Microsoft Excel that r In regression analysis, calculates an exponential curve that fits your data and returns an array of values that describes the curve. Because this function returns an array of values, it must be entered as an array formula.The …
What is MIN function in Excel? MIN function is one of Statistical functions in Microsoft Excel that returns the smallest number in a set of values. Syntax of MIN function MIN(number1, [number2], …) The MIN function syntax has the following arguments: Number1, number2, … Number1 is optional, subsequent numbers are optional. 1 to 255 numbers for which …
What is STDEVA function in Excel? STDEVA function is one of Statistical functions in Microsoft Excel that 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). Syntax of STDEVA function STDEVA(value1, [value2], …) The STDEVA function syntax has the following arguments: Value1, …
What is FISHERINV function in Excel? FISHERINV function is one of Statistical functions in Microsoft Excel that returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x. Syntax of FISHERINV function FISHERINV(y) The FISHERINV function syntax has the following …
What is LINEST function in Excel? The LINEST function calculates the statistics for a line by using the “least squares” method to calculate a straight line that best fits your data, and then returns an array that describes the line. You can also combine LINEST with other functions to calculate the statistics for other types of models that are …
What is MAXIFS function in Excel? The MAXIFS function is one of Statistical functions in Microsoft Excel that returns the maximum value among cells specified by a given set of conditions or criteria. Note: This feature is available on Windows or Mac if you have Office 2019, or if you have an Office 365 subscription. If you …
What is STDEV.S function in Excel? STDEV.S function is one of Statistical functions in Microsoft Excel that estimates standard deviation based on a sample (ignores logical values and text in the sample).The standard deviation is a measure of how widely values are dispersed from the average value (the mean). Syntax of STDEV.S function STDEV.S(number1,[number2],…) The STDEV.S function syntax has …
What is FISHER function in Excel? FISHER function is one of Statistical functions in Microsoft Excel that returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient. Syntax of FISHER function FISHER(x) The FISHER function syntax has …
What is LARGE function in Excel? LARGE function is one of Statistical functions in Microsoft Excel that returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score. Syntax …
What is MAXA function in Excel? MAXA function is one of Statistical functions in Microsoft Excel that returns the largest value in a list of arguments. MAXA is similar to MINA. Syntax of MAXA function MAXA(value1,[value2],…) The MAXA function syntax has the following arguments: Value1: The first number argument for which you want to find the …
What is STANDARDIZE function in Excel? STANDARDIZE function is one of Statistical functions in Microsoft Excel that returns a normalized value from a distribution characterized by mean and standard_dev. Syntax of STANDARDIZE function STANDARDIZE(x, mean, standard_dev) The STANDARDIZE function syntax has the following arguments: X: The value you want to normalize. Mean: The arithmetic mean of the distribution. …
What is F.TEST function in Excel? F.TEST function is one of Statistical functions in Microsoft Excel that returns the result of an F-test, the two-tailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances. For example, given test scores from public …
What is KURT function in Excel? KURT function is one of Statistical functions in Microsoft Excel that 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. Syntax of KURT …
What is MEDIAN function in Excel? MEDIAN function is one of Statistical functions in Microsoft Excel that returns the median of the given numbers. The median is the number in the middle of a set of numbers. Syntax of MEDIAN function MEDIAN(number1, [number2], …) The MEDIAN function syntax has the following arguments: Number1, number2, … Number1 is …
What is SMALL function in Excel? SMALL function is one of Statistical functions in Microsoft Excel that returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set. Syntax of SMALL function SMALL(array, k) The SMALL function syntax has the following arguments: Array: An array …
What is GROWTH function in Excel? GROWTH function is one of Statistical functions in Microsoft Excel that calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an …
What is INTERCEPT function in Excel? INTERCEPT function is one of Statistical functions in Microsoft Excel that calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the INTERCEPT …
What is PERMUTATIONA function in Excel? PERMUTATIONA function is one of Statistical functions in Microsoft Excel that returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects. Syntax of PERMUTATIONA function PERMUTATIONA(number, number-chosen) The PERMUTATIONA function syntax has the following arguments: Number: An integer that …
What is GEOMEAN function in Excel? GEOMEAN function is one of Statistical functions in Microsoft Excel that 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. Syntax of GEOMEAN function GEOMEAN(number1, [number2], …) The GEOMEAN function …
What is HYPGEOM.DIST function in Excel? HYPGEOM.DIST function is one of Statistical functions in Microsoft Excel that returns the hypergeometric distribution. HYPGEOM.DIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size. Use HYPGEOM.DIST for problems with a finite population, where each observation is either a …
What is PERMUT function in Excel? PERMUT function is one of Statistical functions in Microsoft Excel that returns the number of permutations for a given number of objects that can be selected from number objects. A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from …
What is F.INV function in Excel? F.INV function is one of Statistical functions in Microsoft Excel that returns the inverse of the F probability distribution. If p = F.DIST(x,…), then F.INV(p,…) = x. The F distribution can be used in an F-test that compares the degree of variability in two data sets. For example, you …
What is GAUSS function in Excel? GAUSS function is one of Statistical functions in Microsoft Excel that calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean. Syntax of GAUSS function GAUSS(z) The GAUSS function syntax has the following arguments. Z Required. Returns …
What is HARMEAN function in Excel? NORM.DIST function is one of Statistical functions in Microsoft Excel that returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals. Syntax of HARMEAN function HARMEAN(number1, [number2], …) The HARMEAN function syntax has the following arguments: Number1, number2, … Number1 is required, …
What is PROB function in Excel? PROB function is one of Statistical functions in Microsoft Excel that returns the probability that values in a range are between two limits. If upper_limit is not supplied, returns the probability that values in x_range are equal to lower_limit. Syntax of PROB function PROB(x_range, prob_range, [lower_limit], [upper_limit]) The PROB function …
What is F.DIST.RT function in Excel? F.DIST.RT function is one of Statistical functions in Microsoft Excel that returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of …
What is GAMMALN.PRECISE function in Excel? GAMMALN.PRECISE function is one of Statistical functions in Microsoft Excel that returns the natural logarithm of the gamma function, Γ(x). Syntax of GAMMALN.PRECISE function GAMMALN.PRECISE(x) The GAMMALN.PRECISE function syntax has the following arguments: X Required. The value for which you want to calculate GAMMALN.PRECISE. GAMMALN.PRECISE formula explanation If x is nonnumeric, …
What is NORM.S.INV function in Excel? NORM.S.INV function is one of Statistical functions in Microsoft Excel that returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one. Syntax of NORM.S.INV function NORM.S.INV(probability) The NORM.S.INV function syntax has the following arguments: Probability: A probability corresponding …
What is POISSON.DIST function in Excel? POISSON.DIST function is one of Statistical functions in Microsoft Excel that returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute. Syntax of POISSON.DIST function …
What is F.DIST function in Excel? F.DIST function is one of Statistical functions in Microsoft Excel that returns the F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of men and women entering high school, and determine …
What is FREQUENCY function in Excel? FREQUENCY function is one of Statistical functions in Microsoft Excel that 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. Because FREQUENCY returns …
What is NORM.S.DIST function in Excel? NORM.S.DIST function is one of Statistical functions in Microsoft Excel that returns the standard normal distribution (has a mean of zero and a standard deviation of one). Use this function in place of a table of standard normal curve areas. Syntax of NORM.S.DIST function – Standard Normal Distribution NORM.S.DIST(z,cumulative) …