Here is the data in raw format:
61% is the linear average![]()
30%|4 85%|5 50%|2 60%|1 80%|3 61%|59%
59% is the inverted weighted average, using the naive-and-not-so-generic formula I gave earlier (except I had more columns in my original sheet/formula)
Bookmarks