Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

Standard Deviation in Excel

I don't understand why the value of cell B9 is not equal the value in C8 in the attached spreadsheet. I think they both should be 3.741657.
standardDeviation.xlsx
0
allelopath
Asked:
allelopath
  • 3
  • 3
1 Solution
 
sdstuberCommented:
they are two different functions

B9 = stddevp(B2:B7)  deviation over entire population N
C8=B10 = stddev(B2:B7) deviation over "almost" entire population N-1

0
 
allelopathAuthor Commented:
Yes, but cell C8 is over the entire population, hence I would expect it to be the same as B9, which is also over the entire population.
0
 
sdstuberCommented:
VAR is also non-biased   i.e.  N-1  (not the entire population)


stddev = sqrt(var)  because both are non biased

stddevp <> sqrt(var)  because stddevp is biased
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
sdstuberCommented:
if you want biased variance over the entire population  use VARP  instead of VAR

stddevp = sqrt(varp)
0
 
allelopathAuthor Commented:
Oh. Is there VAR for N? I don't see a VARP function.
0
 
allelopathAuthor Commented:
oh yes I do ...
0
 
Patrick MatthewsCommented:
allelopath,

Your entire population has 7 members?  Really?

Sarcasm aside, you will nearly always want the sample stdev and sample variance; in actual practice, you will almost never have statistics for the entire population, and once your sample gets to a sufficient size, the difference between the sample and population versions of stdev and variance rapidly approaches zero.

Patrick
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now