Data Analysis (Apriori Analysis)
Included with this assignment is an Excel spreadsheet containing customer receipts.
The purpose of this assignment is to demonstrate steps performed in an Apriori analysis (i.e. Market Basket analysis).
Review the “APRIORI ALGORITHM” section of Chapter 4 of the Sharda et. al. textbook for additional background.
Use Excel to perform this analysis.
- List the SKU which was purchased the most.
- List the two SKUsthat were purchased most frequently together.
- List the three SKUsthat were purchased most frequently together.
- List the four SKUsthat were purchased most frequently together.
Make note of any pattern that you noticed while performing the analysis. As a retail business owner, how would you use the results from this analysis?