View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Standard deviation

I have good news for you!

The limit of 30 only refers to the number of individual arguments.
Something like:

=STDEV(A1:A500) will work just fine.
--
Gary''s Student - gsnu200749


"Svi" wrote:

I have a datasheet with data of more than 30 people. I want to calculate the
standard deviation, but the Help function of Excel tells me that Stdev is
used for a group of max 30 persons. What function should I use to calculate
the standard deviation for a group of more than 30 people?

J.A. van Iwaarden