Why does excel use different denominator for variance and covarian

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Ales wrote...
Why does excel use different denominator when calculating variance and
Click to expand...
covariance? When working with samples it should be "n-1" in both cases. Just
"n" when calculating covariance is by my humble opinion wrong.
Click to expand...

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

http://documents.wolfram.com/applications/timeseries/UsersGuidetoTimeSeries/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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Covariance Calculation 3
Calculated Item in Pivot table 1
sum of getpivotdata() 0
Auto calculating not working 4
RSQ problem: zero denominator 2
Conditional SUM for Budget, Actuals, & Variance YTD columns 0
Problem with Calculated item in Pivot Table 1
How do I calculate variance percetage if figures are negative 5

Back
Top