# STATISTICAL Articles: Excel and Google Sheets

All resources related to STATISTICAL for Excel and Google Sheets.

### STATISTICAL

Excel VAR Function
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...
Excel VAR.P Function
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,...
Excel VAR.S Function
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...
Excel VARP Function
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:...
Excel VARA Function
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...
Learn How to Use the Excel VARPA 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....
Excel QUARTILE.INC 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...
Learn How to Use Excel’s QUARTILE.EXC Function
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...
1 2 3 4