Reference no: EM131304105
Data Analysis assignment- ApriorI analysis and Cluster analysis
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.
What are the commonly used methods of business buying
: List several characteristics that differentiate transactions involving business customers from consumer transactions.
|
Why are interest rates the opportunity cost of holding gold
: Why are interest rates the opportunity cost of holding gold? What effect are low interest rates likely to have on the price of gold?
|
Premiums received are to be used to service the debt issue
: The capital projects fund temporary accounts were closed, and the capital projects fund was closed by transferring remaining funds to the debt service fund for use in debt repayment. The Parks and Recreation Special Revenue Fund transferred $250,000 ..
|
What are the major components of a firms buying center
: How does demand for business products differ from consumer demand?- What are the major components of a firm's buying center?
|
Plot the data on a scatter plot
: Plot the data on a scatter plot. Determine the ideal number of clusters. Choose random center points (centroids) for each cluster. Using a standard distance formula measure the distance from each data point to each center point.
|
Determine the names and addresses of potential customers
: How do environmental, business, interpersonal, and individual factors affect business purchases?- What function does an industrial classification system help marketers perform?
|
Fit each business market category producer
: Identify organizations in your area that fit each business market category-producer, reseller, government, and institutional. Explain your classifications.
|
What does the phrase multiple deposit creation mean
: Suppose that PNC Bank sells $1 million in Treasury bills to the Fed and then makes a $1 million loan to David's Donut Emporium and Boat Repair. Use a T-account to show the results of these transactions on PNC's balance sheet.
|
Describe how the selected societal trend affects nursing
: In a paper of 1,000-1,250 words, describe how the selected societal trend affects nursing or patient education. Relate the issue to appropriate professional standards and competencies
|