Ok so column A and Column F have dates in (see spreadsheet)
I want to see what the correlation is between column "H" Balance and column "C" Balance.
I know the dates need to be equal on both the columns irrespective of whether or not there was a positive or negative gain that given day. So system 1 may have a positive "Percentage Gain" on the 06/04/2014 where as system 2 does not have any positive gain or negative loss. So therefore there still needs and entry for the 06/04/2014 with "0.0%" within the corresponding percentage gain box. The balance would of course for system 2 remain unchanged.
I do not know how to do this but I do know that this accurate comparison is required in order to carry out the correlation analysis.
Any brain bots want to have a look at the spread-sheet, please feel free
Bookmarks