Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 01 Apr 2017 11:12:52 +0200How to crosstabulate numeric time series data?https://ask.libreoffice.org/en/question/91854/how-to-crosstabulate-numeric-time-series-data/ I have some time series data, with the date in column A, and other variables in columns B, C, D...etc. So each row has data specific to that date. All the data, apart from the dates, are numeric.
I want to create a two (or more) column list where each row has the range of values from B in the first column and the average of the corresponding values in C in the second column. So for example a cell in the first column would be for values of B that are equal to or more than 7 and less than 8, and the adjacent cell in the second column would be the average of all the cells in column C where the value in B in the same row is equal to or more than 7 and less than 8. As well as the average I would also like to have columns for the standard deviation, max, min, etc.
What is the easiest or quickest way of doing that please?
So far I have made a column for each range of values in column B, and then the values from C are shown in the column only if B is within a particular range. The columns are then averaged, etc. But this creates a very large table and is tedious to set up.
I have been reading about Pivot Tables, but have seen nothing about sorting numeric values. galaxianSat, 01 Apr 2017 11:12:52 +0200https://ask.libreoffice.org/en/question/91854/