Hi,
I have a coulmn of +60 data points (a sampling of weight over time) and would like to create samples of 2,3,4....,10 data points for further calculations. Basically a matrix consisting of sample y and sizes x. Now, I've tried using the data analysis toolpack, but periodic sampling only sample the datapoint at each period and not a group as I would like. In genereal, I've tried many approaches, but no one seems to fit. More specific, I would like to do the following:
Coulmn of samples -> Group into samples of size x -> convert into row, showing the grouped sample 1 consisting of the x datapoints, sample 2 consisting of the x datapoints....... sample y consisting of x datapoints.
So for example, if I have a column of 60 samples I would like to sort them into groups of 2,3,4...10 going up from sample 1-60. For group size = 3 I would get 20 groups of samples and for 10, 6 groups with 10 samples. How to do this in an automated way rather than manually copy-paste-transpose the data?
Bookmarks