|
|
(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]
| |