hello i want to identify top 75% percentage of column "CONTRI" and average of "PRICE" column of top 75% identified in column average eg:-
DIV | NUM | PRICE | CONTRI | SUM | average |
AA | 1 | 2.2305761 | 25% | 76% | 1.39 |
AA | 2 | 1.9826327 | 11% | ||
AA | 3 | 1.5937878 | 9% | ||
AA | 4 | 1.3153554 | 7% | ||
AA | 5 | 1.0388263 | 12% | ||
AA | 6 | 0.8675439 | 4% | ||
AA | 7 | 0.6685939 | 7% | ||
AA | 8 | 0.5918046 | 3% | ||
AA | 9 | 0.5394239 | 3% | ||
AA | 10 | 0.5176282 | 3% | ||
AA | 11 | 0.5096999 | 3% | ||
AA | 12 | 0.4879966 | 3% | ||
AA | 13 | 0.4669618 | 3% | ||
AA | 14 | 0.3817897 | 2% | ||
AA | 15 | 0.376922 | 2% | ||
AA | 16 | 0.3234115 | 2% | ||
DIV | NUM | PRICE | CONTRI | SUM | average |
BB | 1 | 2.2305761 | 13% | 75% | 1.18 |
BB | 2 | 1.9826327 | 11% | ||
BB | 3 | 1.5937878 | 9% | ||
BB | 4 | 1.3153554 | 7% | ||
BB | 5 | 1.0388263 | 6% | ||
BB | 6 | 0.9933398 | 6% | ||
BB | 7 | 0.8675439 | 9% | ||
BB | 8 | 0.6685939 | 10% | ||
BB | 9 | 0.5918046 | 3% | ||
BB | 10 | 0.5394239 | 1% | ||
BB | 11 | 0.5176282 | 4% | ||
BB | 12 | 0.5096999 | 3% | ||
BB | 13 | 0.4879966 | 3% | ||
BB | 14 | 0.4669618 | 3% | ||
BB | 15 | 0.3817897 | 2% | ||
BB | 16 | 0.376922 | 2% | ||
BB | 17 | 0.3284382 | 2% | ||
BB | 18 | 0.3284382 | 4% | ||
BB | 19 | 0.3284382 | 2% |