Possible Decile Question

[Flinger]

I have a data set with the following data...

InvoiceNumber, BarrelsSold, PricePerBarrel

On a separate tab I want to break PricePerBarrel into deciles like so...


5% of total barrels sold were less than X price per barrel
15% of total barrels sold were less than X price per barrel
25% of total barrels sold were less than X price per barrel
35% ...
45% ...
55% ...
65% ...
75% ...
85% ...
95% ...

I know this is probably super easy, I just can't wrap my head around it. To make things harder, I can't really sort the data into ascending price per barrel or barrels sold.

I tried doing a simple percentile function like =PERCENTILE(C1:C50,.05) but as you can imagine it didn't take into account the number of barrels sold so it wasn't weighted correctly.

 

[GlennUK]

I don't think you are going to get a table looking like that easily. I'd recommend looking at the Frequency function to show sales per price bucket, or use a pivottable to see how sales vary by price.