Calculating the n-th percentile of all point features that fall within a polygon

Discussion created by hayvic on Sep 27, 2011
Latest reply on Feb 6, 2014 by curtvprice
Hi everyone,

I'm new to ArcGIS (GIS in general) and the forums so I appologise if this is not the correct place for this question. Please move it if this is not the case.

The problem I'm having is stated in the title. I have a feature class with points containing several attributes. I also have a class containing polygons that represent neighbourhoods. Now I need a way to calculate the n-th percentile of all points that fall within a certain neighbourhood and also add this percentile to the class. With my limited knowledge of ArcMAP I have come up with the following approach:

1: Join the points to the polygons
2: Add a new field to the attribute table
3: Calculate percentiles with the field calculator using a VB script.

The problem with this approach is that I don't know VB. I do have it written down in pseudo code though. My question really is, if there is another way to accomplish this? Searching the support resources didn't do me any good. I also couldn't find a VB script. If anyone could point me in the right direction it would be very much appreciated.