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

Need help with vlookup function and can you help me with how to calculate percentile the data analysis tool

Solved by X. J. in 30 mins

Trying to do a percentile if statement but it is including the zero's.
={PERCENTILE(IF('All USA Data - sheet 1'!$F$2:$F$1681=B14,'All USA Data - sheet 1'!$O$2:$O$1681),0.75)}

Solved by Z. J. in 30 mins

Hello, I need excel help with this formula. I need this formula to work in a manner that whatever number is placed in a range it will automatically convert to it's allocated value based on the percentile range it lands in.
1. IF (Value) is > 80% of (selected range), value = 5
2. IF (Value) is > 60% of (selected range) but < 80% of (selected range), value = 4
3. IF (Value) is > 40% of (selected range) but < 60% of (selected range), value = 3
4. IF (Value) is > 20% of (selected range) but < 40% of (selected range), value = 2
5. IF (Value) is < 20% of (selected range), value = 1
Essentially the formula should reflect as such, The top 20% of a selected range will receive 5pts. Players that fall within the top 80% will receive 4pts. Players that fall within the top 60% will receive 3pts, while players that fall within the top 40% will receive 2pts. Finally, players who are in the bottom 20% will only receive a point. This rule should apply to both formula of which one provides results for the top testing times for speed related test categories and the top testing results for power related test categories

Solved by G. S. 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

Hi! I am currently working with a project where I have to find the BMI percentile of 2000 individuals age group based on gender. I have two tabs with an array that supplies the ranges of BMI percentiles for age and BMI but they are grouped by gender. I have ages in months and BMI in a third tab. I need a equation for a third column to sort if an individual is male or female, then I need it to reference the age and BMI in the other tabs to generate the listed percentile for the group. I have so far tried a Vlookup and match index but I am still having errors. Any help is greatly appreciated!

Solved by G. H. in 24 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

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

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 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