User Account

All Pages

Plot the data on a scatter plot

Assignment Help Database Management System
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.

Reference no: EM131304105

Questions Cloud

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

Reviews

Write a Review

Database Management System Questions & Answers

  Defines the semantic checks necessary to produce

The third project involves writing the semantic analyzer for the compiler that was begun in the previous projects. To simplify the semantic error checking, you are to remove the ability to have multiple functions from the grammar and the ability t..

  Systems administrator for your school

Using the Web, identify the chief information officer, chief information security officer, and systems administrator for your school. Which of these individuals represents the data owner? Data custodian

  List all details of all the records in the customer table

ITECH 1006 - Database Management Systems Assignment. Create a text file called nnnnnnnn_query.sql (where nnnnnnnn is your student number).  The file should include the SQL statements necessary to display the following reports: List all details of a..

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Design a high-level conceptual view of a data warehouse

Design a high-level conceptual view of a data warehouse (DW) for Huffman Trucking using Microsoft Visio that shows the following: Integration layers

  Write two programs which will work with a structure

Write two programs which will work with a structure. a) The first program will use a structure to store the following inventory data in a file: Item Description Quantity on Hand Wholesale Cost Retail Cost Date Added to Inventory.

  Create table command, and modify it to create a new table

Start with this CREATE TABLE command, and modify it to create a new range_partitioned table named CH07EMPLOYEE_RANGE that contains the same column as the employee table.

  Would you ever want to use a temporary stored procedure

Provide an example of a stored procedure that you might write to demonstrate why this capability is important.

  What does the sd for the two sections tell us

For the variable "Points on Final," what does the SD for the two sections tell us about the performance of the two groups on the final exam?

  Create the entity-relationship diagram for the doctors

Given the following business rules, create the Entity-relationship Diagram:

  Create a sql query for list last and first names of director

List the last and first names of all directors who have directed only one movie. List the movie titles that won both best actor and best actress awards.

  Web server vulnerabilities

Describe at least three web server vulnerabilities and how they are typically exploited. Provide unique answers here, posting early will help.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd