var

Previous chapterNext chapter Show allShow all    Hide allHide all

The function var (range) returns an estimation of the variance based on a random sample of the values in the defined area.

Formula:

Syntax: =var(range)

Example Example

Cells A1 to A10: any numbers

Cell A11 = var(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

352,9