![]() |
|
#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. |
|
|
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 |