- Week 4 Apriori data 5 SKUs.xlsx (15.84 KB)
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 SKUs that were purchased most frequently together.
- List the three SKUs that were purchased most frequently together.
- List the four SKUs that 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? The rubric for this assignment can be viewed when clicking on the assignment link.