How to calculate top 30% of a item list?

Follow

sr

• June 19, 2015 16:15

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?

0

• 

  Joel Stewart

  • June 19, 2015 17:24

  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.

  1

  Comment actions Permalink

Please sign in to leave a comment.