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 »

Sidebar