List the SKU which was purchased the most.

Attached Files:

•  Week 4 Apriori data.xlsx (14.042 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?

Sample Solution

Upon conducting an Apriori analysis on the given dataset, the following findings were observed:

• SKU “S4” was purchased the most with a count of 12.
• The two SKUs that were purchased most frequently together were “S4” and “S5” with a count of 6.
• The three SKUs that were purchased most frequently together were “S4”, “S5” and “S2” with a count of 4.
• The four SKUs that were purchased most frequently together were “S4”, “S5”, “S2” and “S3” with a count of 3.

It is observed that SKU “S4” was the most popularly purchased item, which is likely to be the most in-demand product in the store. The combination of SKU “S4” and “S5” was purchased most frequently together, which may imply that these two…order customized answer