Excel VAR Function

Use:

Computes variance of a set of sample data

Syntax:

VAR( range )

Examples:

Cell D12 formula: VAR( C4:G4 )

Cell D13 formula: VAR( D3:D9 )
Cell D14 formula: VAR( C3:G9 )
Cell D15 formula: VAR( D3:D9,G3:G9 )

Note:

VAR uses a denominator of N-1 instead of N

Related Functions:

VARP, STDEV, STDEVP, AVEDEV