LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Banner
 
Posts: n/a
Default Standard Deviation

Hi:
I have tried to use STDEV() to find the Standard Deviation of a large range
of cells that contains many blanks, assuming that the blanks would be
ignored, however, I have found that the blanks were given the value of 0. I
tested this by trying to find the Standard Deviation of a range of blank
cells and every cell was given the value of 0. I must be doing something
wrong but I don't know what it is.
I hope that someone can help me out here.
Thanks

Stan


 
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 Stan Banner Excel Worksheet Functions 1 March 11th 06 09:11 PM
A question about Standard Deviation bombayterror Excel Discussion (Misc queries) 2 January 5th 06 03:46 PM
Relative standard deviation in Excel Dennis Falkenstrøm Excel Worksheet Functions 1 December 6th 05 11:55 AM
feel that the STANDARD DEVIATION formula on Excel is incorrect !! Ganapati Hegde Excel Worksheet Functions 3 November 18th 05 04:09 PM
How to calculate 2 standard deviation? Li Excel Worksheet Functions 1 April 12th 05 09:44 PM


All times are GMT +1. The time now is 03:19 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"