4 Replies Latest reply on Oct 8, 2013 3:26 PM by Daniel Stoll

    median formula even number of observations

    Daniel Stoll

      Hello -

       

      Using a data extract I'm calculating medians.  One tableau median doesn't match what SAS says the median is.  I have 342 cases.  In sequence, number 171 is 134500 and number 172 is 135000.  SAS looks at this data set and says the median is 134750 but tableau says the median is 134500.  What's going on?  And how can I get tableau to present the median as the average of the middle two numbers when the number of cases is an even number?

       

      Thanks

      Dan Stoll