Difference between revisions of "Manuals/calci/CORRELATIONDATAANALYSIS"

From ZCubes Wiki
Jump to navigation Jump to search
Line 27: Line 27:
|ROW2 || 0.9661943464912911 || 1
|ROW2 || 0.9661943464912911 || 1
==Related Videos==
{{#ev:youtube|v=zEXK6M93lb8|280|center|Correlation Analysis}}
==See Also==
==See Also==

Latest revision as of 18:07, 5 December 2018


  • is the set of numbers
  • is the group name.
  • is either 0 or 1.
    • CORRELATIONDATAANALYSIS(), compares two sets of data.


  • This function shows the correlation data analysis.
  • The Correlation coeffiecient shows the relationship between two continuous variables of each other.
  • In , is the set of numbers .
  • is the group name of correlation and is either "0" or"1".
  • We can use the CORREL function to find the correlation coefficient between two variables.
  • This is also called Pearson's correlation coefficient.
  • It is a measure of the strength of the association between the two variables.
  • The correlation coefficient should not be calculated if the relationship is not linear.
  • Positive correlation indicates that both variables increase or decrease together, whereas negative correlation indicates that as one variable increases, so the other decreases, and vice versa.


  1. CORRELATIONDATAANALYSIS([[56,56,65,65,50,25,87,44,35],[87,91,85,91,75,28,122,66,58]],"rows",1)
ROW1 1 0.9661943464912911
ROW2 0.9661943464912911 1

Related Videos

Correlation Analysis

See Also


Correlation Data Analysis