Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

VARP

Description: Calculates variance based on the entire population (ignores logical values and text in the population).

Syntax: VARP(Number1, Number2, ...)

Remarks:

where x is the sample mean AVERAGE(Number1, Number2, …) and n is the sample size.

Example:

Using the data from the VAR example and assuming that only 10 tools are produced during the production run, VARP measures the variance of breaking strengths for all the tools.

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.