List four skus that were purchased most frequently together

Assignment Help Database Management System

Reference no: EM131304898

ApriorI analysis and Cluster analysis-Data Analysis assignment

CLUSTER ANALYSIS

The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis.

Review the "k-MEANS CLUSTERING ALGORITHM" section in Chapter 4 of the Sharda et. al. textbook for additional background.

Use Excel to perform the following data analysis.

1 Plot the data on a scatter plot.
2 Determine the ideal number of clusters.
3 Choose random center points (centroids) for each cluster. (Note: Each student will select a different random set of centroids.)
4 Using a standard distance formula measure the distance from each data point to each center point.
5 Assign each data point to an initial cluster region based on closeness.
6 For each cluster calculate new center points.
7 Repeat steps 4 through 6.

You will use Excel to help with calculations, but only standard functions should be used (i.e. don't use a plug-in to perform the analysis for you.) You need to show your work doing this analysis the long way. If you were to repeat steps 4 through 6, what will likely happen with the cluster centroids? The rubric for this assignment can be viewed when clicking on the assignment link.

APRIORI ANALYSIS

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? The rubric for this assignment can be viewed when clicking on the assignment link.

Attachment:- Assignment_Data.rar

Reference no: EM131304898

Questions Cloud

How can red reduce likelihood of tcp global synchronization : Research the problem known as "TCP global synchronization." How can RED reduce the likelihood of TCP global synchronization?

Why is code considered important to companys ethics program : On p. 83 Terris discusses the company's ethics code. Why is the code considered important to the company's ethics program? Discuss the importance of ethics training and employee involvement.

Conduct a literature review to obtain material : Conduct a literature review to obtain material related to the assigned theorist and the model. The material should include research conducted in the theory or model, with clinical examples.

Evaluate rationale for holding employees vicariously liable : Critically evaluate the rationale for holding employees vicariously liable for the actions of employees".

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

Write the inverse gaussian in exponential family form : Write the (univariate) inverse Gaussian in exponential family form. Write down a real-valued function of X1, . . . ,Xn that summarizes all the information about θ contained in the data set

Indicate where your optimization techniques will be deployed : Based on Figure 11-6, "New Core WAN at Klamath," draw a network topology map for Klamath and indicate where your optimization techniques will be deployed. Include with the network drawing a written explanation of the optimization techniques.

Identify three concepts that you have learned in the course : Identify three concepts that you have learned in this course that will be useful for project work in your current or future employment organization.

Proposal to manufacture-market fiber-optic device : BioCom, Inc. is weighing a proposal to manufacture and market a fiber-optic device that will continuously monitor blood pressure during cardiovascular surgery and other medical procedures in which precise, real-time measurements are critical. Compute..

User Account

All Pages