Excel Statistical Functions

Excel VARPA Function

This post will guide you how to use the VARPA function with syntax and examples in Microsoft excel. Description The Excel VARPA function returns the variance of a population based on an entire population of numbers, text, or logical values. The variance is used to identify the amount that the values vary from the average value… read more »

Excel VARP Function

This post will guide you how to use the VARP function with syntax and examples in Microsoft excel. Description The Excel VARP function returns the variance of a population based on an entire population of numbers. This function has been replaced by the VAR.P function in Excel 2010. The variance is used to identify the amount… read more »

Excel VARA Function

This post will guide you how to use the VARA function with syntax and examples in Microsoft excel. Description The Excel VARA function returns the variance of a population based on a sample of numbers, text, or logical values. The variance is used to identify the amount that the values vary from the average value across… read more »

Excel VAR Function

This post will guide you how to use the VAR function with syntax and examples in Microsoft excel. Description The Excel VAR function returns the variance of a population based on a sample of numbers. This function has been replaced by the VAR.S function in Excel 2010. The variance is used to identify the amount that… read more »

Excel STDEVPA Function

This post will guide you how to use the STDEVPA function with syntax and examples in Microsoft excel. Description The Excel STDEVPA function returns the standard deviation of a population based on an entire population of numbers, text or logical values. So the STDEVPA function can evaluate the text and logical values that appear in cell… read more »

Excel STDEVP Function

This post will guide you how to use the STDEVP function with syntax and examples in Microsoft excel. Description The Excel STDEVP function returns the standard deviation of a population based on an entire population of numbers. This function has been replaced by the STDEV.P function in Excel 2010. The standard deviation is used to identify… read more »

Excel STDEVA Function

This post will guide you how to use the STDEVA function with syntax and examples in Microsoft excel. Description The Excel STDEVA function returns the standard deviation of a population based on a sample of numbers, text, and logical values. So the STDEVA function can evaluate the text and logical values that appear in cell references… read more »

Excel STDEV Function

This post will guide you how to use the STDEV function with syntax and examples in Microsoft excel. Description The Excel STDEV function returns the standard deviation of a population based on a sample of numbers. This function has been replaced by the STDEV.S function in Excel 2010. The standard deviation is used to identify the… read more »

Excel SLOPE Function

This post will guide you how to use the SLOPE function with syntax and examples in Microsoft excel. Description The Excel SLOPE function returns the slope of the linear regression line through data points in known_y’s and know_x’s. So you can use this function to calculate the slope of the linear regression line through a given… read more »

Excel RANK Function

This post will guide you how to use the RANK function with syntax and examples in Microsoft excel. Description The Excel RANK function returns the rank of a given number in a supplied range of cells.  If there are duplicated values in a list of values, it will be set the same rank. This function has… read more »

Excel QUARTILE Function

This post will guide you how to use the QUARTILE function with syntax and examples in Microsoft excel. Description The Excel QUARTILE function returns the quartile from a supplied range of values. This function has been replaced with QUARTILE.EXC function and QUARTILE.INC function. The QUARTILE function is a build-in function in Microsoft Excel and it is… read more »

Excel PERMUT Function

This post will guide you how to use the PERMUT function with syntax and examples in Microsoft excel. Description The Excel PERMUT function returns the number of permutations for a given number of items. The PERMUT function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function. The PERMUT function is… read more »

Excel CHITEST Function

This post will guide you how to use the CHITEST function with syntax and examples in Microsoft excel. Description The Excel CHITEST function returns the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom. So you can the chi-square test to calculate the probability that the differences between two given date… read more »

Excel CHIINV function

This post will guide you how to use the CHIINV function with syntax and examples in Microsoft excel. Description The Excel CHIINV function returns the inverse of the right-tailed probability of the chi-squared distribution.  For example, if the probability is equal to CHIDIST(x,…), then the CHIINV(probability,…) is equal to x. The CHIINV function is a build-in… read more »

Excel CHIDIST function

This post will guide you how to use the CHIDIST function with syntax and examples in Microsoft excel. Description The Excel CHIDIST function returns the right-tailed probability of the chi-squared distribution. The CHIDIST function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function. The CHIDIST function is available in Excel… read more »

Excel BINOM.INV function

This post will guide you how to use the BINOM.INV function with syntax and examples in Microsoft excel. Description The Excel BINOM.INV function returns the inverse of the Cumulative Binomial Distribution that is greater than or equal to a criterion value. And this function will return the smallest value for which the cumulative binomial distribution. The… read more »

Excel BINOMDIST Function

This post will guide you how to use the BINOMDIST function with syntax and examples in Microsoft excel. Description The Excel BINOMDIST function returns the individual term binomial distribution probability. For example, you can use the BINOMDIST function to calculate the probability that two of the next three babies born are male in Excel. And this… read more »

Excel PERCENTRANK Function

This post will guide you how to use the PERCENTRANK function with syntax and examples in Microsoft excel. Description The Excel PERCENTRANK function returns the rank of a value in a set of values as a percentage of the set. So you can use the PERCENTRANK function to calculate the relative position of a value in… read more »

Excel PERCENTILE Function

This post will guide you how to use the PERCENTILE function with syntax and examples in Microsoft excel. Description The Excel PERCENTILE function returns the kth percentile from a supplied range of values. So you can use the PERCENTILE function to determine the 30% percentile in a range in Excel. This function has been replaced by… read more »

Excel MODE.SNGL Function

This post will guide you how to use the MODE.SNGL function with syntax and examples in Microsoft excel. Description The Excel MODE.SNGL function returns the most frequently occurring number found in an array or range of numbers. If there are two or more frequently occurring numbers in a range of data, it will return the lowest… read more »

Sidebar