Microsoft KB Archive/102145

From BetaArchive Wiki

Mac Works: Standard Deviation Function Returns a Zero

PSS ID Number: Q102145 Article last modified on 10-22-1998

2.0 3.0 4.0

MACINTOSH

======================================================================

The information in this article applies to:

  • == Microsoft Works for the Macintosh, versions 2.0, 3.0 and 4.0 ==

SUMMARY

In Microsoft Works 2.0 and 3.0, the StDev function will deliver a zero if all of the numbers in a given selection are of equal value.

Example

If you have the following cells:

A1: 5 A2: 5 A3: 5 A4: 5 A5: 5 A6: =stdev(a1:a5)

Works will return a zero in A6.

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 2.00 3.00 mac mwksss m_eXcel 0 O

Version : 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.