2 Replies Latest reply on Nov 5, 2018 12:30 PM by Morgan James

# Calculating "age distribution" stats -- average, standard deviation, etc.?

Hi All!

I believe I have a pretty basic ask.

I know how to calculate "average age" and "standard deviation" for the age distribution of a population in Excel, but I can't seem to figure out the correct equation or process in Tableau?

I've attached a workbook with the age range of a populace "18-99" and the counts/volume for each of those ages.

The two worksheets show the values and a histogram illustrating the distribution.

1. I want to create a calculated field that I can place in the "Label" for "Average Age" of the particular cut of the populace displayed. I say particular cut, because if I decide to "cluster," I then want it to show the "average age" for that cluster and so forth.
2. Is there a way to calculate the standard deviation as well?

Thanks!

• ###### 1. Re: Calculating "age distribution" stats -- average, standard deviation, etc.?

Hi
see the attached

this will add a ref line

right click the age axis and add regf line

as shown

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 2. Re: Calculating "age distribution" stats -- average, standard deviation, etc.?

This was helpful Jim! Thank you!

Do you have any suggestions for "standard deviation" calculation?