Microsoft KB Archive/132420

= Works for Windows: Using the STD Function Formula =

Article ID: 132420

Article Last Modified on 10/6/2003

-

APPLIES TO


 * Microsoft Works 2.11 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * 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.

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

Keywords: kbinfo KB132420

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.