Get instant live expert help on percentile in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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
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 help using the empirical rule to describe the Gross Total data in the 95th and 99th percentile.
Solved by S. U. in 27 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
Excel formula needed: Number of patient eligible to be screened 9 Number of patients screened 6 % screened 66.67% (=SUM(C8/C7)) Number of additional patients needed to meet green target 1 Number of additional patient needed to meet blue target 2 ------------------------------- 90th Percentile CY 18 (Blue): 81.0% 75th Percentile CY 18 (Green): 77.5% Formula needed for if not green% then how many more to make green in a whole number and same for to make blue. Was trying to figure a IF and ROUNDUP together formula.
Solved by X. H. in 27 mins