Difference between revisions of "Manuals/calci/COVAR"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | =COVAR( | + | =COVAR (Array1,Array2)= |
where, | where, | ||
| − | *<math> | + | *<math>Array1</math> is the first array of integers or reference to the cells containing array |
| − | *<math> | + | *<math>Array2</math> is the 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. | COVAR calculates the covariance, the average of the products of deviations for each data point pair in two arrays. | ||
| Line 9: | Line 9: | ||
== Description == | == Description == | ||
| − | COVAR( | + | COVAR (Array1,Array2) |
*COVAR is used to determine the relationship between two data sets. | *COVAR is used to determine the relationship between two data sets. | ||
| − | *Arguments <math> | + | *Arguments <math>Array1</math>, <math>Array2</math> can be numbers or can be names, arrays or references containing numbers. |
*Values containing text, logical values or empty cells are ignored. | *Values containing text, logical values or empty cells are ignored. | ||
| − | *If either <math> | + | *If either <math>Array1</math> or <math>Array2</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. | *The number of data points in <math>a1</math> and <math>a2</math> should be same, else Calci displays a #N/A error message. | ||
Revision as of 11:58, 6 June 2018
COVAR (Array1,Array2)
where,
- is the first array of integers or reference to the cells containing array
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2} is the second array of integers or reference to the cells containing array
is the first 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 (Array1,Array2)
- COVAR is used to determine the relationship between two data sets.
- Arguments Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2} can be numbers or can be names, arrays or references containing numbers.
- Values containing text, logical values or empty cells are ignored.
- If either Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1} or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2} is empty, Calci displays a NaN error message.
- The number of data points in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle a1} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle a2} should be same, else Calci displays a #N/A error message.
ZOS
- The syntax is to use the COVAR function in ZOS is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle COVAR (Array1,Array2)}
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2} are the set of values to find the Covariance.
- For e.g.,COVAR([10,20,15,17,19],[12,22,31,16,45])
- COVAR([50..57],[17..24])
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.
Related Videos
See Also
References