Home / Expert Answers / Advanced Physics / table-c2-1-shows-the-average-weekly-pounds-of-coffee-beans-purchased-by-dscs-largest-customers-in-pa357

(Solved): Table C2-1 shows the average weekly pounds of coffee beans purchased by DSCs largest customers in ...



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  


We have an Answer from Expert

View Expert Answer

Expert Answer


Let X be the pounds of coffee beans purchased. Average weekly pounds of coffee beans purchased (u) = Standard deviation
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe