Table C2-1 shows the average weekly pounds of coffee beans purchased by DSC’s largest customers in the past year. Calculate the pounds of coffee that would need to be purchased to put a customer in the 50th percentile, 90th percentile, and the 20th percentile. Then in the table below add each customer level to table C2-1. (Please make sure to add the customer levels below) That is what I am needing help with.) Using the =percentile.inc function in Excel I got the following percentiles. 20 = 113, 50 = 147, and 90 = 253. Please verify if these are correct.
Table C2-1: Average Weekly Pounds of Coffee Beans Purchased by Largest Clients | ||
Customer | Pounds | Customer Level |
Moonyen | 64 | |
Sip-n-Joy | 96 | |
Georgio's | 111 | |
Bean There Dunk That | 120 | |
The Takeaway | 133 | |
Espresso Joe's | 134 | |
Sally's Café | 160 | |
Organic Dreamland | 166 | |
Riverfront | 174 | |
Coffee Shack | 185 | |
Marco Marco! | 261 | |
Bestia Takeout | 378 |