Name
DSTDEV
Synopsis
Use
DSTDEV to estimate the standard
deviation of a sample by using the numbers in the specified column of
a database table that match the conditions specified by the
Criteria argument.
To Calculate
=DSTDEV(Database,Field,Criteria)
All three arguments are required for this function.
Example
Figure 17-3 illustrates how to use DSTDEV to find the sample standard deviation of the sales amounts for the state of Texas. You can compare this to results of DSTDEVP, which finds the standard deviation for an entire population. DVAR and DVARP determine the sample and population variances for the number of sales within the state.
Figure 17-3. Use DSTDEV and DSTDEVP to find the standard deviation within a database table; use DVAR and DVARP to determine the variance
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
