STATISTICAL Articles: Excel and Google Sheets

The VAR function in Excel estimates the variance of a sample of data, while ignoring empty cells, text and logical values.  This step by step tutorial will assist all levels of Excel users in the usage and syntax of the VAR function. Figure 1. Final result: Excel VAR function Final...

Figure 1.VAR.P Function in Excel Let's assume that we have a range of data representing a population sample, we are going to make use of the Excel VAR.P function to determine the of variance the entire population. Generic Formula =VAR.P (number1, [number2], ...) number1 is the first reference or number,...

Figure 1. Excel VAR.S Function. Let's say we have a data set - which represents a whole population - and we want to determine its variance, we must use the Excel VAR.S Function. Generic Formula =VAR.S (number1, [number2], ...) number 1 is the first reference or number. number 2 is...

The VARP function in Excel calculates the variance of an entire population of data, ignoring text and logical values.  This step by step tutorial will assist all levels of Excel users in the usage and syntax of the VARP function.   Figure 1. Final result: Excel VARP function Final formula:...

The VARA function in Excel estimates the variance of a sample of data, and is capable of evaluating text and logical values.  This step by step tutorial will assist all levels of Excel users in the usage and syntax of the VARA function. Figure 1. Final result: Excel VARA function...

We can use the statistical Excel VARPA function to calculate the variance of a population. This calculation can include text and logical values. Logical values like TRUE, FALSE and TEXT has the values of 1, 0 and 0 respectively. This article will step through the use of the VARPA function....

Figure 1. Excel QUARTILE.INC Function. If our goal is to obtain the quartile in a data set of (four separate percentiles), we must utilize the Excel QUARTILE.INC function. Generic Formula =QUARTILE.INC (array, quart) array = data reference to analyze. quart = value of quartile to be determined The Excel QUARTILE.INC...

Figure 1. Excel QUARTILE.EXC Function If our goal is to obtain the quartile in a data set of (three separate percentiles), we must utilize the Excel QUARTILE.EXC function. Generic Formula =QUARTILE.EXC(array, quart) • array = data reference to analyze. • quart = value of quartile to be determined The Excel...