Excel Function

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 »

Sidebar