Average Percentage Calculator

The average percentage is a single value that represents the central tendency of a set of percentage figures. When all percentages come from equally-sized groups, it is simply their arithmetic mean. When the groups differ in size, a weighted average must be used so that larger groups have proportionally more influence on the result.

For a simple average, add all the percentage values together and divide by how many there are: average = (p1 + p2 + … + pn) / n. For a weighted average, multiply each percentage by its corresponding weight (sample size), sum those products, then divide by the total of all weights: average = (p1×w1 + p2×w2 + … + pn×wn) / (w1 + w2 + … + wn).

Yes, but you need to be careful about context. If each percentage represents the same-sized group (e.g. the same number of students per class), a simple arithmetic mean is valid. If the groups differ in size, using a simple average can be misleading — you should use a weighted average instead to get a mathematically correct result.

Simply sum all your percentage values and divide by the count of values for a simple average. For example, averaging 70%, 80%, and 90% gives (70 + 80 + 90) / 3 = 80%. If the percentages apply to groups of different sizes, weight each value by its group size before summing and dividing by the total group size.

Add all four percentages together and divide by 4. For instance, (50% + 60% + 70% + 80%) / 4 = 65%. If the four percentages apply to groups with different numbers of observations, multiply each by its group size, sum the results, and divide by the combined group size to get the weighted average.

Use a weighted average whenever each percentage is derived from a sample or group of a different size. For example, if one class has 200 students with a 70% pass rate and another has 20 students with a 90% pass rate, the simple average (80%) overstates the true rate — the weighted average correctly accounts for the much larger first class.

For a simple average in Excel, use =AVERAGE(range) where range contains your percentage values. For a weighted average, use the SUMPRODUCT function: =SUMPRODUCT(percentages_range, weights_range) / SUM(weights_range). Make sure your percentages are entered as numbers (e.g. 75 for 75%) rather than as decimal fractions for consistent results.

A simple average treats every percentage equally regardless of how many observations it represents. A weighted average assigns more influence to percentages that come from larger samples. The two methods give the same result only when all weights (sample sizes) are equal. In most real-world scenarios involving groups of different sizes, the weighted average is the more accurate measure.