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.