Talk:Documentation/How Tos/Calc: COVAR function

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)