Report Certain Percentile Value

C

Charles Deng

Hi All:

I posted a message regarding this topic but no one
answered. That message is not clear. Now I want to
explain what I need to do.

I have a data set which contains Dept, Course, and GPA.
For each course, the range of GPA is different. But I need
to report a certain percentile value (such as top 75
percentile value) of GPA for each course and department.
As you know, the range of GPA (min to max) is quite
different for each course as well as each department. Is
there any code or formular I can use to report this value
to my report? Any advice will be highly appreciated.


Charles
 
Top