View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kendrickmr@gmail.com is offline
external usenet poster
 
Posts: 4
Default Calculating Standard Deviation while ignoring Zeros

I am working with a large data set and I am interested in calculating
standard deviation of over 100 samples, but I want to ignore any zero
values and only utilize the non-zero values in the calculation. Does
anyone know an easy way to do this. Thanks for the help.
Mike