Example of the Association Analysis Platform

This example uses the Grocery Purchases.jmp sample data table, which contains transactional data reported by a grocery store. The data table lists the items purchased by 1001 customers, each assigned a unique customer ID. You want to explore the associations among items in order to identify patterns in consumer behavior.

Select Help > Sample Data Library and open Grocery Purchases.jmp.

Select Analyze > Screening > Association Analysis.

Select Product and click Item.

Select Customer ID and click ID.

Click OK.

By default, the Rules report is sorted in decreasing order by Confidence. However, association rules with extremely high confidence also tend to have a higher number of items in the condition set. Since you want to view association rules with smaller condition sets, sort the report by Confidence, but in increasing order.

Right-click in the Rules report and select Sort By Column.

The Select Columns window appears.

Select Confidence and the check the ascending order option.

Click OK.

Figure 20.2 Association Analysis Report

Scroll down the report to where the Confidence values are 58%.

There is an entry in the Rules report table that indicates that 58% of customers who bought an avocado also bought an artichoke. The value of Lift is 1.908, indicating that there is a likely dependency. You want to verify that avocados and artichokes occur in a significant portion of transactions.

10.

Click the disclosure icon next to Frequent Item Sets.

Figure 20.3 Frequent Item Sets Report

The Frequent Item Sets report shows that 36% of customers purchased avocados. The Rules report in Figure 20.2 shows that 58% of these customers also bought artichokes. Because of the large proportion of customers who follow this behavior, the grocery store management might use this information to strategically locate avocados and artichokes.

You also decide to look at the association rules with the highest lift.

11.

Right-click in the Rules report table and select Sort By Column.

The Select Columns window appears.

12.

Select Lift and click OK.

The Rules table is sorted by decreasing values of lift. Notice that the second association rule has a lift of 6.912 and 97% confidence. You want to verify that both the condition set, {Coke, Heineken, sardines}, and the consequent item set, {chicken, ice cream}, have adequate support.

13.

Right-click in the Frequent Item Sets report and select Sort By Column.

The Select Columns window appears.

14.

Select Item Set and the check the ascending order option.

15.

Click OK.

The Frequent Item Sets table is sorted alphabetically by item set. Scroll through the list to see that the condition item set, {Coke, Heineken, sardines}, has 12% support. The consequent item set, {chicken, ice cream}, has 14% support. This association rule has high lift, but represents fewer transactions than the first association rule that you examined.