3 Replies Latest reply on Feb 11, 2019 12:53 PM by Scott Hoffman

# Calculate Average

Hi!

How can I calculate the average age of my column data? Thanks!!!

I tried to use "Total", but it looks wired(second one). Anybody can help me?

Thanks!

• ###### 1. Re: Calculate Average

Are you trying to do average age by year born in (not sure that makes sense in most scenarios)?

If you attached your workbook it would be easier to assist but my guess is you want to remove the birth year and put an avg() around age.

Let me know if you have any questions.

Thanks,

Scott

• ###### 2. Re: Calculate Average

Hi Scott!

Thanks for your help.

I really want to share my worksheet but I cannot, sorry...

(Let me elaborate more clearly, I want to calculate the average age about people in a certain year. The figure shows below is that, there is 1 person that born in 1927, currently he is 83-year-old.)

I wonder what is the average age of all the group of people?

• ###### 3. Re: Calculate Average

I made a sample data set based on your screen shot.

I put avg(age) into the Marks>Text and Year into the rows.  I then went to analytics and added a total.  I used automatic since I didn't want an average of an average.

Let me know if you have any questions.

thanks,

Scott