So I have 4 columns of data, shown below. The first column is the independent variable and the next 3 columns are the values of dependent variables.
1 223064 222724 222672 2 220066 219400 219298 3 217105 216128 215978 4 214105 212906 212709 5 211295 209732 209492
I would like to calculate the relative difference among the 3 dependent variables with respect to the variation in the independent variable, and the output should be a single value for each row. To clarify, the 3 (dependent variable) columns are values for the same event but for different times (independent variable) and they are diverging as we go downwards. Basically, I am trying to show the divergence of the data.
One way I can think of it is to calculate the difference among the columns themselves, ABS(1-2), ABS(2-3), ABS(3-1). Then Calculate the Mean and Standard Deviation of the 3 differences.
Is this a good way to do it? or, is there any other method to show the relative differences among the columns beside the above one suggested?