Posted to microsoft.public.excel.programming

[email protected] kendrickmr@gmail.com is offline

external usenet poster

Posts: 4

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Calculating Conditional Standard Deviation?	Harimau	Excel Worksheet Functions	5	June 27th 07 01:40 PM
standard deviation	freddie mac	Excel Programming	1	August 4th 06 05:17 PM
Standard Deviation	Stan Banner	Excel Worksheet Functions	1	March 12th 06 12:54 AM
Histrogramms: Calculating average and standard deviation	Jens Eichelbaum	Excel Worksheet Functions	2	November 23rd 04 02:10 AM

All times are GMT +1. The time now is 03:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us