When You Can and Cannot Just Average Percentages
Adding percentages together and dividing by the count, the simple mean , is only safe when every value describes a group of the same size. Three test scores of 70%, 80% and 90%, each out of the same total, average cleanly to 80%, because each score carries as much information as the others. Once the group sizes differ, the shortcut starts to mislead. A 90% result from a quiz taken by 30 students tells you more about the class than an 80% result from 20 students, and treating the two as equals distorts the summary. The same trap catches anyone blending conversion rates from pages with very different traffic, or combining exam papers with different point totals. This tool covers both situations: leave the weight fields empty and it returns a simple mean, or enter a weight for each row and it switches to a weighted average that reflects how much data each percentage covers.