#1
|
|||
|
|||
Calculate gain from improving worst performing decile to median level
I have a dataset (1,780 rows) and I'm trying to calculate the financial impact if bottom decile performed to median level.
I have product ID, qty_half price sales, qty_full price sales, $_half price sales, $_full price sales. Any help greatly appreciated. Thanks! |
#2
|
|||
|
|||
To follow on, I only need how you would approach this problem?
I have calculated the mean and identified the bottom decile. I’m now stuck on what I should do next. Thanks to anyone that can help. |
#3
|
||||
|
||||
It would be best if a sample is attached with say, at least 30 rows of data. My understanding of your problem anyway is on how you will substitute or replace the quantity of the lowest decile with the mean so how about copying the sheet containing the actual data to another sheet then enter a formula in the lowest decile that picks up the mean in the first sheet? If you are making a one time projection of $sales based on the mean, a hard coded formula will do but if you want results where the decile dynamically change with any change in the actual sales, you must provide a data with expected results as I am sure we have several experts here who will happily share their own solutions or point to you the better approach to solving your problem.
|
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
Does this do it?
|
#6
|
||||
|
||||
Quote:
|
#7
|
||||
|
||||
How are you measuring perfomance?
If you're using column F for performance, the bottom decile can be calculated using =PERCENTILE.EXC($F$2:$F$32,0.1) or =PERCENTILE.INC($F$2:$F$32,0.1) The number of values below this value will be 3 or 4 products depending on which version (INC or EXC) you've used. For those values falling in the bottom decile I'm not clear what values (column) you might want to substitute and how your median level (of what?) is calculated. |
Thread Tools | |
Display Modes | |
|
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 |