In this tutorial, you will learn how to calculate average percentage in Excel.
Although figuring out the average proportion of something may appear simple, this idea can be trickier to understand than you might think. While you might be able to simply average two percentages by adding them together and dividing by the total number of percentages used in some situations, in other cases you might need to take the sample size into account.
Different processes are needed to calculate the average of two or more percentages compared to two or more normal values. When calculating average %, there are several factors to consider, including the fact that you frequently need to first determine the actual numbers that a percentage represents.
For instance, in a school, students prefer sports 50% of the time, compared to teachers who prefer them 70% of the time. What will the average percentage be now?
Before moving to the tutorial, let’s familiarize ourselves with the Excel functions we will be using to calculate average percentage.
Table of Contents
Anatomy of AVERAGE Functions
AVERAGE(number1, [number2], …)
The AVERAGE function returns the average or mean of a set of data.
Once ready, we’ll get started by utilizing real-world examples to show you how to calculate average percentages in Excel.
Calculate Average Percentage in Excel
Before we begin we will need a group of data to calculate the average percentage in Excel.
First, you need to have a clean and tidy group of data to work with.
First, we need to calculate the number of preferences in both students and teachers with the given percentage of preferences. To do you, you can simply multiply the preference percentage by the total number of teachers and students.
We will then add up the number of preferred students and teachers.
To find the average percentage we can simply divide the total number of preferences of teacher and student against the total number. We then turn it into a percentage by converting the cell formatting to a percentage.
Once you are done, your Excel will look something like this.