# Documentation/Calc Functions/VARP

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

VARP

## Category:

Statistical Analysis

## Summary:

Calculates the population variance of a set of numbers.

## Syntax:

VARP(**Number 1**[; **Number 2**[; ...[; **Number 255**]]])

## Returns:

Returns a non-negative real number which is the population variance of a set of numbers passed in the arguments.

## Arguments:

**Number 1**, **Number 2**, ..., **Number 255** are real numbers, an array of real numbers, reference to a cell or to cell ranges of numbers.

- If only one value is passed the function will return 0.
- If any of the arguments contain text values either being passed directly then the function returns a name (#NAME?) error and if passed with double quotes then the function returns an error value (Err:504).
- If a cell contains text, error value, or empty cells, then the function ignores these values. For logical values, TRUE is considered as 1 and FALSE is considered as 0.
- If a cell contains 0 then the function includes it.

## Additional details:

- The formula for VARP is:

where x_{i} is **Number i**, n is the count of x_{i}'s and x̄ is mean value.

- For more details on the variance of the entire population, visit Wikipedia.

## Examples:

Formula | Description | Returns |
---|---|---|

=VARP(3;4;5;6;2;3;1) | The function calculates the variance of the given population | 2.53061224489796 |

=VARP(A1:A5) where A1:A5 contains 1,2,3,4,5 | The function calculates the variance of the population passed as a reference to the cell. | 2 |

=VARP(3,4,-5,6.05,2,3,-1.5) | The function calculates the sample variance of the given population | 11.8278571428571 |

=VARP(3,"alpha",-5,6.05,2,3,-1.5) | The function returns an error value since one of the numbers is a string. | Err:504 |

=VARP(3) | The function will returns 0 since only one argument is passed. | 0 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

VARP