G H J K L Percentile Rank (rounded): [Hint: use ROUND() to no digit after decimal point Value of the ?th observation: [Hint: use INDEX()] The corresponding "Item Category": [Hint: use INDEX()] Using PERCENTILE.INC() 87 ? ? ? ? What is the 87th percentile of costs per order? You need to show your calculation on the spreadsheet as well. Label any cell added. 1. Sort "Cost per order" in ascending order 2. Calculate the rank of the 87th percentile (H10) 3. Find that specific Cost per Order (H11) either manually or using INDEX() 4. Find the corresponding "Item Category" (H12) either manually or using INDEX() 5. Alternately use function PERCENTILE.INC() to find the value (H13) (Make sure to use k/100 as parameter for the function)