LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PMK PMK is offline
external usenet poster
 
Posts: 2
Default Negative Standard Deviation?

I am working with a list of 15 - 20 whole numbers and calculating the mean,
one std dev above and one std dev below. My data consists of many 0 values
as well as high numbers over 100. My std dev -1 calculation is coming out
negative. I would expect a large variation but not a negative std dev.
Since I understand std dev is the square root of a square, I have to assume
operator error. Can someone clarify what may be my error, not seeing my
data, or confirming that std dev can be negative? Thanks for your help.
 
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
standard deviation Clem Charts and Charting in Excel 1 December 6th 09 03:24 PM
Standard Deviation Soccerboy83 Excel Discussion (Misc queries) 2 June 16th 09 01:27 AM
standard deviation Ina Excel Discussion (Misc queries) 2 August 23rd 07 03:06 PM
Standard Deviation Carlos Excel Worksheet Functions 10 January 2nd 06 09:17 AM
standard deviation Chris Excel Discussion (Misc queries) 1 October 13th 05 04:52 AM


All times are GMT +1. The time now is 02:21 AM.

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

About Us

"It's about Microsoft Excel"