Category: Aggregate

Syntax: VarianceP ( field {; field...} )


fieldAny related field, repeating field, or set of non-repeating fields that represent a collection of numbers.

Data type returned: Number


Returns the variance of a population represented by the non-blank values in the parameter list. Variance of population is a statistical measure of how spread out a set of values is.

The StDevP() of a set of numbers is the square root of the VarianceP() of the set.


The variance of a population represented by a set of numbers can be calculated by summing the squares of the distance of each value from the mean, then dividing by n, where n is the number of values.

For instance, given the set of numbers 8, 10, and 12, the mean of the set is 10. The distance of each value from the mean is -2, 0, and 2. The squares of these distances are 4, 0, and 4, and the sum of the squares is 8. The VarianceP is 8 divided by (3), which is 2.67.

 VarianceP (8; 10; 12)

Returns 2.67.

 VarianceP (7; 11; 15)

Returns 10.66.

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: