Spreadsheet: 868478d1715197033-association-analysis-in-excel-example-data-08-may-2024-_2
Sheet: Sheet1

Order ID | Product
1001 | Black Pants |  |  |  |  | Count of Product | Column Labels
1001 | Blue Pants |  |  |  |  | Row Labels | Black Pants | Blue Pants | Brown T-shirts | [NAME] | Green Shoes | Grey Pants | Orange Shoes | Pink T-shirts | Purple Shoes | Red Pants | White T-shirts | Yellow T-shirts | Grand Total
1001 | Orange Shoes |  |  |  |  | 1001 | 1 | 1 |  |  |  |  | 1 | 1 |  |  | 1 |  | 5
1001 | Pink T-shirts |  |  |  |  | 1002 |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 2
1001 | White T-shirts |  |  |  |  | 1003 | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  | 3
1002 | Green Shoes |  |  |  |  | 1004 | 1 |  | 1 |  | 1 | 1 |  |  | 1 |  |  |  | 5
1002 | Grey Pants |  |  |  |  | 1005 |  | 1 | 1 | 1 |  |  |  |  | 1 | 1 |  |  | 5
1003 | Black Pants |  |  |  |  | 1006 |  | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  | 4
1003 | [NAME] |  |  |  |  | 1007 | 1 |  | 1 |  |  |  |  | 1 | 1 | 1 |  |  | 5
1003 | Red Pants |  |  |  |  | 1008 |  | 1 | 1 | 1 |  |  |  | 1 |  |  | 1 |  | 5
1004 | Black Pants |  |  |  |  | 1009 | 1 |  |  | 1 |  |  |  | 1 |  | 1 |  |  | 4
1004 | Brown T-shirts |  |  |  |  | 1010 |  | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 1 | 6
1004 | Green Shoes |  |  |  |  | 1011 |  |  |  | 1 | 1 |  |  |  |  |  | 1 |  | 3
1004 | Grey Pants |  |  |  |  | 1012 | 1 |  |  |  |  |  |  | 1 | 1 |  | 1 |  | 4
1004 | Purple Shoes |  |  |  |  | 1013 |  |  | 1 |  | 1 |  |  | 1 |  |  |  | 1 | 4
1005 | Blue Pants |  |  |  |  | 1014 | 1 |  | 1 |  | 1 |  | 1 | 1 | 1 | 1 | 1 |  | 8
1005 | Brown T-shirts |  |  |  |  | 1015 | 1 | 1 | 1 |  |  |  |  |  |  |  | 1 | 1 | 5
1005 | [NAME] |  |  |  |  | 1016 |  |  | 1 |  |  |  |  | 1 |  | 1 | 1 | 1 | 5
1005 | Purple Shoes |  |  |  |  | 1017 |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  | 3
1005 | Red Pants |  |  |  |  | 1018 |  |  |  | 1 |  | 1 |  | 1 | 1 |  |  |  | 4
1006 | Blue Pants |  |  |  |  | 1019 |  |  | 1 |  |  | 1 | 1 | 1 |  |  | 1 | 1 | 6
1006 | Green Shoes |  |  |  |  | 1020 | 1 | 1 |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  | 7
1006 | Grey Pants |  |  |  |  | 1021 |  |  | 1 | 1 |  | 1 |  |  | 1 |  | 1 |  | 5
1006 | Orange Shoes |  |  |  |  | 1022 |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 |  | 1 | 8
1007 | Black Pants |  |  |  |  | 1023 |  |  | 1 |  |  |  |  |  |  |  |  | 1 | 2
1007 | Brown T-shirts |  |  |  |  | 1024 |  |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  | 5
1007 | Pink T-shirts |  |  |  |  | 1025 |  | 1 | 1 |  | 1 |  | 1 |  | 1 | 1 |  | 1 | 7
1007 | Purple Shoes |  |  |  |  | 1026 | 1 |  | 1 |  | 1 | 1 |  |  |  | 1 |  |  | 5
1007 | Red Pants |  |  |  |  | 1027 |  | 1 | 1 | 1 |  |  |  |  | 1 |  | 1 |  | 5
1008 | Blue Pants |  |  |  |  | 1028 |  |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  | 1 | 6
1008 | Brown T-shirts |  |  |  |  | 1029 |  |  | 1 | 1 |  |  | 1 |  |  | 1 |  |  | 4
1008 | [NAME] |  |  |  |  | 1030 | 1 |  | 1 |  |  |  |  |  |  |  |  |  | 2
1008 | Pink T-shirts |  |  |  |  | Grand Total | 11 | 11 | 20 | 12 | 11 | 8 | 11 | 16 | 11 | 11 | 11 | 9 | 142
1008 | White T-shirts
1009 | Black Pants
1009 | [NAME]
1009 | Pink T-shirts
1009 | Red Pants
1010 | Blue Pants
1010 | Brown T-shirts
1010 | Orange Shoes
1010 | Pink T-shirts
1010 | White T-shirts
1010 | Yellow T-shirts
1011 | [NAME]
1011 | Green Shoes
1011 | White T-shirts
1012 | Black Pants
1012 | Pink T-shirts
1012 | Purple Shoes
1012 | White T-shirts
1013 | Brown T-shirts
1013 | Green Shoes
1013 | Pink T-shirts
1013 | Yellow T-shirts
1014 | Black Pants
1014 | Brown T-shirts
1014 | Green Shoes
1014 | Orange Shoes
1014 | Pink T-shirts
1014 | Purple Shoes
1014 | Red Pants
1014 | White T-shirts
1015 | Black Pants
1015 | Blue Pants
1015 | Brown T-shirts
1015 | White T-shirts
1015 | Yellow T-shirts
1018 | [NAME]
1018 | Grey Pants
1018 | Pink T-shirts
1018 | Purple Shoes
1019 | Brown T-shirts
1019 | Grey Pants
1019 | Orange Shoes
1019 | Pink T-shirts
1019 | White T-shirts
1019 | Yellow T-shirts
1016 | Brown T-shirts
1016 | Pink T-shirts
1016 | Red Pants
1016 | White T-shirts
1016 | Yellow T-shirts
1023 | Brown T-shirts
1023 | Yellow T-shirts
1024 | Brown T-shirts
1024 | [NAME]
1024 | Green Shoes
1024 | Orange Shoes
1024 | Pink T-shirts
1021 | Brown T-shirts
1021 | [NAME]
1021 | Grey Pants
1021 | Purple Shoes
1021 | White T-shirts
1028 | Brown T-shirts
1028 | [NAME]
1028 | Green Shoes
1028 | Orange Shoes
1028 | Pink T-shirts
1028 | Yellow T-shirts
1027 | Blue Pants
1027 | Brown T-shirts
1027 | [NAME]
1027 | Purple Shoes
1027 | White T-shirts
1029 | Brown T-shirts
1029 | [NAME]
1029 | Orange Shoes
1029 | Red Pants
1022 | Blue Pants
1022 | Brown T-shirts
1022 | [NAME]
1022 | Orange Shoes
1022 | Pink T-shirts
1022 | Purple Shoes
1022 | Red Pants
1022 | Yellow T-shirts
1030 | Black Pants
1030 | Brown T-shirts
1020 | Black Pants
1020 | Blue Pants
1020 | Grey Pants
1020 | Orange Shoes
1020 | Pink T-shirts
1020 | Purple Shoes
1020 | Red Pants
1017 | Blue Pants
1017 | Green Shoes
1017 | Pink T-shirts
1025 | Blue Pants
1025 | Brown T-shirts
1025 | Green Shoes
1025 | Orange Shoes
1025 | Purple Shoes
1025 | Red Pants
1025 | Yellow T-shirts
1026 | Black Pants
1026 | Brown T-shirts
1026 | Green Shoes
1026 | Grey Pants
1026 | Red Pants