Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default STDEV

Hi!

The most probable explanation is that the values are calculated and only
appear to be the same. The true underlying values are different. You can
check by selecting the cells and changing the format to number and
increasing the decimal place.

Biff

"Kimo" wrote in message
...
For some numbers (e.g. 1.35, 2.8, 11.73) the standard deviation of the
three
same numbers do not result to 0. Why? I tried it on four different
computers.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
average and stdev from groups of data Charlie Excel Worksheet Functions 2 January 9th 06 03:56 AM
StDev Results Michael Excel Discussion (Misc queries) 1 August 22nd 05 09:33 PM
AVERAGE and STDEV functions with logic t-rung Excel Worksheet Functions 1 May 26th 05 07:11 PM
STDEV...HELP JRH New Users to Excel 5 January 22nd 05 08:47 PM
GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS Non-zero return for Stdev Excel Worksheet Functions 2 December 16th 04 08:44 AM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"