Standard Deviation for population & sample?

Start networking and exchanging professional insights

Next Question:
Strategy A has an expected value of 10 and a standard deviation of 3. Strategy B...
Posted by:
Emad Mohammed said abdalla
29-July-2015

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

Statistics Analysis Microsoft Excel Data Analysis

Question added by Owais Akber , Senior Accountant , Modec Building Material Trading LLC
Date Posted: 2017/02/06

Upvote (0) Views (11) Followers (2) Answers (2) Report Question

Write an Answer
Register now or log in to answer.

2 Answers

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.

Upvote (1)

Downvote Reply () Report