Changes

*Suppose the <math>r</math> value is 0 then there is no correlation (the values don't seem linked at all).  

*Suppose the <math>r</math> value is 0 then there is no correlation (the values don't seem linked at all).  

*If we have a series of <math>n</math> measurements of <math>X</math> and <math>Y</math> written as <math>xi</math> and <math>yi</math> where <math>i = 1, 2,...n</math> then the Sample Correlation Coefficient is:

*If we have a series of <math>n</math> measurements of <math>X</math> and <math>Y</math> written as <math>xi</math> and <math>yi</math> where <math>i = 1, 2,...n</math> then the Sample Correlation Coefficient is:

  <math>CORREL(X,Y)= r_{xy}= \frac{\sum_{i=1}^n (xi-\bar x)(yi-\bar y)}{\sqrt{ \sum_{i=1}^n (xi-\bar x)^2 \sum{i=1}^n (yi-\bar y)^2}}</math>

  <math>CORREL(X,Y)= r_{xy}= \frac{\sum_{i=1}^n (xi-\bar x)(yi-\bar y)}{\sqrt{ \sum_{i=1}^n (xi-\bar x)^2 \sum_{i=1}^n (yi-\bar y)^2}}</math>

*<math>\bar x</math> and <math>\bar y</math> are the sample means of <math>X</math> and <math>Y</math>.

*<math>\bar x</math> and <math>\bar y</math> are the sample means of <math>X</math> and <math>Y</math>.

*This function will give the result as error when  

*This function will give the result as error when