1

I need to find the top 20% of a data attribute of a data table in JMP. Excel has a Top-Bottom Rule that help find the same but JMP doesn't quite have it. Is there anyway to figure the top 20% of a column in JMP?

1201ProgramAlarm
  • 32,384
  • 7
  • 42
  • 56
pheno
  • 437
  • 1
  • 4
  • 13

1 Answers1

2

You can use the Col Quantile function to get the value corresponding to any percentile. Top 20% cutoff would be:

Col Quantile(:Calories, 0.8);

0.5 would be the median.

xan
  • 7,511
  • 2
  • 32
  • 45