Works for Windows: Using the STD Function Formula (132420)


The information in this article applies to:

  • Microsoft Works 2.x
  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
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.
Modification Type:MajorLast Reviewed:10/6/2003
Keywords:kbinfo KB132420
©2003 Microsoft Corporation. All rights reserved.