View Single Post
  #1   Report Post  
Harlan Grove
 
Posts: n/a
Default Why does excel use different denominator for variance and covarian

Ales wrote...
Why does excel use different denominator when calculating variance and


covariance? When working with samples it should be "n-1" in both

cases. Just
"n" when calculating covariance is by my humble opinion wrong.


There are a few sources that don't agree with you, e.g.,

http://documents.wolfram.com/applica...ies/1.5.1.html

But there are others that do. So it appears to be due to some ambiguity
in what's intended that doesn't originate with Excel.