-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: ODF 1.2
-
Fix Version/s: ODF 1.3
-
Component/s: OpenFormula, Part 4 (Formula) [1.2: 2]
-
Labels:None
-
Proposal:
-
Resolution:
Copied from office-comment list
Original author: Regina Henschel <rb.henschel@t-online.de>
Original date: 2012 15:35:56 -0700 (PDT)
Original URL: http://lists.oasis-open.org/archives/office-comment/201203/msg00000.html
I am quite sure that no implementation implements what the ODF standard currently requires, but that every implementation has a factor depending on n (the number of data pairs.) Unfortunately this factor could be 1/n (population covariance) or 1/(n-1) (sample covariance). Is suspect that implementations are using 1/n, since that is what was implemented in MS Excel, but we need to verify that.