1

I have list of order numbers, each containing ordered SKU's(One order may have multiple SKU's) and their ordered Quantities. Now after initial analysis I found that 16/550 SKU;s are there in 50% Orders. Also 5 or more of these 16 SKU's are there in 20% orders. Question: I want to identify top 15-20 SKU's which are present in most of Orders in significant volume(High Quantity). I heard about cluster analysis can cluster these high perfroming SKU's. Can anyone help how to find these high performig SKU's? This concept is known as forward area in warehousing. Thanks Source: Sample Raw data Material Code, Delivery Number, Quantity ordered

Thanks

Vikas Chandra
  • 11
  • 1
  • I think you may need to clarify what the statistical question is here as opposed to the programming one. All your tags are about software. – mdewey Aug 17 '16 at 17:33

1 Answers1

0

You might want to look into association rules. These are available in Statistics via the SPSSINC APRIORI extension command. That requires the R Essentials for Statistics.

JKP
  • 1,349
  • 10
  • 7