Breaking up data into intervals and matching to other data set
1 ビュー (過去 30 日間)
I have 2 data sets both consisting of 92 values (or 92 days). The first consists of rainfall data between 0 and 0.6mm. I would like to break the data up into 7 categories, days with 0 rainfall, 0-0.1mm, 0.1-0.2, 0.2-0.3, ect.
I then want to to match the days in which there was, ie. 0mm, to the corresponding days in the other data set (carbon concentration). And then say there were 10 days where there was 0 rainfall, make an average carbon concentration of those 10 days.
And then create a bar graph, comparing carbon concentration at 0mm, 0-0.1, 0.1-0.2, ect. (something like in the attached JPEG)
Any help would be much appreciated,
Have included data.