I have a vector layer across an area with several different polygons of varying size. Each polygon has a rate of fertilizer as an attribute. I would like to calculate the average rate of fertilizer across the area.
Initially, I used the tool
"Basic statistics for fields" but I realized that this tool just takes the average of the numbers in the attribute table without adjusting for the polygon sizes. This gives an incorrect average rate since there could be a large polygon with a very low rate, however, this large polygon would count towards the average as much as a very small polygon.
Is there a tool that allows me to calculate the average rate of fertilizer so that when I multiply the average rate by the area, I would get the correct amount of fertilizer needed for the farm?
I can calculate the correct average in Excel or using the field calculator, but I think there must be a faster way to do this in QGIS 3.12.0.