“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

how do you calculate percentile rank in excel when the question mean is known for 10 companies. Example the Mean is 3.58 from the sum of the 10 companies Mean divided by 10. The lowest Mean of the 10 organizations is 2.85 and the highest Mean is 4.22
Our goal is to be able to show the percentile rank of the 10 companies for their mean.

Solved by X. W. in 27 mins

For salary ranges: I have the mid and I think I know how to calculate the minimum and maximum. What I don't know how to do is calculate the percentiles, i.e. 25th percentile etc. I looked at the excel examples on line, but I couldn't get them to work.

Solved by G. B. in 20 mins

I need a formula that ranks the highest number in the 1st percentile and the lowest number at the 100th percentile.

Solved by T. D. in 25 mins

I need to find to calculate the 25% percentile of a range of values with certain conditions on a table. This is what i have so far but it seems to have an error somewhere,
=PERCENTILE(IF('906-Try'!F:F>'2019 Goals'!K2,IF('906-Try'!T:T>'2019 Goals'!K3,IF('906-Try'!O:O>'2019 Goals'!K4,IF('906-Try'!C:C>=MIN('2019 Goals'!K5,'906-Try'!C:C<=MAX('2019 Goals'!L5)))))),25%)

Solved by I. Q. in 13 mins

I need help using the empirical rule to describe the Gross Total data in the 95th and 99th percentile.

Solved by S. U. in 27 mins