Table of Contents
Calculating the average age in Excel is a simple and efficient way to analyze a set of ages and determine the overall average age. To do so, you can use the AVERAGE function, which takes the sum of all ages and divides it by the total number of ages. For example, if you have a list of ages in cells A1 to A10, the formula would be =AVERAGE(A1:A10). This will give you the average age of the 10 individuals. By using this function, you can easily calculate the average age of any group of people or data set in Excel.
Calculate Average Age in Excel (With Example)
Often you may want to calculate the average age in Excel based on a list of birth dates.
For example, suppose you would like to know the average age of people in the following dataset:
The following step-by-step example shows how to calculate the average age.
Step 1: Enter the Data
First, let’s enter the date of births for 10 individuals:
Step 2: Convert Date of Birth to Age
Next, we can type the following formula into cell C2 to calculate the age of the first individual:
=YEARFRAC(B2,NOW())We can then click and drag this formula down to each remaining cell in column C:
Step 3: Calculate Average Age
Next we can type the following formula into cell E2 to calculate the average age of all individuals in this list:
=AVERAGE(C2:C11)The following screenshot shows how to use this formula in practice:
If you would instead like to display the average age in terms of years and months, you can type the following formula into cell F2:
=INT(E2) & " years, " & INT((E2-INT(E2))*12) & " months"
The following screenshot shows how to use this formula in practice:
We can see that the average age of these individuals is 46 years and 3 months old.
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How do I calculate the average age in Excel? Can you provide an example?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-calculate-the-average-age-in-excel-can-you-provide-an-example/
stats writer. "How do I calculate the average age in Excel? Can you provide an example?." PSYCHOLOGICAL SCALES, 22 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-calculate-the-average-age-in-excel-can-you-provide-an-example/.
stats writer. "How do I calculate the average age in Excel? Can you provide an example?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-calculate-the-average-age-in-excel-can-you-provide-an-example/.
stats writer (2024) 'How do I calculate the average age in Excel? Can you provide an example?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-calculate-the-average-age-in-excel-can-you-provide-an-example/.
[1] stats writer, "How do I calculate the average age in Excel? Can you provide an example?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I calculate the average age in Excel? Can you provide an example?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.