Cotton Hank Yarn Rates: A Comparative Reading Across Counts and Yarn Types

A yarn rate sheet may look like a plain list of rupees per kilogram, but it contains a useful story about yarn count, spinning route, processing, fineness and value addition. When the rates are arranged count-wise and type-wise, the market logic becomes clearer. Coarser yarns sit at the lower end of the rate range, medium counts form the practical commercial middle, and finer, combed, compact, doubled or specially finished yarns move into the premium zone.

This article interprets the cotton hank yarn rates for June 2026 without referring to individual supplier names. The purpose is not to compare one supplier with another, but to understand how price changes with count and yarn type. The rates are quoted in rupees per kilogram and should be read as indicative trade rates subject to availability and confirmation.

Table of Contents

• 1. Why Yarn Count Matters
• 2. Count-Wise Rate Ladder
• 3. Processing Premium: Carded, Combed, Compact and Mercerised
• 4. Doubled Yarns and Why They Need Separate Reading
• 5. Practical Buying Interpretation
• 6. Quick Takeaways
• 7. Related Reading
• 8. Selected Sources
• 9. General Disclaimer

1. Why Yarn Count Matters

In cotton yarn, count is a way of expressing fineness. In the English cotton count system, commonly written as Ne, a higher count generally means a finer yarn. Thus, 80s cotton is finer than 40s cotton, and 100s cotton is finer than 60s cotton. This is an indirect count system, where the number increases as the yarn becomes finer.

The broad relationship can be written as:

\( Ne = \frac{\text{Length in yards}}{840 \times \text{Weight in pounds}} \)

This formula is useful because it reminds us that count is not merely a number printed in a rate sheet. It is linked to length, weight and yarn fineness. In general, finer yarn requires better fibre quality, more controlled spinning and more careful processing. Therefore, its rate per kilogram usually rises.

However, count alone does not explain the full rate difference. A 60s carded yarn, a 60s combed yarn, a 60s compact yarn and a 2/60s doubled yarn do not occupy the same value position. The spinning method, combing, compacting, doubling, gassing, mercerising and finishing route may all influence the final price.

Visual 1: Cotton hank yarn rate ladder showing coarse, medium, fine and premium yarn zones.

2. Count-Wise Rate Ladder

The June 2026 rate sheet shows a very wide spread. At the lower end, very coarse condenser yarn is quoted at around ₹79 per kg. At the upper end, very fine doubled and specially processed yarn reaches around ₹1,040 per kg. This means the highest listed yarn is more than thirteen times the lowest listed yarn.

The following table groups selected counts and yarn types into a simpler comparative view. Where more than one rate was listed for the same count and type, an approximate average has been used for interpretation.

Yarn count / type	Approx. average rate ₹/kg	Rate range ₹/kg	Interpretation
2s Condenser	79	79	Very coarse and lowest-priced category in the sheet.
6s K	140	138–142	Coarse yarn segment with moderate pricing.
10s K O.E.	164	159–174	Open-end coarse yarn, priced higher than 6s but still in the lower band.
20s Carded	264	257–270	Clear movement into the medium-count zone.
26s Carded	285	285	Slightly finer than 20s, with a moderate rate increase.
30s K	290	290	Practical medium-count yarn.
40s K	310	310	Finer yarn with stable quoted rate.
40s K Compact	315	315	Compact version shows a small premium over regular 40s.
60s K	375	375	Fine-count segment begins to show stronger price movement.
60s Combed	405	405	Combing premium becomes visible.
80s Combed	536	528–545	Fine combed yarn with a much higher price band.
100s Combed	645	645	Very fine yarn category with strong premium positioning.

The broad pattern is clear. The price rise from 10s to 40s is gradual, but after 60s the curve becomes sharper. This is expected because finer counts demand better cotton, better control over fibre length variation, lower short-fibre content and more careful spinning.

3. Processing Premium: Carded, Combed, Compact and Mercerised

A useful way to read the rate sheet is to compare not only the count but also the process. For example, 40s K is around ₹310 per kg, while 40s compact is around ₹315 per kg. The premium here is small. This suggests that in this count range, the additional value assigned to compact spinning is visible but not very large.

The premium becomes stronger at finer and doubled counts. For example, 60s K is around ₹375 per kg, while 60s combed is around ₹405 per kg. This is an increase of about 8%. In doubled yarn, 2/60s K averages around ₹407 per kg, while 2/60s combed is listed at ₹503 per kg. That is a much sharper premium.

The processing premium can be understood through textile logic. Combing removes short fibres and improves yarn cleanliness, smoothness and spinning quality. Compact spinning reduces the spinning triangle and can improve yarn structure by reducing hairiness and improving strength. Mercerising and gassing add further value by improving surface appearance, lustre and smoothness.

Comparison	Lower-priced version	Higher-priced version	Approx. premium	What it indicates
40s regular vs compact	40s K: ₹310/kg	40s K Compact: ₹315/kg	About 1.6%	Compact premium is present but small in this count.
60s K vs 60s combed	60s K: ₹375/kg	60s Combed: ₹405/kg	About 8%	Combing premium becomes more meaningful at finer counts.
2/60s K vs 2/60s combed	2/60s K: about ₹407/kg	2/60s Combed: ₹503/kg	About 24%	Doubled and combed yarn occupies a higher value zone.
2/80s combed vs specially finished	2/80s Combed: ₹634.36/kg	2/80s special finished yarn: ₹859/kg	About 35%	Special finishing can command a large premium.

Visual 2: Processing premium map showing how carded, combed, compact, doubled and mercerised yarns move upward in value.

4. Doubled Yarns and Why They Need Separate Reading

Doubled yarns such as 2/10s, 2/40s, 2/60s, 2/80s and 2/100s should not be compared mechanically with single yarns. In a doubled yarn, two strands are twisted together. This changes strength, handle, fabric behaviour and end-use suitability.

For example, 2/10s K is around ₹176 per kg, while 2/40s carded is around ₹326 per kg. Moving further up, 2/80s combed is around ₹634 per kg, while 2/100s CGM is around ₹740 per kg and 2/120s CGM reaches ₹1,040 per kg. These rates show that doubling combined with fineness and special processing creates a premium segment.

Doubled / special yarn type	Approx. average rate ₹/kg	Rate range ₹/kg	Reading
2/6s K	150	150	Coarse doubled yarn.
2/10s K	176	172–179	Economical doubled yarn in coarse-to-medium segment.
2/17 NF	276	275–280	Mid-range doubled yarn.
2/30s K	295	295	Stable medium-count doubled category.
2/40s Carded	326	325–330	Higher than single 40s due to ply structure and count position.
2/60s K	407	405–410	Fine doubled carded segment.
2/60s Combed	503	503	Combed doubled yarn with clear premium.
2/74s Combed Gas Mercerised	705	704.85	Fine, doubled and specially processed yarn.
2/80s Combed	634	634.36	Premium fine doubled yarn.
2/80s Special Finished	859	859	High-value special finish category.
2/100s CGM	740	740	Very fine doubled processed yarn.
2/120s CGM	1,040	1,040	Highest listed premium yarn in this sheet.

This table also shows why buyers must avoid a simplistic “count only” comparison. A 2/80s yarn with special finishing is not merely another 80s yarn. It has a different processing history and a different expected performance level.

5. Practical Buying Interpretation

For handloom, fabric development and sourcing decisions, the rate sheet can be read in four broad zones. The first zone is coarse yarn. This includes very low counts and yarns used for heavier, rustic or utility applications. These yarns are price-friendly but may not give the refined handle required for finer fabrics.

The second zone is the medium-count range, such as 20s, 26s, 30s and 40s. This is often the practical commercial zone because it balances cost, fabric utility and manageable yarn quality. For many regular woven fabrics, this range is easier to justify commercially than very fine counts.

The third zone is fine yarn, especially 60s, 80s and 100s. These yarns are suitable where surface appearance, smoothness, drape and lightweight fabric character matter. The rate is higher, but the yarn can support finer fabric aesthetics.

The fourth zone is the premium processed category. Doubled, combed, compact, gas mercerised or specially finished yarns may be chosen when the fabric needs better strength, cleaner appearance, smoother surface, better lustre or more refined handle. These should be purchased with a clear fabric objective, not only because they look technically superior.

Visual 3: Buying decision matrix linking count, process, rate level and fabric end use.

6. Quick Takeaways

Observation	Meaning for buyers and textile learners
Rates rise with count, especially after 60s.	Finer yarns need better fibre and better spinning control, so the price curve becomes steeper.
Processing affects price strongly.	Combing, compacting, doubling, gassing and mercerising can create clear premiums beyond count alone.
Doubled yarns need separate interpretation.	They have different construction, strength and end-use behaviour compared with single yarns.
Special finishing can add a large premium.	The buyer should connect the premium with fabric requirement, not just technical terminology.
The lowest rate is not always the best decision.	The correct yarn is the one that fits fabric quality, loom performance, handle, appearance and target price.

The final lesson is simple. Yarn price is not decided by count alone. It is shaped by a combination of count, spinning route, fibre quality, processing, ply structure, finish and availability. A good buyer reads the rate sheet not only as a price list, but as a technical map of yarn value.

Related Reading on Cotton, Yarn Quality and Spinning Decisions

• What is Khadi Count. How it is Different from Cotton Count
• Understanding Cotton Fibre Length-Mean Length, Span Length, Short Fibres and Uniformity
• Count, Construction and Width of common Cotton Fabrics
• How to calculate the weight of Fabric

8. Selected Sources

1. Current-month cotton hank yarn rate schedule. 2026. Cotton Hank Yarn Rates for the Month of June 2026.
2. Bureau of Indian Standards. 1966. IS 3689: Conversion Factors and Conversion Tables for Yarn Counts.
3. International Organization for Standardization. 1973. ISO 1144: Textiles — Universal System for Designating Linear Density (Tex System).
4. CottonWorks. 2017. Textile Yarns.
5. Mohamed, S. S. 2014. Compact Spinning System for Fine Count Egyptian Cotton Yarns. Austin Journal of Textile Engineering.

9. General Disclaimer

This article is intended for educational understanding of cotton hank yarn rates, count comparison and yarn-type interpretation. The rate values discussed here are based on a specific monthly rate sheet and should not be treated as permanent market prices.

Actual yarn buying should consider availability, quality confirmation, testing, moisture, packing, transport, delivery terms, lot variation, end-use requirement and commercial negotiation. For production decisions, buyers should verify yarn specifications, physical test results and current confirmed rates before placing orders.

Understanding the Industry Overview of Indian Apparel Retail Market

Understanding the Industry Overview of RSB Retail India Limited

The industry overview of RSB Retail India Limited Offer document presents a useful picture of the Indian apparel retail market, especially from the perspective of South India, women’s ethnic wear, sarees, value retail and organised store-based retail. The section is important because it explains the market background in which the company operates and the larger consumer trends that may support its future growth.

In simple terms, the industry story is this: India’s apparel market is large, culturally diverse and still growing, but some parts of the market are more attractive than others. For RSB Retail, the most relevant opportunity lies in South Indian apparel, women’s Indian wear, sarees, family shopping, value retail and the gradual shift from unorganised shops to organised retail chains.

Table of Contents

• 1. Market Context
• 2. Shift Towards Organised Apparel Retail
• 3. South India as a Core Apparel Market
• 4. Women’s Indian Wear as the Main Opportunity
• 5. Sarees and Ethnic Occasion Wear
• 6. Role of Value Retail
• 7. Strategic Meaning for RSB Retail
• 8. Key Numbers at a Glance
• 9. Conclusion
• 10. General Disclaimer

1. Market Context

RSB Retail India Limited operates in the apparel retail industry. The industry overview places the company within a large Indian apparel market where consumer demand is influenced by income growth, urbanisation, festive buying, wedding purchases, fashion awareness and the expansion of organised retail formats.

South India is an especially relevant market in this context. The total apparel market in South India was estimated at about ₹1,723 billion in Fiscal 2024. This is not a small regional opportunity; it is a large apparel consumption base with strong cultural, festive and occasion-led buying behaviour.

2. Shift Towards Organised Apparel Retail

One of the strongest themes in the industry overview is the movement from unorganised retail to organised retail. In South India, the unorganised apparel channel grew from ₹686 billion in Fiscal 2019 to ₹838 billion in Fiscal 2024, implying a CAGR of 4.1%. It is projected to reach ₹1,200 billion by Fiscal 2029.

In comparison, the organised apparel channel grew much faster. It increased from ₹406 billion in Fiscal 2019 to ₹884 billion in Fiscal 2024, at a CAGR of 16.9%. It is further estimated at ₹1,020 billion in Fiscal 2025 and projected to reach ₹1,850 billion by Fiscal 2029.

This is important for RSB Retail because the company is positioned as an organised retail player. The market is not only growing; the organised part of the market is growing faster than the unorganised part. Organised brick-and-mortar apparel retail in South India grew from ₹282 billion in Fiscal 2019 to ₹588 billion in Fiscal 2024 and is projected to reach ₹1,184 billion by Fiscal 2029.

The shift can be understood through a simple relationship:

\[ \text{Growth Opportunity} = \text{Market Size} \times \text{Shift to Organised Retail} \times \text{Category Relevance} \]

This means that a large market alone is not enough. The opportunity becomes stronger when the category is culturally relevant, when customers are willing to shop in organised formats, and when the retailer can offer better assortment and trust than smaller unorganised players.

3. South India as a Core Apparel Market

The South Indian apparel market is sizeable and well distributed across men, women and kids. In Fiscal 2024, women’s apparel was valued at ₹687 billion and contributed about 39.9% of the South Indian apparel market. Men’s apparel was valued at ₹663 billion and contributed about 38.5%, while kidswear accounted for the remaining 21.6%.

Women’s apparel is also expected to grow faster than the overall market. The South Indian women’s apparel market is projected to grow at a CAGR of about 13.0% from Fiscal 2024 to Fiscal 2029, reaching ₹1,265 billion by Fiscal 2029.

South India also has strong regional apparel identities. Andhra Pradesh and Telangana together accounted for 31.6% of the South Indian apparel market in Fiscal 2024. Tamil Nadu accounted for 29.2%, while Karnataka accounted for 26.9%. These numbers show that the market opportunity is not concentrated in only one state; it is spread across several large consumption regions.

4. Women’s Indian Wear as the Main Opportunity

Within South Indian women’s apparel, Indian wear is the dominant segment. Women’s Indian wear accounted for 74% of the South Indian women’s apparel market in Fiscal 2024 and was valued at ₹507 billion. It is projected to grow to ₹925 billion by Fiscal 2029, at a CAGR of 12.8%.

This is one of the most important numbers in the industry overview. It shows that RSB Retail is not operating in a marginal category. It is operating in a large women’s ethnic wear market where traditional apparel continues to hold a strong share.

Western wear among South Indian women is also growing, but from a smaller base. It was valued at ₹174 billion in Fiscal 2024 and is projected to reach ₹329 billion by Fiscal 2029, growing at a CAGR of 13.6%. This means ethnic wear remains the backbone, but modern and casual categories are also expanding.

5. Sarees and Ethnic Occasion Wear

Sarees remain central to the women’s Indian wear market. At the India level, women’s Indian wear was valued at ₹1,503 billion in Fiscal 2024 and is projected to reach ₹2,450 billion by Fiscal 2029. Sarees accounted for about 37.5% of women’s Indian wear in Fiscal 2024, making them the largest sub-category.

In South India, sarees are not only garments; they are also linked with identity, gifting, marriage, festivals, family functions and status expression. This gives the saree category a resilience that many fashion categories do not have.

However, the saree market is also changing. Customers now look for multiple types of sarees for different needs: bridal sarees, festive sarees, daily wear sarees, office wear sarees, lightweight sarees, designer sarees and value sarees. The same customer may buy a premium saree for a wedding and a lower-priced saree for regular use.

6. Role of Value Retail

The industry overview also gives importance to value retail. The Lifestyle and Home Value Retail market in India was valued at ₹3,192 billion in Fiscal 2019 and grew to ₹4,874 billion in Fiscal 2024, implying a CAGR of 8.8%. It is projected to reach ₹7,869 billion by Fiscal 2029, growing at a CAGR of 10.1% from Fiscal 2024 to Fiscal 2029.

Apparel is the largest contributor to value retail. In Fiscal 2024, apparel accounted for 73% of the total Lifestyle and Home Value Retail market. This is significant because it shows that value retail is not a side trend; it is led by apparel.

The report also gives indicative fastest-selling price points across retail segments. For sarees, the fastest-selling price is shown at around ₹500 in value retail, ₹3,700 in mid-price retail, ₹10,000 in premium retail and above ₹50,000 in luxury retail. This wide price ladder explains why saree retail can serve multiple consumer groups, from value-conscious buyers to premium occasion shoppers.

7. Strategic Meaning for RSB Retail

The industry overview supports RSB Retail’s position in several ways. First, South India is a large apparel market of about ₹1,723 billion in Fiscal 2024. Second, organised apparel retail is growing faster than unorganised retail. Third, women’s apparel is the largest gender segment in South India, with a market size of ₹687 billion in Fiscal 2024.

Fourth, women’s Indian wear remains highly significant, with a 74% share of South Indian women’s apparel in Fiscal 2024. Fifth, value retail is a large national opportunity of ₹4,874 billion in Fiscal 2024 and is projected to reach ₹7,869 billion by Fiscal 2029. Together, these points indicate that RSB Retail is positioned at the intersection of ethnic wear, women’s apparel, value retail and organised retail growth.

8. Key Numbers at a Glance

Industry Theme	Key Number	Interpretation for RSB Retail
Total South Indian apparel market	₹1,723 billion in Fiscal 2024	Shows that South India is a large apparel consumption market.
Organised apparel retail in South India	₹406 billion in Fiscal 2019 to ₹884 billion in Fiscal 2024; projected ₹1,850 billion by Fiscal 2029	Organised retail is gaining scale and growing faster than unorganised retail.
Organised brick-and-mortar apparel retail	₹282 billion in Fiscal 2019 to ₹588 billion in Fiscal 2024; projected ₹1,184 billion by Fiscal 2029	Supports the relevance of physical retail stores despite e-commerce growth.
Women’s apparel in South India	₹687 billion in Fiscal 2024; 39.9% of South Indian apparel market	Women’s apparel is the largest gender segment in South India.
South Indian women’s apparel projection	Projected to reach ₹1,265 billion by Fiscal 2029	Indicates strong future growth potential in women’s categories.
Women’s Indian wear in South India	₹507 billion in Fiscal 2024; 74% of women’s apparel	Ethnic wear remains the dominant women’s apparel category.
Women’s Indian wear projection	Projected to reach ₹925 billion by Fiscal 2029 at 12.8% CAGR	Shows sustained growth in ethnic wear beyond only traditional demand.
Indian wear in South India	₹608 billion in Fiscal 2024; projected ₹1,105 billion by Fiscal 2029	Festive, wedding and cultural apparel remain major demand drivers.
Women’s Indian wear in India	₹1,503 billion in Fiscal 2024; projected ₹2,450 billion by Fiscal 2029	Shows the national scale of the category in which sarees play a leading role.
Saree share in women’s Indian wear	About 37.5% in Fiscal 2024	Sarees remain the largest sub-category within women’s Indian wear.
Lifestyle and Home Value Retail market	₹4,874 billion in Fiscal 2024; projected ₹7,869 billion by Fiscal 2029	Shows the strength of value-conscious organised retail demand.
Apparel share in value retail	73% of Lifestyle and Home Value Retail in Fiscal 2024	Apparel is the largest driver of value retail.

9. Conclusion

The industry overview of RSB Retail India Limited presents a favourable market background. The company operates in a sector where apparel consumption is supported by culture, aspiration, family occasions and the gradual formalisation of retail. South India, women’s Indian wear and sarees form the most relevant parts of this opportunity.

The most important takeaway is that RSB Retail is positioned in a market where tradition and modern retail are meeting. Customers still value sarees, ethnic wear and family shopping, but they increasingly prefer organised stores, better assortment, transparent pricing and reliable service.

The numbers make the opportunity clearer. South India had a ₹1,723 billion apparel market in Fiscal 2024, women’s apparel alone was ₹687 billion, South Indian women’s Indian wear was ₹507 billion, and organised retail is growing much faster than unorganised retail. This combination makes the industry setting relevant for a regional apparel retailer like RSB Retail.

10. General Disclaimer

This article is a simplified educational summary based on the industry overview section of the Draft Red Herring Prospectus of RSB Retail India Limited. It is not investment advice, financial advice, valuation advice, or a recommendation to subscribe to, purchase, sell or avoid any security. Readers should refer to the full offer document, risk factors, financial statements and professional advisers before making any investment or business decision.

Why Box Plots Are Not Useless: A Practical Case from Day-to-Day Data Analysis

Why Box Plots Are Not Useless: A Practical Case from Day-to-Day Data Analysis

Box plots often look like textbook charts that have little connection with everyday business decisions. Many people use them in routine reports where a bar chart, line chart, or simple table would have been clearer.

However, this does not mean box plots are useless. It means they are often used in the wrong place. A box plot becomes extremely useful when the question is not merely about the average, but about variation, consistency, risk, and extreme behaviour.

In fact, there are situations where a box plot is almost vital. One such situation is vendor delivery performance in buying and merchandising.

Table of Contents

1. The Problem with Averages
2. A Vendor Delivery Case
3. What the Box Plot Reveals
4. How the Decision Changes
5. A Second Case: Size-Set Replenishment
6. Where Box Plots Are Genuinely Useful
7. The Core Lesson
8. General Disclaimer

1. The Problem with Averages

In day-to-day analysis, we often summarize performance using averages. Average sales, average delay, average discount, average lead time, and average complaint closure time are all common measures.

The problem is that an average can hide instability. Two vendors, stores, products, or processes may have the same average but completely different risk profiles.

Mathematically, an average can be written as:

\( \bar{x} = \frac{x_1 + x_2 + x_3 + \cdots + x_n}{n} \)

This is useful, but it does not show whether the values are tightly grouped or wildly scattered. It also does not show whether there are rare but dangerous outliers.

A box plot helps because it shows the median, spread, whiskers, and outliers in one compact visual. This makes it especially powerful when risk is hidden inside the data.

2. A Vendor Delivery Case

Imagine that you are reviewing thirty vendors who supply sarees, garments, or textile products. For each vendor, you have delivery delay data for the last one hundred purchase orders.

Your business question is simple:

Which vendors are consistently reliable, and which vendors are secretly risky?

Now consider two vendors.

Vendor	Average Delivery Delay	Initial Impression
Vendor A	3 days	Looks better
Vendor B	5 days	Looks worse

At first glance, Vendor A appears better because the average delay is lower. If the review is based only on the mean, Vendor A may receive a better rating.

But the real pattern may be very different.

Vendor A may deliver most orders on time, but occasionally delay an order by twenty-five to forty days. Vendor B may almost always deliver between four and six days late.

In this situation, Vendor A has a lower average delay but higher business risk. Vendor B has a higher average delay but greater predictability.

3. What the Box Plot Reveals

A box plot would immediately show that Vendor A and Vendor B are not the same type of vendor.

The box plot would show the typical delay, the spread of delays, and whether there are extreme late deliveries. This is exactly the information that an average hides.

Box Plot Element	Meaning in Vendor Analysis	Business Interpretation
Median	The typical delivery delay	Shows normal vendor behaviour
Box height	The middle spread of delivery delays	Shows consistency or instability
Whiskers	The usual operating range	Shows the normal boundary of delay
Outliers	Unusually high delays	Shows potential campaign or launch risk

A vendor with a small box and no outliers is predictable. A vendor with several large outliers may be dangerous, even if the average looks acceptable.

This is the strength of the box plot. It does not merely ask, “Who has the best average?” It asks, “Who can unexpectedly damage the plan?”

4. How the Decision Changes

The operational decision changes once we see the distribution instead of only the average.

Vendor	Median Delay	Variation	Outlier Behaviour	Operational Risk
Vendor A	Low	Mostly low	Occasional very large delays	High risk for campaigns, launches, and festival drops
Vendor B	Moderate	Low	No major outliers	Predictable and easier to plan around

Vendor A may still be useful for regular stock, but Vendor B may be safer for time-sensitive requirements.

For example, Vendor B may be preferred for festival launches, store openings, campaign stock, wedding-season collections, or high-visibility product drops. Vendor A may require tighter follow-up, earlier order placement, penalty clauses, or reduced dependence during critical periods.

This is why box plots are not just statistical visuals. In such cases, they become decision tools.

5. A Second Case: Size-Set Replenishment

Another practical example is size-set replenishment. Suppose a retailer is analyzing replenishment lead time for different sizes in a category such as blouses, kurtas, shirts, trousers, or ethnic wear.

The average lead time may look acceptable at the overall category level. But a box plot by size may reveal a more serious pattern.

Size Group	Possible Box Plot Pattern	Operational Meaning
XS, S, M	Small spread and few outliers	Stable replenishment
L, XL	Moderate spread	Some variability, but manageable
XXL, XXXL	Large spread and many outliers	Structurally unreliable replenishment

This insight is extremely practical. The issue is not simply that larger sizes are slower. The issue is that their supply may be unpredictable.

The action would therefore change. The business may keep deeper safety stock for larger sizes, place replenishment orders earlier, create separate vendor service-level agreements, or avoid making aggressive availability promises during campaigns.

A simple average would hide this. A box plot would expose it immediately.

6. Where Box Plots Are Genuinely Useful

Box plots are most useful when the business question is about variation, stability, exception behaviour, or hidden risk.

Business Area	Useful Box Plot Question
Vendor performance	Which vendors are consistently reliable, and which ones have dangerous delay outliers?
Store sales	Which stores have stable weekly sales, and which stores are highly erratic?
Discount analysis	Are discounts controlled within a narrow band, or are there extreme markdown leakages?
Sell-through analysis	Is performance broad-based, or dependent on a few extreme winners?
Replenishment planning	Which sizes, styles, or regions have unstable lead times?
Complaint resolution	Is the average closure time acceptable only because most cases are simple?

For routine sales reporting, a box plot may not always be necessary. But when the concern is reliability, spread, or exception risk, it can be more useful than the average.

7. The Core Lesson

A box plot is not mainly a chart for showing totals. It is a chart for detecting hidden variation.

Its real value appears when the average looks fine but the business still feels unstable.

In such cases, the box plot gives a fast answer to an important question:

Is the process genuinely stable, or is the average hiding risk?

That is why box plots deserve a place in practical day-to-day data analysis. They may not be needed everywhere, but when the question is about consistency and risk, they can be almost vital.

General Disclaimer

This article is intended for general educational and analytical understanding. The examples are simplified to explain the practical value of box plots in business decision-making.

Actual business decisions should be based on complete data, operational context, commercial priorities, and domain judgment. Statistical charts should support decision-making, not replace managerial interpretation.

Exercises in Retail Math 5: Calculation of CP when SP and Margin is given and Vice Versa

 Calculation of CP when SP and Margin% is given.

Remember: CP to SP, divide by 1-Margin%

You buy an item at 200 Rs with a margin of 40%, what should be the SP.

CP = \(\large{\frac{SP}{\text{(1-Margin%)}}}\)

CP = \(\large{\frac{200}{(1-0.4)}}\)

= \(\large{\frac{200}{0.6}}\)

= \(\large{\frac{2000}{6}}\)

= \(\large{\frac{1000}{3}}\)

= 333.33 Rs. 

 Calculation of CP when SP and Margin% is given.

Remember: SP to CP, Multiply by 1-Margin%

You want to sell an item at 200 Rs with a margin of 40%, what should be the CP.

CP= \({SP\times \text{(1-Margin%)}}\)

CP= \({200\times \text{(1-40%)}}\)

= \({200\times \text{60%}}\)

= 120 Rs. 

Exercise 1

You buy an item at 500 Rs with a margin of 25%. What should be the selling price (SP)?

Exercise 2

You want to sell an item at 800 Rs with a margin of 30%. What is the cost price (CP)?

Exercise 3

You buy an item at 1200 Rs with a margin of 20%. Find the selling price (SP).

Exercise 4

You want to sell an item at 150 Rs with a margin of 10%. Calculate the cost price (CP).

Exercise 5

You buy an item at 7000 Rs with a margin of 15%. Determine the selling price (SP).

Exercise 6

You want to sell an item at 450 Rs with a margin of 50%. What should be the cost price (CP)?

Exercise 7

You buy an item at 250 Rs with a margin of 35%. Find the selling price (SP).

Exercise 8

You want to sell an item at 1800 Rs with a margin of 25%. Calculate the cost price (CP).

Exercise 9

You buy an item at 3000 Rs with a margin of 12%. Determine the selling price (SP).

Exercise 10

You want to sell an item at 120 Rs with a margin of 20%. What should be the cost price (CP)?

Exercises in Retail Maths 4: Calculating Contribution %

 Example: I sold 35 items of dresses, 20 items of tops and 10 items of bottoms. What is the contribution % of dresses in the total Sales.

Contribution of Dresses = \(\large\frac{\text{Number of Dresses sold}}{\text{Total Number of Items Sold}}\)

=\(\large\frac{\text{35}}{\text{35+20+10}}\)

=\(\large\frac{\text{35}}{\text{65}}\)

=\(\large\frac{\text{7}}{\text{13}}\)

= 7 *7.69% = 53.83%

Exercises

Exercise 1

You sold 50 items of phones, 30 items of tablets, and 20 items of laptops. What is the contribution percentage of phones in the total sales?

Exercise 2

You sold 200 kg of fruits, 150 kg of vegetables, and 100 kg of dairy products. What is the contribution percentage of vegetables in the total sales?

Exercise 3

You sold 80 fiction books, 50 non-fiction books, and 30 comics. What is the contribution percentage of comics in the total sales?

Exercise 4

You sold 15 chairs, 10 tables, and 5 sofas. What is the contribution percentage of chairs in the total sales?

Exercise 5

You sold 100 lipsticks, 80 foundations, and 50 mascaras. What is the contribution percentage of foundations in the total sales?

Exercise 6

You sold 60 dolls, 40 action figures, and 20 board games. What is the contribution percentage of board games in the total sales?

Exercise 7

You sold 50 sneakers, 30 sandals, and 20 boots. What is the contribution percentage of sneakers in the total sales?

Exercise 8

You sold 25 mixers, 20 toasters, and 15 blenders. What is the contribution percentage of toasters in the total sales?

Exercise 9

You sold 200 pens, 150 notebooks, and 100 markers. What is the contribution percentage of markers in the total sales?

Exercise 10

You sold 40 curtains, 30 rugs, and 20 lamps. What is the contribution percentage of curtains in the total sales?

Exercises in Retail Maths 3: Calculating Average Selling Price

 Example:  I have 3 categories of fashion: Dresses, Kurtas and Bottoms. Last day I sold 20 Dresses at an average Selling price of 100 Rs, 10 Kurtas at an average selling price of 90 Rs. and 5 Bottoms at an average Selling price of 60 Rs. What is my overall average Selling Price.

In such cases, we use the concept of weighted average. My Weighted average is 

(No of Items in Category 1 x ASP of Category 1 + No of Items in Category 2 x ASP of Category 2 +No of Items in Category 3 x ASP of Category 3 )/ ( Total Number of Items in the Category)

\(\small\frac{\text{No of  Items in Category 1} \times\text{ ASP of Category1} + \text{No of  Items in Category 2} \times\text{ ASP of Category2} +\text{No of  Items in Category 3} \times\text{ ASP of Category 3} }{\text{Total Number of Items in all the categories}}\) 

=\(\large\frac{\text{20} \times\text{ 100} + \text{10} \times\text{ 90} +\text{5} \times\text{ 60} }{\text{20+10+5}}\) 

=\(\large\frac{\text{2000} + \text{900} +\text{300} }{\text{35}}\) = 91.42 Rupees

Exercises

Exercise 1

You have 3 categories of electronics: Phones, Laptops, and Tablets. Last day you sold 15 Phones at an average selling price of 15,000 Rs, 8 Laptops at an average selling price of 50,000 Rs, and 12 Tablets at an average selling price of 20,000 Rs. What is your overall average selling price?

Exercise 2

You have 3 categories of groceries: Fruits, Vegetables, and Dairy. Last day you sold 25 kg of Fruits at an average selling price of 80 Rs/kg, 30 kg of Vegetables at an average selling price of 50 Rs/kg, and 20 liters of Dairy at an average selling price of 60 Rs/liter. What is your overall average selling price?

Exercise 3

You have 3 categories of books: Fiction, Non-Fiction, and Comics. Last day you sold 40 Fiction books at an average selling price of 300 Rs, 25 Non-Fiction books at an average selling price of 400 Rs, and 35 Comics at an average selling price of 150 Rs. What is your overall average selling price?

Exercise 4

You have 3 categories of furniture: Chairs, Tables, and Sofas. Last day you sold 10 Chairs at an average selling price of 2,000 Rs, 5 Tables at an average selling price of 5,000 Rs, and 3 Sofas at an average selling price of 10,000 Rs. What is your overall average selling price?

Exercise 5

You have 3 categories of cosmetics: Lipsticks, Foundations, and Mascaras. Last day you sold 50 Lipsticks at an average selling price of 200 Rs, 30 Foundations at an average selling price of 500 Rs, and 40 Mascaras at an average selling price of 150 Rs. What is your overall average selling price?

Exercise 6

You have 3 categories of toys: Dolls, Action Figures, and Board Games. Last day you sold 25 Dolls at an average selling price of 300 Rs, 15 Action Figures at an average selling price of 400 Rs, and 10 Board Games at an average selling price of 600 Rs. What is your overall average selling price?

Exercise 7

You have 3 categories of footwear: Sneakers, Sandals, and Boots. Last day you sold 20 Sneakers at an average selling price of 1,500 Rs, 15 Sandals at an average selling price of 800 Rs, and 10 Boots at an average selling price of 2,500 Rs. What is your overall average selling price?

Exercise 8

You have 3 categories of kitchen appliances: Mixers, Toasters, and Blenders. Last day you sold 10 Mixers at an average selling price of 3,000 Rs, 8 Toasters at an average selling price of 2,000 Rs, and 6 Blenders at an average selling price of 4,000 Rs. What is your overall average selling price?

Exercise 9

You have 3 categories of stationery: Pens, Notebooks, and Markers. Last day you sold 100 Pens at an average selling price of 20 Rs, 50 Notebooks at an average selling price of 100 Rs, and 30 Markers at an average selling price of 50 Rs. What is your overall average selling price?

Exercise 10

You have 3 categories of home decor: Curtains, Rugs, and Lamps. Last day you sold 12 Curtains at an average selling price of 1,000 Rs, 8 Rugs at an average selling price of 3,000 Rs, and 5 Lamps at an average selling price of 1,500 Rs. What is your overall average selling price?

Exercises in Retail Maths 2: Quick mental Conversion of Markup% to Margin% and Vice Versa

We know now the concept of Markup and Margin ( Refer to the Post here)

To understand how can we quickly and mentally convert markup% to margin% and vice versa, here is a suggested framework.

Step 1: Remember this table of conversion of fraction to percentage:

\(\large \frac{1}{1}\) = 100%

\(\large \frac{1}{2}\) = 50%

\(\large \frac{1}{3}\) = 33.33%

\(\large \frac{1}{4}\) = 25%

\(\large \frac{1}{5}\) = 20%

\(\large \frac{1}{6}\) = 16.66%

\(\large \frac{1}{7}\) = 17.28%

\(\large \frac{1}{8}\) = 12.5%

\(\large \frac{1}{9}\) = 11.11%

\(\large \frac{1}{10}\) = 10%

\(\large \frac{1}{11}\) = 9.09%

\(\large \frac{1}{12}\) = 8.33%

\(\large \frac{1}{13}\) = 7.69%

Step 2: Make use of one of the Rules to convert

Rule 1: To convert Markup% to Margin% divide the Numerator of fraction obtained from Markup% by the (Addition of Numerator & Denominator of the fraction )

Example: Convert 50% Markup  to Margin %

Answer: 

50% Markup is equivalent to 50/100 in fraction 

So divide 50 by 50+100

\(\large \frac{50}{50+100}\) = \(\large \frac{50}{150}\)= \(\large \frac{1}{3}\)= 33.33% ( From Table above)

So 50% Markup is equivalent to 33.33% Margin. 

Rule 1: To convert Margin% to Markup% divide the Numerator of fraction obtained from Margin% by the (Denominator-Numerator)

Example: Convert 50% Margin to Markup %

Answer: 

50% Margin is equivalent to 50/100 in fraction 

So divide 50 by 100-50

\(\large \frac{50}{100-50}\) = \(\large \frac{50}{50}\)= \(\large \frac{1}{1}\)= 100% (From Table above)

So 50% Margin is equivalent to 100% Markup

Exercises ( Try to Do Mentally- If you Cram the table above, it will be very easy for you):

1. Convert 40% Markup to Margin%
2. Convert 25% Margin to Markup%
3. Convert 60% Markup to Margin%
4. Convert 33.33% Margin to Markup%
5. Convert 75% Markup to Margin%
6. Convert 20% Margin to Markup%
7. Convert 100% Markup to Margin%
8. Convert 16.66% Margin to Markup%
9. Convert 30% Markup to Margin%
10. Convert 12.5% Margin to Markup%

Exercises in Retail Maths: Related to Markup and Margin

 1. Problems Related to Markup and Margin 

Markup and Margin both are the difference between Selling Price and Cost Price

eg. A retailer buys a saree at 100 Rs. and sells it for 150 Rs. what would be the markup. What would be the margin.

Solution:

Markup=150-100 = 50 Rs. 

Margin = 150-100=50 Rs. 

 1. Problems Related to Markup% and Margin%

Markup is calculated on the Cost price and Margin is calculated on the Selling Price

Markup%= $\frac{Selling Price-Cost Price}{Cost Price}$

Magin%=$\frac{Selling Price-Cost Price}{Selling  Price}$

for example, in the above case: markup% is defined as

Markup%= $\frac{150-100}{100}$ = 50%

Margin%= $\frac{150-100}{150}$ = 33%

Exercise 1

A retailer buys a pair of shoes for 80 Rs and sells it for 120 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Exercise 2

A shop owner buys a jacket for 200 Rs and sells it for 260 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Exercise 3

A book is purchased by a bookstore for 150 Rs and sold for 225 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Exercise 4

A mobile phone is bought for 5000 Rs and sold for 6500 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Exercise 5

A laptop is bought for 30000 Rs and sold for 37500 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Exercise 6

A refrigerator is bought for 15000 Rs and sold for 19500 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Exercise 7

A TV is bought for 25000 Rs and sold for 31500 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Exercise 8

A washing machine is bought for 18000 Rs and sold for 23400 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Exercise 9

A microwave oven is bought for 8000 Rs and sold for 10400 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Exercise 10

A bicycle is bought for 7000 Rs and sold for 9100 Rs. Calculate the Markup, Margin, Markup%, and Margin%.

Write the answers to the exercises in Comments.

How to Analyze Box Plots

 

There are two ways that you can analyze box plots. Consider the above plot showing sales of a particular brand per day across all stores over the months from February (2) and June (6). Let's assume June has 30 days. 

1. Analyze a single Box Plot

2. Compare two or more box plots

We'll study them separately.

1. Analyze a single Box Plot

There are Six points that you need to focus on when you are analyzing a single box Plot

    a. Total Size of the Plot

The total size of the plot indicates the range of the values. For example, in June month, the sales per day varies from 0 to 20000. 

    b. Absolute Position of Median

Roughly 50% of the values fall below this value, and 50% of the values fall above. So in June month, the median sales per day is about 7500 Rs. With about 15 days below 7500 Rs. and 15 days above 7500 Rs.  Considering the range from the size of plot in point b,  it is lower, as it should be around 10000 Rs. Which means that there are more days with values less than 10K then there are days with values more than 10K.

    c. Position of the Median Relative to Box

Median is at the lower half of the box. It indicates that the distribution is right skewed, which means that more days have low values and some days have higher values. This is also supported by the point b. combined with a. as indicated above. 

    d. Size of the box compared to the range. 

The size of the box indicates the Inter-quartile range i.e. the values between 1st quartile and 3rd quartile. It simply indicates the middle 50% values of the data. It is relatively robust and free from the extreme values. So we can see for June data that values lie roughly between 5000 and 12000. Their average is 8500 whereas median is at 7500, lower than the ideal mid. The IQR is about 12000-5000 = 7000 which when comparing with the range of 0 to 20000, is relatively less. It indicates that there are more extreme values. 

7. Relative Lengths of two Whiskers

We can see that upper whisker is more than lower whisker. Whiskers indicate extreme values. So the data has more extreme values at the upper end than extreme values at the lower end. 

8. Relative Lengths of Whiskers compared to the Box

We can see that  size of upper whisker is less than 1.5 times that of size of box. It means that the value of the end of whisker is the maximum value ( apart from outlier)  at about 20000. Similarly the size of lower whisker is less than 1.5 times less than the size of box. It means that the value of the end of lower whisker is the min value at about 0. 

9. Outliers

These are values that more than 1.5 times the IQR. So there is no outlier here. 

SUMMARY

The box plot analysis of daily sales data for the brand in June reveals several key insights. The total range of sales per day varies from 0 to 20,000 Rs., indicating a wide range of sales values. The median sales per day stands at around 7,500 Rs., with approximately half of the days below this value and the other half above. Notably, there are more days with sales below 10,000 Rs. than above, indicating a skewed distribution skewed towards lower sales. The interquartile range (IQR), representing the middle 50% of the data, spans from 5,000 to 12,000 Rs., which is relatively small compared to the overall range. This suggests the presence of more extreme sales values, particularly at the upper end. The absence of outliers suggests a consistent dataset. The length of the upper whisker exceeds that of the lower whisker, indicating more extreme sales values at the higher end.

So the sales per day in the month shows a high variability with more extreme values towards the upper part of data, thus indicating a right skewed data. This could have happened because of some event, probably a discount sale. 

1. Compare two or more box Plots

To compare two box plots, you can visually analyze their key components and consider the following aspects:

Size : Size of the plot from whisker to whisker can be used for comparison . If the size is more, the data in the plot is more spread out. 

Overlapping: Check if the boxes and whiskers of the two box plots overlap. If the boxes or whiskers overlap significantly, it suggests that the distributions of the two datasets have similarities in terms of central tendency and spread. On the other hand, if the boxes and whiskers do not overlap or have minimal overlap, it indicates potential differences between the distributions.

for example comparing May and June, the boxes overlap significantly. 

Median Comparison: Compare the positions of the medians in the two box plots. If one median is higher than the other, it suggests a difference in the central tendency of the two datasets. A higher median in one box plot indicates higher values or sales compared to the other dataset.

for example comparing May and June, the medians are similar

Quartiles: Examine the quartiles (Q1 and Q3) of the two box plots. If the two datasets have similar quartiles, it suggests similarities in the lower and upper ranges of the data. If the quartiles differ, it indicates differences in the spread of the data or the range of sales.

The quartiles are also similar

Outliers: Pay attention to any outliers in the box plots. Compare the presence, position, and magnitude of outliers in each plot. Unusual outliers may indicate unique patterns or extreme values in one dataset compared to the other.

There is an outlier in May.

Overall Shape: Observe the overall shape of the box plots. If the boxes are similar in length, it suggests similar variability in the two datasets. If one box is longer than the other, it indicates a larger range or greater variability in the corresponding dataset.

Conclusion

In comparing box plots of May and June, there shapes are similar, however, there are more extreme values in June than in May

Post Notes

Relation between Box Plots and Normal Distribution

If we are looking at the box plot of a normal distribution, the relationship is as follows:

Thus the "box" is about 0.67 std deviation on both sides and the "whiskers" are about 2.69 std deviation on both sides. 

What is a Box Plot

What is a Box Plot 

A box plot, also known as a box-and-whisker plot, is a graphical representation of the distribution of a dataset. It displays a summary of the data's central tendency, spread, and potential outliers. A box plot provides a visual depiction of the quartiles, median, and range of the dataset.

The key components of a box plot include:

Box: The central rectangular shape in the plot represents the interquartile range (IQR), which contains the middle 50% of the data. The bottom of the box represents the first quartile (Q1), and the top represents the third quartile (Q3).

Median: Inside the box, there is a horizontal line that represents the median. The median is the value that separates the lower 50% of the data from the upper 50%.

Whiskers: The lines extending from the box, often with lines or horizontal bars at their ends, are known as whiskers. They represent the range of the data, excluding outliers. The length of the whiskers can vary depending on the method used to calculate them, such as 1.5 times the IQR or extending to the maximum and minimum values.

Outliers: Individual data points that fall significantly outside the whiskers are considered outliers. Outliers are often represented as individual points on the plot, indicated by dots or small circles.

Box plots provide several insights about a dataset:

Central Tendency: The position of the median within the box indicates the central tendency of the data.

Spread: The width of the box and the length of the whiskers provide information about the spread or variability of the data.

Skewness: The asymmetry of the box plot can indicate skewness in the distribution.

Outliers: The presence of outliers outside the whiskers suggests extreme or unusual values.

Box plots are useful for summarizing and comparing distributions across different groups or categories. They provide a concise visualization that helps in understanding the distributional characteristics of the data and identifying potential anomalies or patterns.

Why IQR is so important in a box plot

The interquartile range (IQR) is a crucial component of box plots because it provides valuable information about the spread or variability of the data. The IQR represents the range that contains the middle 50% of the dataset, which is a more robust measure than using the full range (i.e., maximum and minimum values) to describe the spread.

Here are some reasons why the IQR is important in box plots:

Robustness to Outliers: The IQR is less sensitive to outliers compared to the full range. By using the IQR, box plots focus on the central portion of the data and are less affected by extreme values. This makes box plots more resistant to the influence of outliers and provides a more representative measure of the typical spread of the majority of the data.

Summarizing Spread: The IQR summarizes the spread of the middle 50% of the dataset. It provides a compact measure that helps understand the variability of the data without considering each individual value. The width of the box in a box plot represents the IQR, giving a visual representation of the spread.

Comparison of Distributions: The IQR is useful for comparing the spread of different distributions or groups in box plots. By comparing the widths of the boxes, you can quickly assess the relative variability of the datasets being compared. A wider box indicates a larger spread or greater variability, while a narrower box suggests a more tightly clustered distribution.

Identifying Skewness: The IQR, along with the position of the median within the box, can help identify skewness in the data. If the IQR is asymmetrically distributed around the median, it suggests skewness in the dataset. This information helps in understanding the shape and characteristics of the distribution.

Outlier Detection: The IQR is instrumental in identifying potential outliers in the dataset. In many box plot constructions, outliers are defined as individual data points that fall outside a certain range, such as 1.5 times the IQR. By using the IQR as a threshold, box plots can effectively highlight potential extreme values that might require further investigation or analysis.

Overall, the IQR is important in box plots as it provides a robust and concise summary of the spread or variability of the data, allowing for easier comparison, outlier detection, and assessment of skewness. It helps in gaining insights into the distributional characteristics of the dataset while minimizing the influence of outliers.

What are the various possible shapes in a box plot and their interpretation

When analyzing the spread and symmetry of a box plot, you can encounter various shapes that provide insights into the distribution of the data. Here are some common shapes and their interpretations:

Symmetrical Distribution:

A symmetrical distribution is characterized by a box plot where the median is approximately centered within the box, and the whiskers are of similar length. The distribution is balanced, indicating that the data is evenly spread around the median. In such cases, the first quartile (Q1) and the third quartile (Q3) are equidistant from the median. A symmetrical distribution suggests that the dataset is well-behaved and lacks significant skewness.

Skewed Right (Positively Skewed) Distribution:

A skewed right distribution, also known as positively skewed or right-skewed, is indicated by a box plot where the median is closer to the bottom of the box, and the whisker on the upper side (above Q3) is longer than the lower whisker (below Q1). This means that the majority of the data is concentrated on the lower end of the distribution, while a few extreme values extend the upper tail. In this case, the mean is usually greater than the median.

Skewed Left (Negatively Skewed) Distribution:

A skewed left distribution, also known as negatively skewed or left-skewed, is the opposite of a skewed right distribution. The median is closer to the top of the box, and the whisker on the lower side (below Q1) is longer than the upper whisker (above Q3). This indicates that the majority of the data is concentrated on the higher end of the distribution, with a few extreme values in the lower tail. In a negatively skewed distribution, the mean is usually less than the median.

Bimodal Distribution:

A bimodal distribution appears when there are two distinct peaks or modes in the data. In a box plot, this is represented by two separate boxes, each with its own median, whiskers, and outliers. This suggests that the dataset consists of two separate groups or categories, and there may be different underlying factors influencing each group.

Outliers and Extreme Values:

In any distribution, outliers are individual data points that fall significantly outside the whiskers. They are represented as individual points on the plot. Outliers can occur in any distribution shape and may indicate anomalies, errors, or unusual observations. They can have a significant impact on the overall interpretation of the data, so it's important to carefully consider their presence and possible explanations.

By examining the shape of the box plot, including the width of the box, length of the whiskers, and the position of the median, you can gain insights into the spread, symmetry, and potential underlying characteristics of the distribution being represented by the data.

What are the limitations of Box Plots

While box plots are a useful visualization tool, they do have some limitations. It's important to be aware of these limitations when interpreting and using box plots:

Limited Descriptive Statistics: Box plots provide a summary of the data's central tendency, spread, and potential outliers. However, they do not provide detailed information about the shape of the distribution, such as the presence of multiple modes, skewness, or kurtosis. Other statistical measures or additional visualizations may be required to obtain a more comprehensive understanding of the data.

Loss of Information: Box plots provide a simplified representation of the data and can result in the loss of some information. They only show summary statistics, such as quartiles and medians, and do not display the individual data points. Consequently, specific patterns or variations within the data may be obscured.

Unequal Sample Sizes: When comparing box plots with different sample sizes, it's essential to consider that the box sizes may not be directly comparable. A box plot with a larger sample size will typically have a smaller box compared to one with a smaller sample size, even if the spread of the data is similar.

Insensitivity to Distributional Shape: Box plots do not provide detailed information about the shape of the distribution, such as whether it is symmetric, skewed, or bimodal. They cannot differentiate between different types of distributions with similar box plot characteristics. Depending on the context, additional visualizations or statistical tests may be necessary to explore the shape of the distribution.

Handling of Outliers: Box plots can help identify potential outliers, but they do not provide a precise definition or account for the impact of outliers on the distribution. The choice of the method used to define and display outliers, such as the whisker length or threshold, can affect the interpretation of the plot.

Limited to Univariate Analysis: Box plots are primarily designed for univariate analysis, where only one variable is represented. They may not be suitable for exploring relationships or comparisons involving multiple variables simultaneously. In such cases, other types of plots or multivariate techniques might be more appropriate.

Subjective Interpretation: The interpretation of box plots can be subjective to some extent. Different viewers may interpret the same plot differently, especially when assessing the presence or significance of outliers or the symmetry of the distribution. It's crucial to provide context and consider the specific characteristics of the dataset being analyzed.

Despite these limitations, box plots remain a valuable tool for summarizing and comparing distributions, providing a quick visual overview of essential statistical measures. They can serve as a starting point for data exploration and hypothesis generation, but additional analyses and visualizations may be necessary for a comprehensive understanding of the data.

Chapter 6: Predictive Analytics for Fashion Forecasting: Exercises and Solutions

Back to Table of Contents 

Exercise 1:

Write a program that loads a dataset from a CSV file, splits it into training and testing sets using train_test_split, and fits a Support Vector Machine (SVM) classifier on the training data. Finally, evaluate the model using accuracy_score on the test set.

Dataset 

import pandas as pd

from sklearn.datasets import make_classification

# Generate synthetic dataset

X, y = make_classification(

    n_samples=1000,

    n_features=5,

    n_informative=3,

    n_redundant=2,

    n_classes=2,

    random_state=42

)

# Create a DataFrame from the generated data

df = pd.DataFrame(X, columns=['feature1', 'feature2', 'feature3', 'feature4', 'feature5'])

df['target_variable'] = y

# Save the dataset to a CSV file

df.to_csv('dataset.csv', index=False)

Solution

import pandas as pd

from sklearn.svm import SVC

from sklearn.model_selection import train_test_split

from sklearn.metrics import accuracy_score

# Load the dataset from CSV file

df = pd.read_csv('dataset.csv')

# Define the predictor variables and target variable

X = df.drop('target_variable', axis=1)

y = df['target_variable']

# Split the data into training and testing sets

X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=42)

# Create and fit the Support Vector Machine classifier

svm = SVC()

svm.fit(X_train, y_train)

# Make predictions on the test set

y_pred = svm.predict(X_test)

# Evaluate the model

accuracy = accuracy_score(y_test, y_pred)

print("Accuracy:", accuracy)

Exercise 2:

Create a program that reads a dataset from a CSV file, preprocesses the data by scaling the numerical features and encoding categorical variables, and then performs dimensionality reduction using Principal Component Analysis (PCA). Fit a logistic regression model on the transformed data and evaluate its performance using cross_val_score.

Dataset

import pandas as pd

from sklearn.datasets import make_classification

from sklearn.preprocessing import MinMaxScaler, OneHotEncoder

# Generate synthetic dataset

X, y = make_classification(

    n_samples=1000,

    n_features=5,

    n_informative=3,

    n_redundant=2,

    n_classes=2,

    random_state=42

)

# Create a DataFrame from the generated data

df = pd.DataFrame(X, columns=['numerical1', 'numerical2', 'numerical3', 'categorical1', 'categorical2'])

df['target_variable'] = y

# Map categorical columns to string labels

df['categorical1'] = df['categorical1'].map({0: 'A', 1: 'B'})

df['categorical2'] = df['categorical2'].map({0: 'X', 1: 'Y'})

# Scale numerical features

scaler = MinMaxScaler()

df[['numerical1', 'numerical2', 'numerical3']] = scaler.fit_transform(df[['numerical1', 'numerical2', 'numerical3']])

# One-hot encode categorical variables

encoder = OneHotEncoder(sparse=False)

encoded_features = pd.DataFrame(encoder.fit_transform(df[['categorical1', 'categorical2']]), columns=encoder.get_feature_names(['categorical1', 'categorical2']))

df.drop(['categorical1', 'categorical2'], axis=1, inplace=True)

df = pd.concat([df, encoded_features], axis=1)

# Save the dataset to a CSV file

df.to_csv('dataset.csv', index=False)

 Solution

import pandas as pd

from sklearn.preprocessing import StandardScaler, OneHotEncoder

from sklearn.decomposition import PCA

from sklearn.linear_model import LogisticRegression

from sklearn.model_selection import cross_val_score

# Load the dataset from CSV file

df = pd.read_csv('dataset.csv')

# Separate the predictor variables and target variable

X = df.drop('target_variable', axis=1)

y = df['target_variable']

# Preprocess the data

# Scale the numerical features

numerical_features = X.select_dtypes(include=['float64', 'int64'])

scaler = StandardScaler()

scaled_numerical_features = scaler.fit_transform(numerical_features)

# Encode categorical variables

categorical_features = X.select_dtypes(include=['object'])

encoder = OneHotEncoder(sparse=False)

encoded_categorical_features = encoder.fit_transform(categorical_features)

# Combine the scaled numerical and encoded categorical features

preprocessed_X = pd.DataFrame(

    data=scaled_numerical_features,

    columns=numerical_features.columns

).join(

    pd.DataFrame(

        data=encoded_categorical_features,

        columns=encoder.get_feature_names(categorical_features.columns)

    )

)

# Perform dimensionality reduction using PCA

pca = PCA(n_components=3)

transformed_X = pca.fit_transform(preprocessed_X)

# Fit a logistic regression model on the transformed data

logreg = LogisticRegression()

logreg.fit(transformed_X, y)

# Evaluate the model using cross_val_score

scores = cross_val_score(logreg, transformed_X, y, cv=5)

average_accuracy = scores.mean()

print("Average Accuracy:", average_accuracy)

Exercise 3:

Write a program that loads a dataset from a CSV file, splits it into training and testing sets, and trains a Random Forest Classifier on the training data. Use GridSearchCV to tune the hyperparameters of the Random Forest Classifier and find the best combination. Finally, evaluate the model's performance on the test set using classification_report.

Dataset 

import pandas as pd

from sklearn.datasets import make_classification

# Generate synthetic dataset

X, y = make_classification(

    n_samples=1000,

    n_features=5,

    n_informative=3,

    n_redundant=2,

    n_classes=2,

    random_state=42

)

# Create a DataFrame from the generated data

df = pd.DataFrame(X, columns=['feature1', 'feature2', 'feature3', 'feature4', 'feature5'])

df['target_variable'] = y

# Save the dataset to a CSV file

df.to_csv('dataset.csv', index=False)

Solution

import pandas as pd

from sklearn.ensemble import RandomForestClassifier

from sklearn.model_selection import train_test_split, GridSearchCV

from sklearn.metrics import classification_report

# Load the dataset from CSV file

df = pd.read_csv('dataset.csv')

# Separate the predictor variables and target variable

X = df.drop('target_variable', axis=1)

y = df['target_variable']

# Split the data into training and testing sets

X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=42)

# Create a Random Forest Classifier

rf = RandomForestClassifier()

# Define the hyperparameters to tune

param_grid = {

    'n_estimators': [100, 200, 300],

    'max_depth': [None, 5, 10],

    'min_samples_split': [2, 5, 10]

}

# Perform GridSearchCV to find the best combination of hyperparameters

grid_search = GridSearchCV(estimator=rf, param_grid=param_grid, cv=5)

grid_search.fit(X_train, y_train)

# Get the best model

best_model = grid_search.best_estimator_

# Make predictions on the test set

y_pred = best_model.predict(X_test)

# Evaluate the model's performance

report = classification_report(y_test, y_pred)

print("Classification Report:")

print(report)

Exercise 4:

Create a program that reads a dataset from a CSV file, preprocesses the data by imputing missing values and scaling the features, and splits it into training and testing sets. Fit a K-Nearest Neighbors (KNN) classifier on the training data and determine the optimal value of K using cross-validation. Evaluate the model's performance on the test set using accuracy_score.

Dataset 

import pandas as pd

from sklearn.datasets import make_classification

from numpy import nan

# Generate synthetic dataset with missing values

X, y = make_classification(

    n_samples=1000,

    n_features=5,

    n_informative=3,

    n_redundant=2,

    n_classes=2,

    random_state=42

)

# Introduce missing values

X[10:20, 1] = nan

X[50:55, 3] = nan

X[200:210, 2] = nan

# Create a DataFrame from the generated data

df = pd.DataFrame(X, columns=['feature1', 'feature2', 'feature3', 'feature4', 'feature5'])

df['target_variable'] = y

# Save the dataset to a CSV file

df.to_csv('dataset.csv', index=False)

Solution

import pandas as pd

from sklearn.impute import SimpleImputer

from sklearn.preprocessing import StandardScaler

from sklearn.neighbors import KNeighborsClassifier

from sklearn.model_selection import train_test_split, cross_val_score

from sklearn.metrics import accuracy_score

# Load the dataset from CSV file

df = pd.read_csv('dataset.csv')

# Separate the predictor variables and target variable

X = df.drop('target_variable', axis=1)

y = df['target_variable']

# Preprocess the data

# Impute missing values

imputer = SimpleImputer(strategy='mean')

X_imputed = imputer.fit_transform(X)

# Scale the features

scaler = StandardScaler()

X_scaled = scaler.fit_transform(X_imputed)

# Split the data into training and testing sets

X_train, X_test, y_train, y_test = train_test_split(X_scaled, y, test_size=0.2, random_state=42)

# Fit a K-Nearest Neighbors (KNN) classifier

k_values = [3, 5, 7, 9, 11]  # Values of K to evaluate

best_accuracy = 0

best_k = 0

for k in k_values:

    knn = KNeighborsClassifier(n_neighbors=k)

    scores = cross_val_score(knn, X_train, y_train, cv=5)

    average_accuracy = scores.mean()

    if average_accuracy > best_accuracy:

        best_accuracy = average_accuracy

        best_k = k

# Fit the best KNN model on the training data

knn = KNeighborsClassifier(n_neighbors=best_k)

knn.fit(X_train, y_train)

# Make predictions on the test set

y_pred = knn.predict(X_test)

# Evaluate the model's performance

accuracy = accuracy_score(y_test, y_pred)

print("Accuracy:", accuracy)

Exercise 5:

Write a program that loads a dataset from a CSV file, preprocesses the data by applying feature selection techniques such as SelectKBest or Recursive Feature Elimination (RFE). Split the data into training and testing sets and train a Decision Tree Classifier on the selected features. Evaluate the model's performance using a confusion matrix and plot the decision tree using graphviz.

Dataset

import pandas as pd

from sklearn.datasets import make_classification

# Generate synthetic dataset

X, y = make_classification(

    n_samples=1000,

    n_features=10,

    n_informative=5,

    n_redundant=2,

    n_classes=2,

    random_state=42

)

# Create a DataFrame from the generated data

df = pd.DataFrame(X, columns=['feature1', 'feature2', 'feature3', 'feature4', 'feature5',

                              'feature6', 'feature7', 'feature8', 'feature9', 'feature10'])

df['target_variable'] = y

# Save the dataset to a CSV file

df.to_csv('dataset.csv', index=False)

Solution

import pandas as pd

from sklearn.feature_selection import SelectKBest, RFE

from sklearn.tree import DecisionTreeClassifier

from sklearn.model_selection import train_test_split

from sklearn.metrics import confusion_matrix

from sklearn.tree import export_graphviz

import graphviz

# Load the dataset from CSV file

df = pd.read_csv('dataset.csv')

# Separate the predictor variables and target variable

X = df.drop('target_variable', axis=1)

y = df['target_variable']

# Preprocess the data - Apply feature selection

# SelectKBest

kbest = SelectKBest(k=3)  # Select top 3 features

X_selected = kbest.fit_transform(X, y)

# Recursive Feature Elimination (RFE)

# estimator = DecisionTreeClassifier()  # or any other classifier

# rfe = RFE(estimator, n_features_to_select=3)  # Select top 3 features

# X_selected = rfe.fit_transform(X, y)

# Split the data into training and testing sets

X_train, X_test, y_train, y_test = train_test_split(X_selected, y, test_size=0.2, random_state=42)

# Train a Decision Tree Classifier on the selected features

dt = DecisionTreeClassifier()

dt.fit(X_train, y_train)

# Make predictions on the test set

y_pred = dt.predict(X_test)

# Evaluate the model's performance using a confusion matrix

cm = confusion_matrix(y_test, y_pred)

print("Confusion Matrix:")

print(cm)

# Plot the decision tree using graphviz

dot_data = export_graphviz(dt, out_file=None, filled=True, rounded=True, special_characters=True)

graph = graphviz.Source(dot_data)

graph.render("decision_tree")  # Save the decision tree to a file