Knowledge Base

Works for Windows: Using the STD Function Formula

Article ID: 132420

Article Last Modified on 10/6/2003

APPLIES TO

This article was previously published under Q132420

SUMMARY

The Works STD function computes standard deviation for a population. This corresponds to the STDEVP function in Microsoft Excel. To get a sample standard deviation as provided by the STDEV function in Microsoft Excel, use the formula: 
   STD(RangeReferences)*SQRT(COUNT(RangeReferences)/(COUNT
      (RangeReferences)-1))
NOTE: Type formula without line break.

MORE INFORMATION

The formula used by the STD function, standard deviation of a population, is 
   SQRT((n* SUM(x^2)-( SUM(x)^2))/n^2)
where x is each data point and n is the total number of data points.

The sample standard deviation formula, the more common form of standard deviation, is 
   SQRT((n*SUM(x^2)-( SUM(x)^2))/(n*(n-1)))
where x is each data point and n is the total number of data points.

For more information about the STD formula, see your "Microsoft Works User's Guide" or Works' online help.

Additional query words: kbhowto 2.00 2.00a 3.00 3.00a 3.00b w_works wrong calculation forms funct

Keywords: kbinfo KB132420


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.