I am trying to use Excel to figure out which xPAP settings might be correlating with my side effects.
I am using the =correl(xx4:xx368,yy4:yy368) function (and not the data package) in Excel 2016.
This allows the values to update as new data gets entered.
I am getting quite different results depending on whether I leave a cell in an array empty or enter a value =0, and would appreciate advice on which is correct.
In Detailed***.pdf for example I leave the cells empty when there are no side effects.
LeaveCellsEmpty
In Revised Detailed***.pdf I have entered a Zero in the cells for which there are no side effects.
EnterZeroCells
The results are quite different.
To any Excel experts/statisticians out there: which method is correct please?
Thanks in advance.