Calculating Order-Based Product Relationships

There is an Excel file that teaches how to perform the Calculating Order-Based Product Relationships operation.

Excel Professional Calculating Order-Based Product Relationships

This file analyzes the relationship between products purchased together in the same order. Additionally, the co-occurrence frequency of products is dynamically calculated using a cross-tabulation method. Thus, it becomes easy to see which products are frequently bought together. However, the table automatically updates when new order data is added. Therefore, this approach provides a strong foundation for basket analysis and product recommendations.

Hope it is useful.