weighted average of overlapping polygons

Discussion created by lladefian on Nov 4, 2016
Latest reply on Sep 5, 2018 by atlhabitat

I'm trying to calculate a weighted average using the summary statistics tool using median HH Income census tracts and a single polygon for a target area.  So far I have been able to calculate the percentage of overlap for the target area and census tracts, however I'm a bit stuck on the summary statistics tool.  I keep getting a frequency of 1 so I'm unable to calculate the weighted average.  My statistical field is the percentage of target area times MHH Income, and case field is the Tract Name.  Here is a snapshot of the data: