List the three skus that were purchased most frequently


Assignment

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?

Attachment:- Apriori_Data.rar

Solution Preview :

Prepared by a verified Expert
Data Structure & Algorithms: List the three skus that were purchased most frequently
Reference No:- TGS02315255

Now Priced at $30 (50% Discount)

Recommended (93%)

Rated (4.5/5)