Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I find the average of the fourth quartile?
I can find the fourth quartile point using this expression: Fractile(Q21Num, 0.75).
But how do I get average of the values belonging to the fourth quartile ?
That should work, I just had my sign backwards in my example.
AVG({$<[Q21Num] = {">=$(=vFractile)"}>} [Q21Num])
Excellent - thanks, it did the trick!