4 Replies Latest reply on Jan 22, 2019 7:39 AM by Recky B

    How to calculate median for categorical income variable

    Recky B

      I have income variable with with breaks 1. Less than $25000 2. $25000 - $39999 3. $40000 - $59999 5. $60000 - $79999 6.$80000 - $99999 7. >= $100000. The raw data also coded same exact labeled information of income breaks not a numeric income. I need some help to figure out how to compute median income if possible could you please explain me is this something achievable in tableau if so kindly let me know the steps to get median income. I am really appreciate your help in advance.

      Table illustration -

      Less than $25000 - 18%

      $25000 - $39999  - 12%

      $40000 - $59999 - 11%

      $60000 - $79999 - 22%

      $80000 - $99999 - 10%

      >= $100000  - 27%

      How to compute Median income in tableau??

      Thanks, Recky