ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Should I use STDEVP (https://www.excelbanter.com/excel-worksheet-functions/56614-should-i-use-stdevp.html)

Grd

Should I use STDEVP
 
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

JE McGimpsey

Should I use STDEVP
 
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.


In article ,
Grd wrote:

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


Grd

Should I use STDEVP
 
thanks

grd

"JE McGimpsey" wrote:

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.


In article ,
Grd wrote:

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




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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com