title: How to sum correlation, or, calculate correlation of disjointed variables
body: <p>I'm trying to calculate the correlation of 2 array of variables, but the array is disjointed in the middle - but I'm trying to obtain one correlation coefficient </p>
  
  <p>Example;</p>
  
  <pre><code>x:1, 2, [disjointed], 5.1, 5.2, 5.3, 5.4, 5.5, 5.6
  
  y:2, 4, [disjointed], 9.1, 9, 8.9, 8.8, 8.7, 8.6
  </code></pre>
  
  <p><strong>See the excel file I uploaded: <a href="http://www.qfpost.com/file/d?g=1UfQx3cUj" rel="nofollow">http://www.qfpost.com/file/d?g=1UfQx3cUj</a></strong></p>
  
  <p>because the disjoint in the middle, there is somewhat a jump in value and when I correlate the whole set of variable together I obtain a correlation coefficient that is not really reflective of the relationship between the variables</p>
  
  <p>How would I be able to calculate one correlation coefficient? I can calculate two separate correlations but is there anyway to sum 2 correlation together? </p>
  
  <p>Thank you Sirs</p>
  
  <p>[Edit: formatting &amp; also added link to excel file]</p>