Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Standard Deviation for population & sample?

What is the use of these to kind of standard deviations? and how they affect the result? standard deviation - population --> excel formula stdev.p standard deviation - sample --> excel formula stdev.s

user-image
Question added by Owais Akber , Senior Accountant , Modec Building Material Trading LLC
Date Posted: 2017/02/06
Priya Kanangot
by Priya Kanangot , Senior Accountant , Sharjah Electricity Water and Gas Authority

If the data given is sample from population, use sample formula. If it's of whole population, have to use population formula. The difference is for sample the denominator is N-1 where as for population it is N. The formula is Square root of [total of squares of (x-average)]/N for population and Square root of [total of squares of (x-average)]/N-1 for sample.

Aamir Ali
by Aamir Ali , INTERNEES , (NBP)

standard deviation use to find out  the how spared out the data from mean value,