So I have an excel file (attached) that has different trials, all having different column sizes. I want to plot the average of these trials by agent (dex, propofol and alfax), so I should get three different lines for three different averages on the same plot. On the plot I want to display time on the x-axis (excel file: test_analyzingtimeHR.xlsx) and on the y-axis, i want to show the average HR (test_analyzingHR.xlsx).
However, this is being difficult because all these trials have different column sizes (WITHOUT NaNs). The largest column size without any NaNs is 1779. For this reason, I want to normalize all the trials so that all the trials have the same column size (1779). I also don't want any NaNs to show up in my matrices, as they're disrupting my calculations for averaging. Can anyone tell me how I could do this best?
I've attached my Matlab code in the attachments.
