varp

Previous chapterNext chapter Show allShow all    Hide allHide all

The function varp (range) returns an estimation of the variance based on all the values in the defined area.

Formula:

Syntax: =varp(range)

Example Example

Cells A1 to A10: any numbers

Cell A11 = varp(A1:A10)

 

R / C

A

1

745,00

2

730,00

3

732,00

4

768,00

5

769,00

6

747,00

7

718,00

8

723,00

9

766,00

10

739,00

11

317,61