Excel Function : VARP

Download now!

Excel Function : VARP




Calculates variance based on the entire population

Microsoft Excel Reference Page


Syntax and Description of the VARP Excel Function

as a string cell.setCellValue("=" + excelFunc); } else if(cellValue instanceof String) { //get syntax VARP excel function as a string cell.setCellValue("=" + excelFunc + "(" + cellValue + ")"); } } else if(excelFunc.equals("STDEVP")) { if(cellValue instanceof Double) {

About VARP Excel Function

The VARP function in Excel calculates the variance of a data set. The function takes as arguments a data set of values and returns the variance of the data set. The variance is a measure of how far the data set values are spread out from the mean, and is a useful statistic for analyzing data sets.