Skip to main content

VARPA

Definition

Calculates the variance based on an entire population, setting text to the value `0`.

 

Sample Usage

VARPA(1,2,3,4,5,6,7,8,9,10)

VARPA(A2:A100)

Syntax

VARPA(value1, [value2, ...])

  • value1 - The first value or range of the population.

  • value2, ... - Additional values or ranges to include in the population.

Notes

  • Although VARPA is specified as taking a maximum of 30 arguments, Excellentable supports an arbitrary number of arguments for this function.

  • If the total number of values supplied as value arguments is not at least two, VARPA will return the #NUM! error.

  • VARPA sets each text value encountered to 0 for the purpose of calculation. To return an error upon encountering text, use VARP.

  • VARPA calculates variance for an entire population. To calculate variance across a sample, use VARA.

  • VARPA takes the sum of the squares of each value's deviation from the mean and divides by the number of such values. This differs from the calculation of variance across a sample in that the latter divides by the size of the dataset minus one.

See Also

VARP: Calculates the variance based on an entire population.

VARA: Calculates the variance based on a sample, setting text to the value `0`.

VAR: Calculates the variance based on a sample.

STDEVPA: Calculates the standard deviation based on an entire population, setting text to the value `0`.

STDEVP: Calculates the standard deviation based on an entire population.

STDEVA: Calculates the standard deviation based on a sample, setting text to the value `0`.

STDEV: Calculates the standard deviation based on a sample.

SKEW: Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.

KURT: Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.

DVARP: Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.

DVAR: Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.

DSTDEVP: Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.

DSTDEV: Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.

DEVSQ: Calculates the sum of squares of deviations based on a sample.

AVEDEV: Calculates the average of the magnitudes of deviations of data from a dataset's mean.

In order to use the VARPA formula, start with your edited Excellentable:

Then type in the VARPA formula in the area you would like to display the outcome:

By adding the values you would like to calculate the VARPA formula for, Excellentable will generate the outcome:

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.