Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the expected output from this data?
Hi Sunny,
To code 1.01: Quartile 0,25 and Quartile 0,5 and Quartile 0,75 = 5867.05.