percentile ranking

[Thomas2syllables]

What are the best steps to calculate percentile ranking in FileMaker?

Thanks,

Thomas

[RalphL]

How is your data stored? How much data are you going to include? Do you really need percentile?

[Thomas2syllables]

I figured this out. I exported the data to Excel, used the countif function and the vlookup function to calculate percentile ranking, then imported the data back into FileMaker.

Is it necessary. Well someone in my college administration thinks so, so I gotta do it. Anyway, if anyone wants step-by-steps I'd be glad to share them.

_Thomas_

http://ddl.dyc.edu/~aclab/

[RalphL]

Too bad. If you had answered my questions we might have done it all in filemaker. My question was does it have to be percentile, would dectile have worked? Or maybe some other fraction.

Also I need to know how your data was stored, i.e., where there many records or was it all in one record.

The size of the data might also determine the method.

[normdouglas]

Did someone say Excel...?

Sum(TestField) / Status(CurrentRecordCount)

OR

Count(TestField) / Status(CurrentRecordCount)

OR

Based on a relationship

Sum(Match::TestField) yadda yadda

I only ever make my users resort to Excel for pure adhoc reporting.

[RalphL]

It is much more complex than what you suggest. The data must be in sorted order and then dividen into groups the represent 1% of the total number. There can be duplicate values so some groups may be larger than others. The 99 percentile means that 99% of the scores are lower than members of this group.

[merlyn383]

I know this post is kind of old, but it's the closest thing I can find to what I'm trying to do.

How does one automatically do percentiles in FM? I'm dealing with a significant amount of data (up to 750 records and possibly 18 separate percentiles for each record). Also, to make matters more complicated, not every record in the file should be compared for all percentiles.

Example: 2 sections of the same class, i want to compare student X's performance in section 1 with the rest of the student's in section 1, but not to any student's in section 2, and vice versa.

Is this possible (considering the section constraint)? If not, how do i do it without the constraint?