I have a data set of sales of a supermarket. The first column is the ticket number, the second column is the code of the item sold and the third column is the name of the item. How can I calculate the correlation of the items. For example, if I sell a cup of coffee, 60% of the time in the same ticket will be a cookie present.

example of the data set of excel

I tried the CORREL function in excel, but only works for numerical data.