|
|
| (3 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| − | =COVARIANCEDATAANALYSIS(Array, GroupBy, NewTableFlag)=
| + | Refer the page |
| | | | |
| − | where,
| + | *[[Manuals/calci/COVARIANCEDATAANALYSIS| COVARIANCEDATAANALYSIS]] |
| − | *<math>Array</math> is array of integers or reference to the cells containing array,
| |
| − | *<math>GroupBy</math> is a method that performs the analysis by Columns or Rows,
| |
| − | *<math>NewTableFlag</math> is a flag that determines how the output should be displayed.
| |
| − | | |
| − | COVARIANCEDATAANALYSIS() calculates the average of product of deviations of values from the means of each data set.
| |
| − | | |
| − | == Description ==
| |
| − | | |
| − | COVARIANCEDATAANALYSIS(Array, GroupBy, NewTableFlag)
| |
| − | | |
| − | *Covariance is a method used to determine the relationship between two data sets.
| |
| − | *<math>Array</math> can be numbers or can be names, arrays or references containing numbers.
| |
| − | *Values containing text, logical values or empty cells are ignored.
| |
| − | *Argument <math>GroupBy</math> can be "Rows" or "Columns".
| |
| − | *<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
| |
| − | *If <math>NewTableFlag</math> is TRUE, output is displayed on a new ZSpace cube. If <math>NewTableFlag</math> is FALSE, output is displayed on the same spreadsheet where command is written.
| |
| − | *If data is invalid, Calci displays NaN error message.
| |
| − | | |
| − | == Examples ==
| |
| − | | |
| − | <div id="5SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | {| id="TABLE3" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | Column2
| |
| − | | Column3
| |
| − | | Column4
| |
| − | | |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class=" " | 5
| |
| − | | class=" " | 3
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class=" " | 7
| |
| − | | class=" " | 8
| |
| − | | class=" " |
| |
| − | | class="sshl_f" |
| |
| − | | |
| − | |- class="odd"
| |
| − | | class=" " | Row3
| |
| − | | class=" " | 12
| |
| − | | class=" " | 8
| |
| − | | class=" " |
| |
| − | | class="sshl_f" |
| |
| − | | |
| − | |- class="even"
| |
| − | | class=" " | Row4
| |
| − | | class=" " | 17
| |
| − | | class=" " | 18
| |
| − | | class="sshl_f" |
| |
| − | | class=" " |
| |
| − | | |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class=" " | 41
| |
| − | | class=" " | 34
| |
| − | | class="sshl_f" |
| |
| − | | class=" " |
| |
| − |
| |
| − | |- class="even"
| |
| − | | class=" " | Row6
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class="sshl_f" |
| |
| − | | class=" " |
| |
| − | |}
| |
| − | | |
| − | </div>
| |
| − | | |
| − | =COVARIANCEDATAANALYSIS(A2:B5,"Columns",TRUE)
| |
| − | =COVARIANCEDATAANALYSIS(A2:B6,"Rows",TRUE)
| |
| − | | |
| − | ----
| |
| − | <div id="2SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | {| class="SpreadSheet blue"
| |
| − | |+ <br />Covariance by Columns
| |
| − | |- class="even"
| |
| − | !
| |
| − | ! Column1
| |
| − | ! Column2
| |
| − | |- class="odd"
| |
| − | | Column1
| |
| − | | 21.6875
| |
| − | | 23.4375
| |
| − | |- class="even"
| |
| − | | Column2
| |
| − | | 23.4375
| |
| − | | 29.6875
| |
| − | |}
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="9SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | {| class="SpreadSheet blue"
| |
| − | |+ <br />Covariance by Rows
| |
| − | |- class="even"
| |
| − | !
| |
| − | ! Row1
| |
| − | ! Row2
| |
| − | ! Row3
| |
| − | ! Row4
| |
| − | ! Row5
| |
| − | |- class="odd"
| |
| − | | Row1
| |
| − | | 1
| |
| − | | -0.5
| |
| − | | 2
| |
| − | | -0.5
| |
| − | | 3.5
| |
| − | |- class="even"
| |
| − | | Row2
| |
| − | | -0.5
| |
| − | | 0.25
| |
| − | | -1
| |
| − | | 0.25
| |
| − | | -1.75
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | 2
| |
| − | | -1
| |
| − | | 4
| |
| − | | -1
| |
| − | | 7
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | -0.5
| |
| − | | 0.25
| |
| − | | -1
| |
| − | | 0.25
| |
| − | | -1.75
| |
| − | |- class="odd"
| |
| − | | Row5
| |
| − | | 3.5
| |
| − | | -1.75
| |
| − | | 7
| |
| − | | -1.75
| |
| − | | 12.25
| |
| − | |}
| |
| − | </div>
| |
| − | | |
| − | == See Also ==
| |
| − | | |
| − | *[[Manuals/calci/COVAR | COVAR]] | |
| − | | |
| − | == References ==
| |
| − | | |
| − | *[http://en.wikipedia.org/wiki/Covariance Covariance]
| |