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)