Is there a function in Excel that would calculate the 85th & 90th percentiles based on the 50th & 75th percentiles.
Thanks
Is there a function in Excel that would calculate the 85th & 90th percentiles based on the 50th & 75th percentiles.
Thanks
Last edited by Dooldeniya; 07-15-2009 at 05:14 PM.
If you assume the data is exactly Gaussian, the 50th percentile is the mean, and the 75th (or any other) percentile can be used to calculate the deviation:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
SHG -
Any explanation why it works the way it does?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks