Negative Standard Deviations
Several times I have seen Excel's STDEV function return a negative value as the standard deviation of a some collection of numbers. Perhaps I am ignorant but this seems quite wrong to me. Does anyone know why this happens, what it means, and what, if anything can be done about it?
Thanks for any help.