I am not sure if this is doable but here goes.
This sample file contains 2 sheets.
1. Summary - This is where the results will be populated in columns (all highlighted in yellow) :
-P
-X
-AF
-AN
-AV
-BD
-CV
-DE
2. Inverse %tile Cal with 60th - This is a percentile estimator that will calculate the 65th percentile in column H if you input values in columns D (25th percentile), E (50th Percentile), F (75th percentile), G (90th percnetile) from the summary sheet.
I have given an example using data located in the summary tab between columns K and R, I have entered the 25th, 50th, 75 and 90 to give me a result of 488,116.13 in cell P4.
MY ASK: Is there a way to take the 25th, 50th,75th and 90th percentile in each of those sections, input them in the inverse %tile with 60th sheet run it through that model, take the results in column H and put it into that section where it came from in the 65th percentile column.
I hope this makes sense.
Bookmarks