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

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

    Morgan James

      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!