Dear all,
I have four data sets from which I want to be able to calculate a mean and standard deviation of the individual corresponding cells.
A simple task in itself, however the problem I’m faced with is that the arrangement of the data varies slightly from each dataset. For example, one data set may have 9 columns and 11 rows with numeric values in each cell and the next may have 11 columns and 10 rows.
Thus it impossible to match corresponding cell values with each dataset and calculate mean and standard deviation of each cell.
I need to be able to manipulate the data into a standard format such 10 column by 10 row format (the datasets are actually much larger than this).
I believe some form of interpolation may be necessary although I’ve no idea how this would work.
I would be very grateful if anyone could provide some guidance on this.
Many thanks.
I have four data sets from which I want to be able to calculate a mean and standard deviation of the individual corresponding cells.
A simple task in itself, however the problem I’m faced with is that the arrangement of the data varies slightly from each dataset. For example, one data set may have 9 columns and 11 rows with numeric values in each cell and the next may have 11 columns and 10 rows.
Thus it impossible to match corresponding cell values with each dataset and calculate mean and standard deviation of each cell.
I need to be able to manipulate the data into a standard format such 10 column by 10 row format (the datasets are actually much larger than this).
I believe some form of interpolation may be necessary although I’ve no idea how this would work.
I would be very grateful if anyone could provide some guidance on this.
Many thanks.
