Using multiple points to symbolize polygons?

Question

I have a table of bus stops with scores for each one and want to average the scores for the block group (polygon) that the stops are in. For example, if block group A has 3 bus stops with scores of 2, 3, and 4, I want the block group score to be 3.

I am unsure whether I need to do some kind of spatial join to connect the point(s) to the polygon. When I tried previously, the polygon layer attribute table would show that it had multiple joins, but it would only show one of the bus stop coordinates.

Thank you in advance, I appreciate any help!!!

rzufelt · Accepted Answer

The spatial join tool has a merge rule that allows you to join all the values into a single field when the join count > 1.  You can have it concatenate them with a delimiter, or, in your situation, there is a Mean option that will average them for you.

R_