Difference between revisions of "Manuals/calci/COVAR"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">COVAR (a1, a2)</font></font> <font size="3"><font face="Times New Roma...") |
|||
| Line 1: | Line 1: | ||
| − | + | =COVAR(a1,a2)= | |
| − | < | + | where, |
| + | *<math>a1</math> first array of integers or reference to the cells containing array | ||
| + | *<math>a2</math> second array of integers or reference to the cells containing array | ||
| − | + | COVAR calculates the covariance, the average of the products of deviations for each data point pair in two arrays. | |
| − | + | == Description == | |
| − | |||
| − | |||
| − | + | COVAR(a1,a2) | |
| − | < | + | *COVAR is used to determine the relationship between two data sets. |
| + | *Arguments <math>a1</math>, <math>a2</math> can be numbers or can be names, arrays or references containing numbers. | ||
| + | *Values containing text, logical values or empty cells are ignored. | ||
| + | *If either <math>a1</math> or <math>a2</math> is empty, Calci displays a NaN error message. | ||
| + | *The number of data points in <math>a1</math> and <math>a2</math> should be same, else Calci displays a #N/A error message. | ||
| − | + | == Examples == | |
| − | |||
| − | |||
| − | < | + | <div id="2SpaceContent" class="zcontent" align="left"> |
| − | + | {| id="TABLE3" class="SpreadSheet blue" | |
| + | |- class="even" | ||
| + | | class="sshl_f" |'''Array 1''' | ||
| + | | class=" " |'''Array 2''' | ||
| + | | class=" " | | ||
| − | + | |- class="odd" | |
| + | | class="sshl_f" |2 | ||
| + | | class=" " |21 | ||
| + | | class=" " | | ||
| − | + | |- class="even" | |
| + | | class="sshl_f" |4 | ||
| + | | class=" " |22 | ||
| + | | class=" " | | ||
| − | + | |- class="odd" | |
| + | | class="sshl_f" |6 | ||
| + | | class=" " |23 | ||
| + | | class=" " | | ||
| − | + | |- class="even" | |
| + | | class="sshl_f" |8 | ||
| + | | class=" " |24 | ||
| + | | class=" " | | ||
| − | + | |- class="odd" | |
| + | | class="sshl_f" |10 | ||
| + | | class=" " |25 | ||
| + | | class=" " | | ||
| − | + | |} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | =COVAR(A2:A6,B2:B6) : Returns ''4'' as the output. | |
| + | =COVAR(A2:A5,{12,13,14,15}) : Returns '2.5'' as the output. | ||
| − | + | == See Also == | |
| − | + | *[[Manuals/calci/COVARIANCE | COVARIANCE]] | |
| − | |||
| − | |||
| − | + | == References == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[http://en.wikipedia.org/wiki/Covariance Covariance] | |
| − | |||
Revision as of 09:57, 21 January 2014
COVAR(a1,a2)
where,
- first array of integers or reference to the cells containing array
- second array of integers or reference to the cells containing array
first array of integers or reference to the cells containing array
second array of integers or reference to the cells containing arrayCOVAR calculates the covariance, the average of the products of deviations for each data point pair in two arrays.
Description
COVAR(a1,a2)
- COVAR is used to determine the relationship between two data sets.
- Arguments , can be numbers or can be names, arrays or references containing numbers.
- Values containing text, logical values or empty cells are ignored.
- If either or is empty, Calci displays a NaN error message.
- The number of data points in and should be same, else Calci displays a #N/A error message.
Examples
| Array 1 | Array 2 | |
| 2 | 21 | |
| 4 | 22 | |
| 6 | 23 | |
| 8 | 24 | |
| 10 | 25 |
=COVAR(A2:A6,B2:B6) : Returns 4 as the output.
=COVAR(A2:A5,{12,13,14,15}) : Returns '2.5 as the output.