Calculate gain from improving worst performing decile to median level

Hoss · #1 02-10-2019, 12:09 PM

Thanks Marcia! Attached is some sample data.

It shows number of products sold on "Sales" price.

Number of products sold at "Full" price.

I would like a method to calculate the financial return if lowest performing products (e.g. those sold at Sale price) sold at Full price.

Marcia · #2 02-11-2019, 04:43 AM

Quote:

I would like a method to calculate the financial return if lowest performing products (e.g. those sold at Sale price) sold at Full price.

This is different from your first post in which you were asking for a method to calculate the gain if the lowest 10 performing products are sold at the mean price. Arvi's post answered your second post while I tried a roundabout solution for post #1. I hope it gives you an idea on how you finally get the exact answers that you need.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Used an Array to Add a Median to Pivot Table- Now need Median to also appear on graph	jrnisaac1	Excel	3	04-25-2017 08:45 AM
Suggestions wanted for improving workflow of shared incoming emails	plaidma1	Outlook	1	05-03-2013 09:33 AM
Improving saving in Word	solaster	Word	2	07-13-2012 03:09 PM
Excel Not Finding the Median	BrazzellMarketing	Excel	4	02-17-2012 02:20 PM
Can I move Office Setup files to gain space	KarenLeePA	Office	1	06-24-2011 09:26 PM