How to calculate top 30% of a item list?
For example in a class the student and their marks are
a,10
b,9
c,8
d,7
e,6
f,5
g,4
h,3
i,2
j,1
The student in top 30% are a,b,c. How do we calculate this in datameer? And how do we do ranks in Datameer?
-
I'd recommend reviewing the GROUPPERCENTILE function.
With this function, one can identify the percentile grouping at an arbitrary level. If needed, later in the workbook, one could add a filter to display only results above or below this threshold.
Please sign in to leave a comment.
Comments
1 comment