Use quantities for percentile calculation

[Giare]

Hello everyone,

I have some data about a given amount of cars (Column B) travelling at a specific speed (Column A). I am trying to figure out a formula that returns the speed driven by the 15th percentile of the vehicles.

I hope my question is clear enough.

 

[RobP]

Hi,

Would something like this do the trick ?

=PERCENTILE(A2:A37,0.15)

Cheers
Rob

 

[Giare]

Thanks for your reply.

Unless i am mistaken, I think that your formula doesn't work for me because it doesn't consider the amount of cars (column B) in the calculation. What i am looking for is the speed (column A) driven by the 15th percentile of cars (column B)