6 Replies Latest reply on Dec 6, 2016 6:56 AM by Naresh Karumanchi

# Distribution of profits calculation using interquartile ranges

Data Source: Saved Sample-Superstore dataset.(Attached)

Determine which furniture subcategory has the highest distribution of profits using interquartile ranges?

Could some one help me how to answer this question? i mean what visualization i should us along with Box and whisker plot? thanks!

• ###### 1. Re: Distribution of profits calculation using interquartile ranges

if you break down the question, it easier to dicipher... what sub-category in Furniture... means you have to only look at Furniture (FILTER).

1 of 1 people found this helpful
• ###### 2. Re: Distribution of profits calculation using interquartile ranges

You may use LOD to calculate percentiel by category and compare each category's numebr to Max of those.

[25% ile range]

abs({fixed [Sub-Category]:PERCENTILE([Profit],.25)})

[max 25% ile]

{fixed :max([25% ile range])}

[Flag]

if abs(PERCENTILE([Profit],.25))= attr([max 25% ile])

then "Show" else "Hide" end

Thanks,

Shin

• ###### 3. Re: Distribution of profits calculation using interquartile ranges

Hi Jon

I was able to create this Box-and-whisker plot but what does finding distribution of profit ration using interquartile ranges mean? Does it mean which is the product that had upper MAX ( Whisket-lower whisker) has more profit? I have an idea about lowe,upper hing,whisker but not sure how we can use these values to make comparisons across fields like this sub-category? Thank you!

• ###### 4. Re: Distribution of profits calculation using interquartile ranges

the space between the upper and lower whiskers tell you where majority of action is taken place.  in this case PROFITS.  Remember the exercise where you had to find out the discount per product?  Well sometimes you will sell something and make \$100 PROFIT with no discount (which is good right). Sometimes to move inventory you have to discount things and you don't make the full profit of \$100, sometimes \$70. sometimes \$80, etc. Sometimes you loss money on the table, but the family also took a couch and a bedroom set, so you added a Table for free... thats business.

so if you look at the chart, it shows you that for these sub-categories table had the biggest differences in profits, probably because they had to discount tables to move them..

• ###### 5. Re: Distribution of profits calculation using interquartile ranges

Also Naresh

if you go the answer you were looking for, please mark it as "this is the answer"

• ###### 6. Re: Distribution of profits calculation using interquartile ranges

Thank you!