FUNCTION: STDEVP
SELECT STDEVP(field) AS [expression]
FROM table
[WHERE ...]
[GROUPBY ...]
[HAVING ...]
The STDEVP function is one of the aggregate functions
that are used to calculate statistical information
for a specified numeric field in a query.
The other aggregate functions are: AVG, COUNT, MAX, MIN, STDEV,
SUM, VAR, VARP.
Note that all of these functions return a single value.
The STDEVP function finds the standard deviation by using all of
values in a field.
In comaparison, the STDEV function only uses a protion,
called a sample, of the values to calculate the standard deviation.
There must be at least two values in the field or the standard
deviation will not be calculated and a NULL value is returned.
This code finds the standard deviation of the age for all MediCare patients
in a hospital and stores that information in DevAge.
SELECT STDEVP(Age) AS [DevAge]
FROM MediCarePatients
Copyright 2000 by Infinite Software Solutions, Inc.
Trademark Information
|