View Single Post
 
Old 02-11-2019, 06:34 AM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 867
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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.
Reply With Quote