Forum Discussion
MEDIAN from aggregative data
Is there a way to find the median from aggregated data? For example, people were asked to rank something 1-5: 90x people ranked it 5 56x people ranked it 4 75x people ranked it 3 etc... H...
can't you just use MEDIAN( [range of cell with the rank vale])
If this is a one-off you can just 'count' from top and bottom and see where the middle is:
rank 5 : 90
rank 4 : 56
rank 3 : 75
rank 2 : 48
rank 1 : 31
total ; 299 so looking for #150 so rank 1 + 2 = 79 and ranks 1-3 = 154 so #150 is inside rank 3
If this is a one-off you can just 'count' from top and bottom and see where the middle is:
rank 5 : 90
rank 4 : 56
rank 3 : 75
rank 2 : 48
rank 1 : 31
total ; 299 so looking for #150 so rank 1 + 2 = 79 and ranks 1-3 = 154 so #150 is inside rank 3