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

Hi,

What help means is that you can only pass 30 arguments to stdev for example:-

=stdev(a1,a2,a3-------A30) is OK
=stdev(a1,a2,a3-------A50) isn't OK
but this

=STDEV(A1:A100)

calculates the standard deviation for 100 cells and only counts as a single
argument.


Mike

"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

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

Hi

The limitation of 30, is to 30 sets of data, not 30 individuals.
Supposing you have numbers in A1:A50
=STD(A1:A50) will produce the standard deviation of those 50 values.

You could have =STD(A1:A50,B20:B90,C10, etc ....)
The 30 refers to the number of entries between the commas.

--
Regards
Roger Govier



"Svi" wrote in message
...
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

STDEV can take up to 30 separate arguments. If you have a contiguous range
(such as A1:C99), than counts as one argument.
--
David Biddulph

"Svi" wrote in message
...
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

OK. That's clear.

Thanks

J.A. van Iwaarden

"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