Difference between revisions of "Talk:Documentation/How Tos/Calc: COVAR function"
From Apache OpenOffice Wiki
MrProgrammer (Talk | contribs) (Created page with '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? --~~…') |
Yecril71pl (Talk | contribs) (example) |
||
| Line 2: | Line 2: | ||
--[[User:MrProgrammer|MrProgrammer]] 20:18, 23 June 2010 (UTC) | --[[User:MrProgrammer|MrProgrammer]] 20:18, 23 June 2010 (UTC) | ||
| + | |||
| + | COVAR ({−1; 1}; {−1; 1}) = 1 | ||
| + | (−1) ⋅ (−1) + 1 ⋅ 1 = 2 | ||
| + | |||
| + | --[[User:Yecril71pl|Yecril71pl]] 13:40, 15 March 2012 (UTC) | ||
Revision as of 13:40, 15 March 2012
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)
