Excel Function : VARP
Category
Compatibility
Description
Calculates variance based on the entire population
Microsoft Excel Reference Page
https://support.office.com/en-us/article/VARP-function-26a541c4-ecee-464d-a731-bd4c575b1a6b
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.
