Hi all.
I have a bunch of data such as like below :
A B
1600 0.465479
1600 0.46517
1600 0.465345
1600 0.465609
1600 0.465238
1600 0.46523
1600 0.465233
1600 0.465259
1600 0.465573
1600 0.465054
1601 0.465829
1601 0.465234
1601 0.465543
1601 0.465356
1601 0.465435
1601 0.465553
1601 0.465236
1601 0.465473
1601 0.465245
1601 0.465429
1602 0.465726
1602 0.466014
1602 0.465897
1602 0.465528
1602 0.465673
1602 0.465692
1602 0.465918
1602 0.465958
1602 0.465756
1602 0.465843
how can I group those data and find the average of it.
As column A is the group while the column B is the data.
At the moment I just used '=Median(B1:B10)' ...but I have thousands of data.
Note that for each group, it is in a frequency of 10 data.
Thanks guys.
Aheye
Bookmarks