Should I use STDEVP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grd - 21 Nov 2005 19:23 GMT

Hi,

When should I use STDev and when should I use STDevP.?

I get the basic idea of Standard Deviation but I don't understand the
differences between the two functions.

Could anyone help explain the differences?

Thanks in advance

grd

Reply to this Message

JE McGimpsey - 21 Nov 2005 19:31 GMT

Did you take a look at Help?

STDEV:
Estimates standard deviation based on a sample.

STDEVP:
Calculates standard deviation based on the entire population given as
arguments.

So, in general, if your data represents the entire population, use
STDEVP, otherwise, use STDEV. Note that for large samples, the functions
return nearly the same value.

> Hi,
>
[quoted text clipped - 8 lines]
>
> grd

Reply to this Message

Grd - 21 Nov 2005 23:56 GMT

thanks

grd

> Did you take a look at Help?
>
[quoted text clipped - 21 lines]
> >
> > grd

Reply to this Message