Q: Calculate the mean per time slot ?
Hi Chaps,
I'm an absolute beginner on Numbers (almost everything on Mac i would say) and i need help to calculate mean values.
Those are calculated values (Column 2) taken on a precise moment of the day (Column 1).
I managed to create a third using an integrated function to get the time slot (Column 3).
14:58:42 | 235 | 14 |
14:59:42 | 274 | 14 |
15:00:50 | 7937 | 15 |
15:01:55 | 5157 | 15 |
16:02:57 | 1822 | 16 |
16:03:57 | 207 | 16 |
Can please someone show me step by step how to calculate the mean value per time slot like below?
14 | 254,5 |
15 | 6547 |
16 | 1014,5 |
Regards,
Pierre
Posted on Sep 17, 2016 10:13 AM
This may help you
assuming you data is in a table named "Data" and the information is summarized in another table (on the right) named "Summary"
select cell B1 of the summary table then type (or copy and paste from here):
=SUMIF(Data::C,A1,Data::B)÷COUNTIF(Data::C,A1)
shorthand for this is:
B1=SUMIF(Data::C,A1,Data::B)÷COUNTIF(Data::C,A1)
select cell B1, copy
select column B, paste
Posted on Sep 17, 2016 11:07 AM
