Difference between revisions of "Manuals/calci/COVARIANCE"

Latest revision as of 23:18, 8 February 2017

Refer the page

COVARIANCEDATAANALYSIS

@@ 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.
-==ZOS==
-*The syntax is to calculate this function in ZOS is  <math>COVARIANCEDATAANALYSIS (2D-Array,GroupBy,NewTableFlag)</math>
-*<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 which is either TRUE or FALSE.
-*For e.g., COVARIANCEDATAANALYSIS([[10,13,16,19,22],[29,27,34,41,56]],"columns",true)
-*COVARIANCEDATAANALYSIS([[33..39],[57..63]],"columns",false)
-== Examples ==
-Consider the following table with two arrays as input data.
-<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)
-----
-Output for the above examples is displayed respectively.
-<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>
-==Related Videos==
-{{#ev:youtube|ualmyZiPs9w|280|center|Covariance}}
-== See Also ==
-*[[Manuals/calci/COVAR | COVAR]]
-== References ==
-*[http://en.wikipedia.org/wiki/Covariance Covariance]

Difference between revisions of "Manuals/calci/COVARIANCE"

Latest revision as of 23:18, 8 February 2017

Navigation menu

Search