Talk:Documentation/How Tos/Calc: COVAR function
From Apache OpenOffice Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Shouldn't the calculation of COVAR be (the sum of the products of the differences of x and y from their averages) divided by N, where N is the number of observations?
--MrProgrammer 20:18, 23 June 2010 (UTC)
COVAR ({−1; 1}; {−1; 1}) = 1
(−1) ⋅ (−1) + 1 ⋅ 1 = 2
--Yecril71pl 13:40, 15 March 2012 (UTC)
Yes, you are right. The description is wrong, but the functions itself calculates it the right way. Unfortunately the description error is in ODF standard too. Thanks for finding this.
Regina 22:32, 17 March 2012 (UTC)
