I am looking for a tool that can give me an area-weighted average.
I have a shapefile of parcels and another shapefile with Curve Numbers. I want to get Area Weighted CN for each parcel. If I do it manually, I would first intersect parcels with the Curve Number file. Recalculated Area for each feature in the intersected shapefile. Take the attributes to Excel and then use the Pivot table or Vlookup to find the sum of areas and sum of (CN*Area of each feature) for a particular parcel and then divide them to get the Area Weighted Curve Number.
Is there a tool to do it automatically in QGIS?