Solved

STDEV and STDEVP

Posted on 2006-09-21
2
3,869 Views
Last Modified: 2008-01-09
Hi:

A quick question. Can anyone let me know what exactly the difference is between STDEV and STDEVP? Thanks.
0
Comment
Question by:sdc248
2 Comments
 
LVL 13

Accepted Solution

by:
joechina earned 125 total points
ID: 17571921
The StDevP function evaluates a population, and the StDev function evaluates a population sample.

If your sample size is N.

StDev will divide by N
and StDevP will divide by N-1

http://en.wikipedia.org/wiki/Standard_deviation
0
 

Author Comment

by:sdc248
ID: 17572009
got it. Thanks.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question