Spreadsheet Computation of Market Basket Analysis

By Kardi Teknomo, PhD.

<Contents | Previous | Next >

For our demonstration example, we have only 4 items (Apple, Banana, Cherry and Durian), therefore it is possible to compute exhaustively. We will use MS Excel 2007 for this purpose.

Step by step computation of Market Basket Analysis is as follow:

•  Generate all possible association rules

•  Compute the support and confidence of all possible association rules

•  Apply two threshold criteria: minimum support and minimum confidence to obtain the association rules.

<Contents | Previous | Next >

Rate this tutorial or give your comments about this tutorial

This tutorial is copyrighted.

Preferable reference for this tutorial is

Teknomo, Kardi. Mean and Average. http:\\people.revoledu.com\kardi\ tutorial\BasicMath\Average\