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...
=MEDIAN(IF(SEQUENCE(,SUM(count_array))<=count_array,bins_array))
=AGGREGATE(17,6,bins_array/(SEQUENCE(,SUM(count_array))<=count_array),2)