2 Replies Latest reply: Feb 8, 2017 2:45 PM by Agenor Canal RSS

    How can I do to find the quartiles, by one variable and weighted by another.

    Agenor Canal

      Hi,

      How can I do to find the quartiles, by one variable and weighted by another.
      For example, in the following data, I wanted the quartiles of the amount variable, by code and weighted by the quantity variable.
      Input frame date
          code               amount                     quantity
          1.01                   35867.14                   125
          1.01                 5867.05                     1045
          1.01                62100.14                       91
          1.01                35,000.99                     21
          1.02                401.87                       2650
          1.02                815.7                       10345

      Thanks