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

Find the house(s) at the 80th percentile of all sample houses with respect to appraised value. Find the house(s) at the 80th percentile of all sample houses with respect to selling price.

Solved by C. Q. in 28 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'm trying to use the quartile function and I am getting a #num error for the first quartile but not the 2nd or third. I tried the percentile, and the same thing happens

Solved by K. A. in 28 mins

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

2. From the data, what is the 95th percentile (highest top 5%) per-mile-rate for each state?

Solved by S. U. in 16 mins