VARP

Calculates variance based on the entire population

Syntax

VARP(value1, [value2])

Arguments

Argument	Description	Required
value1	The first number or array of numbers in the population	Required
value2	Additional numbers or arrays	Optional

Examples

Population variance of test scores

Population variance of all values

Entire population measurements

Related Functions

Other Statistical functions:

• AVEDEV - Returns the average of the absolute deviations of data points from their mean
• AVERAGE - Returns the average of given arguments. Text is ignored.
• CORREL - Returns the correlation coefficient between two data sets
• COUNT - Returns the count of numeric values in a dataset.
• COUNTA - Returns the count of values in a list of arguments including text, logical values, error values, and empty text.
• COUNTIF - Returns the count of cells that meet a specified criteria
• COUNTIFS - Returns the count of criteria_ranges based on the given criterions.
• FORECAST - Calculates, or predicts, a future value by using existing values
• LARGE - Returns the k-th largest value in a data set
• MAX - Returns the largest number from the provided arguments
• MEDIAN - Returns the median of the given numbers
• MIN - Returns the smallest number from the provided arguments
• MODE - Returns the most frequently occurring value in a data set
• PERCENTILE - Returns the k-th percentile of values in a range
• RANK - Returns the rank of a number from the list of other numeric values
• SMALL - Returns the k-th smallest value in a data set
• STDEV - Returns the estimated standard deviation based on a sample
• STDEVP - Calculates standard deviation based on the entire population
• SUMIF - Returns the sum of a range depending on criteria
• SUMPRODUCT - Returns the sum of products for a list of arguments
• VAR - Returns the estimated variance for a sample of data

---

← Back to Formula Reference