List two skus that were purchased most frequently together

Assignment Help Data Structure & Algorithms

Reference no: EM131221992

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 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:- week_4_apriori_data_4.xlsx

Reference no: EM131221992

Questions Cloud

What is the ending inventory balance and cost of goods : What is the ending inventory balance and cost of goods manufactured during the month?

Regulations have been issued since dodd frank was enacted : In 2010, the Dodd-Frank Act authorized the Federal Reserve, - What major regulations have been issued since Dodd-Frank was enacted?

Develop a wealth-transfer plan : Imagine that you are an estate planner and a friend is seeking advice regarding leaving property to his children. He has accumulated approximately $10 million of property that he would like to leave to his children. However, there is a concern that t..

Cause of the seizure was not determined : After testing was performed, the cause of the seizure was not determined, as the physician stated the patient did not have epilepsy. What is the principal diagnoses?

List two skus that were purchased most frequently together : 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.

Define and apply social contract theory : Define and apply social contract theory. Is it appropriate for organizations like the one in the video to use a U.S. law (Fair Labor Standards Act of 1938) to offer low wages for its disabled workers? Why or why not?

Has the crisis worsened or eased : Has the crisis worsened or eased? Has it affected other European or non-European economies? - Have events followed the typical pattern of financial crises?

Develop and manage complex multi-media documents spreadsheet : Provide the appropriate APA formatted citationson the References page to avoid the perception of plagiarism. This includes citing all external sources including the vendor Web sites, assigned readings and videos, the mini case, and other sources,..

Derive an efficient method for computing ranking cube : Extend your framework to handle more advanced measures. One such example could be as follows. Consider an organization donation database, where donors are grouped by "age," "income," and other attributes. Interesting questions include: "Which age ..

User Account

All Pages