DStDev, StDevP Functions Example

This example returns estimates of the standard deviation for a population and a population sample for orders shipped to the United Kingdom.  The domain is an Orders table.  The criteria argument restricts the data by making the expression apply only to records in which Ship Country equals UK.

X = DStDev("[Freight]", "Orders", "[Ship Country] = 'UK'")  ' Sample estimate.

Y = DStDevP("[Freight]", "Orders", "[Ship Country] = 'UK'") ' Population estimate.