Apriori method using SPSS Modeler .

Details:

The purpose of this assignment is to perform association rules analysis to determine whether or not the information generated can be used to address a specific business problem.

For this assignment, you will use the “Bakery” data set from the Topic Materials. Most data categories are self-explanatory. Clarifying notes are as follows.

  1. ReceiptID: Unique receipt ID (note that all items with the same receipt ID were purchased together)
  2. Item: Name of the food item that was purchased

A bakery is interested in increasing sales by optimally displaying and arranging its various baked goods and drinks. The bakery would like to know which items are typically purchased together so it can place the correlated items closer together in its display cases. The bakery has randomly selected 1,000 receipts and compiled a list of items that were purchased together for each receipt.

As an analyst, you have been asked to examine the data, summarize your findings, and recommend how the bakery can use these findings to strategically arrange its bakery products to increase sales. Use associative rules analysis to explore the various dependencies among purchased items. Use the Apriori method to do the analysis with a minimum antecedent support of 4%, minimum confidence of 70%, and maximum number of antecedents of 5. Analyze and interpret several of the resulting rules. Present your finding in the form of a 250-word executive summary that includes relevant data, charts, and tables, and addresses the following.

Question 1: How would you explain the concepts of support, confidence, and lift to an executive who is unfamiliar with association rules analysis? Include the Apriori method output chart when submitting the answer.

Question 2: What would you say about the support of the rules derived from the Apriori analysis?

Question 3: If both an apple tart and an apple Danish were purchased, how likely is it that an apple croissant is also purchased? Explain your answer.

Question 4: Does it make sense for the bakery to place all of its apple-flavored items together in the display or is it better to spread them out in the display? Explain why.

Question 5: If the bakery wanted to increase the sales of cherry soda, what cross-promotional offers could it employ? Explain why.

General Requirements:

Submit the executive summary as Word document.

APA format is not required, but solid academic writing is expected.

This assignment uses a grading rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are not required to submit this assignment to Turnitin.

Rubric:

Top of Form

1
Unsatisfactory
0.00%

2
Less than Satisfactory
65.00%

3
Satisfactory
75.00%

4
Good
85.00%

5
Excellent
100.00%

100.0 %Content

10.0 %Support, Confidence, and Lift

Explanation of the concepts of support, confidence, and lift is not included.

Explanation of the concepts of support, confidence, and lift is incomplete or incorrect.

Explanation of the concepts of support, confidence, and lift is included but lack clarity.

Explanation of the concepts of support, confidence, and lift is complete and accurate.

Explanation of the concepts of support, confidence, and lift is expertly crafted.

20.0 %Support for Association Rules

Discussion of support for the association rules derived from Apriori analysis is not included.

Discussion of support for the association rules derived from Apriori analysis is incomplete or incorrect.

Discussion of support for the association rules derived from Apriori analysis is included but lacks relevant supporting data and details.

Discussion of support for the association rules derived from Apriori analysis is complete and includes relevant supporting data and details.

Discussion of support for the association rules derived from Apriori analysis is expertly crafted and includes supporting data and substantial relevant details.

20.0 %Apriori Method Output Chart

Apriori method output chart to support and communicate visual representations of data is not included.

Apriori method output chart to support and communicate visual representations of data is incomplete or incorrect.

Apriori method output chart to support and communicate visual representations of data is included and mostly correct.

Apriori method output chart to support and communicate visual representations of data is complete and correct.

Apriori method output chart to support and communicate visual representations of data is expertly crafted.

40.0 %Recommendations About Promotional Offers

Recommendations about promotional offers that could be implemented based on the results of the association rules are not included.

Recommendations about promotional offers that could be implemented based on the results of the association rules are incomplete or incorrect.

Recommendations about promotional offers that could be implemented based on the results of the association rules are included but lack supporting data and explanation.

Recommendations about promotional offers that could be implemented based on the results of the association rules are complete and include supporting data and explanation.

Recommendations about promotional offers that could be implemented based on the results of the association rules are expertly crafted and supported with substantial data and explanation.

5.0 %Mechanics of Writing (includes spelling, punctuation, grammar, language use)

Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is used.

Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) or word choice are present. Sentence structure is correct but not varied.

Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience-appropriate language are employed.

Prose is largely free of mechanical errors, although a few may be present. The writer uses a variety of effective sentence structures and figures of speech.

Writer is clearly in command of standard, written, academic English.

5.0 %Paper Format (use of appropriate style for the major and assignment)

Template is not used appropriately or documentation format is rarely followed correctly.

Appropriate template is used, but some elements are missing or mistaken. A lack of control with formatting is apparent.

Appropriate template is used. Formatting is correct, although some minor errors may be present.

Appropriate template is fully used. There are virtually no errors in formatting style.

All format elements are correct.

100 %Total Weightage

Bottom of Form