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).

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?

 

TRAN#SKU#1SKU#2SKU#3SKU#4SKU#548601111487101114881011148911100257600011317311001377100110467411110467510001467601011467711001635101000635600001635700000636000000636500010637210101637700010637900010638000010638211101638311000638701000639000010639101011639200011639300010640100000640301000640900000641201000641911101642200001643010000643200101643400011643500000643800000644200010644811001645000010645200010645300010645610010645701000645910010646100001

Attachments:

• 1494227682-Week 4 Apriori data 5 SKUs1.xlsx