Hello experts, I need some help trying to figure out this excel percentile puzzle.
I have only been provided with salary data for the 25th, 50th and 75th percentile, and cannot get the source data. Does anyone know the best formula to calculate what the 10th and 90th percentile would be.
10th percentile = ?
25th percentile = 32000
50th percentile = 35500
75th percentile = 38000
90th percentile = ?
Any help is greatly appreciated!!