Kardi Teknomo
Kardi Teknomo Kardi Teknomo Kardi Teknomo


Visit Tutorials below:
Adaptive Learning from Histogram
Adjacency matrix
Analytic Hierarchy Process (AHP)
ArcGIS tutorial
Arithmetic Mean
Bayes Theorem
Bootstrap Sampling
Bray Curtis Distance
Break Even Point
Chebyshev Distance
City Block Distance
Conditional Probability
Complex Number
Continued Fraction
Data Analysis from Questionnaire
Data Revival from Statistics
Decimal to Rational
Decision tree
Difference equations
Digital Root
Discriminant analysis
Eigen Value using Excel
Euclidean Distance
Euler Integration
Euler Number
Excel Iteration
Excel Macro
Excel Tutorial
Expectation Maximization (EM) Algorithm
Factorial Function
Feasibility Study
Financial Analysis
Financial Education
Gaussian Mixture Model
Generalized Inverse
Generalized Mean
Geometric Mean
Ginger Bread Man and Chaos
Graph Theory
Growth Model
Hamming Distance
Harmonic Mean
Hierarchical Clustering
Independent Events
Incident matrix
Jaccard Coefficient
Kernel basis function
Kernel Regression
k-Means clustering
K Nearest Neighbor
LAN Connections Switch
Learning from data
Lehmer Mean
Linear Algebra
Logarithm Rules
Mahalanobis Distance
Market Basket Analysis
Mean Absolute Deviation
Mean and Average
Mean, median, mode
Minkowski Distance
Minkowski Mean
Monte Carlo Simulation
Multi Agent System
Maximum Likelihood
Multicriteria decision making
Mutivariate Distance
Neural Network
Newton Raphson
Non-Linear Transformation
Normalization Index
Normalized Rank
Ordinary Differential Equation
Page Rank
Power rules
Prime Factor
Prime Number
Q Learning
Quadratic Function
Queueing Theory
Rank Reversal
Recursive Statistics
Regression Model
Reinforcement Learning
Root of Polynomial
Scenario Analysis
Sierpinski gasket
Sieve of Erastosthenes
Similarity and Distance
Solving System Equation
Standard deviation
String Distance
Summation Tricks
Support Vector Machines
System dynamic
Time Average
Tower of Hanoi
Vedic Square
Visual Basic (VB) tutorial
What If Analysis

Market Basket Analysis

By Kardi Teknomo, PhD.

Share this: Google+

You may often see these kinds of words in many web sites: Customers who bought this item also bought …., Browse related titles…., or Explore similar items. The suggested items are derived association of the item that you currently see. For example, people who buy bread and cheese may also buy butter, jam, milk and honey. People who buy cold medicine frequently will also buy tissue and orange juice. Knowing the associations of purchase between various items is very important in business for product promotion, cross-selling and product placement.

How such association above is computed? This tutorial will introduce you to Market Basket Analysis through step by step demonstration on a spreadsheet (MS Excel) where you can learn to discover association rules from transaction data of a store. The spreadsheet companion of this tutorial can be downloaded here.

What is Market Basket Analysis?

Spreadsheet Computation of Market Basket Analysis

Generating All Possible Association Rules

Computing Support and Confidence

Filtering Association Rules

Characteristics of Market Basket Analysis

Cautions with Market Basket Analysis

Applications of Market Basket Analysis


Rate this tutorial or give your comments about this tutorial


This tutorial is copyrighted.

Preferable reference for this tutorial is

Teknomo, Kardi (2008) Market Basket Analysis. http://people.revoledu.com/kardi/tutorial/MarketBasket/



© 2007 Kardi Teknomo. All Rights Reserved.
Designed by CNV Media