Explain k-means clustering algorithm to group the homicides

Assignment Help Database Management System
Reference no: EM13313663

In this assignment, analyze crime rates using data mining clustering techniques (K-means) to get an accurate prediction to enable police forces to get a clear picture of criminals and solve crimes.

For part (a): k-means clustering algorithm to group the crime data objects based on the seventh district of Columbia.

First: Manually by hand.

Second: Using Xlminer tools or any other data mining tools and I want the result to be on this map (Dc Districts)

1681_clustering 1.png

 

874_clustering 2.png

2092_clustering 3.png

 

For part (b): I need to do k-means clustering algorithm to group the homicides data objects in the different districts.

First: Manually by hand.

Second: Using Xlminer tools or any other data mining tools and I want the result to be on this map (Dc Districts)

561_clustering 4.png

2037_clustering 5.png

 

 

 

 

Reference no: EM13313663

Questions Cloud

Determine the required dimensions of a hollow steel shaft : Determine the required dimensions. The inside diameter is to be two- thirds of the outside diameter. The allowable shearing stress is 70 MPa, and the angle of twist is not to exceed 4 degree in 3 m of the shaft.
Explain the mechanism of sn1 silver nitrate in ethanol : Show the mechanism of SN1 Silver Nitrate in ethanol with 2-bromobutane Show the mechanism of SN2 Sodium Iodide in acetone with 2-bromobutane Arrows
Determine the magnitude of the buoyant force on the rod : A long rod of lenght " L " and cross sectional area "A" is weighted such that when it is placed in a bucket of water it floats vertically. determine the magnitude of the buoyant force on the rod
A trader is designing his investment portfo : A trader is designing his investment portfolio. He has prepared a list of potential companies in which to  purchase stock. These include 5 companies in agriculture, 6 companies in manufacturing and 9  companies in the high-tech industry. The trade..
Explain k-means clustering algorithm to group the homicides : In this assignment, analyze crime rates using data mining clustering techniques (K-means) to get an accurate prediction to enable police forces to get a clear picture of criminals and solve crimes.
Design a hollow steel shaft with an inside diameter : Design a hollow steel shaft with an inside diameter 1/3 that of the outside diameter. The shaft transmits 200 kW at a speed of 20 Hz. The allowable shearing stress is 55 MPa, and the allowable angle of twist is 1 degree per meter of length.
What is the altitude : Estimate the thickness of the Earth's atmosphere. From your chemistry class, you know that the most common speed of a nitrogen molecule is 640 m/s. What is the altitude
Compute the total pressure inside the vessel : A 1.25-gram sample of FeC2O4 is added to an evacuated 2.00-L steel vessel. The vessel is heated to 400°C, at which point all the FeC2O4 is decomposed: FeC2O4 (s) # FeO (s) + CO2 (g) + CO (g) Calculate the total pressure inside the vessel at 400°C
Lipitor is a drug used to control cholesterol : Lipitor is a drug used to control cholesterol. In clinical trials of Lipitor, 94 subjects were treated with Lipitor and 270 subjects were given a placebo.

Reviews

Write a Review

Database Management System Questions & Answers

  Advantages of database approach over file-system approach

How and why did database management systems become the organizational data management standard? Describe some advantages of database approach over file-system approach.

  Wallsherpool sixth - theatre company

A report that shows the characters that still need actors for the current performance and storing the student details if all requirements are met, providing a suitable message for Vicky

  Describe the different procedure performed in dbms

Describe the different procedure performed in DBMS for student database in which fields are student id, student name, student class, marks.

  Transform the tables into one or more tables in bcnf

Transform the tables into one or more tables in BCNF. State the primary keys, candidate keys, and referential integrity constraints.

  Describe the different operations of relational algebra

Describe relationships with the example. Also illustrate degree of relationship for that example. Describe the different operations of relational algebra with suitable example each.

  Create a function

Create a function that returns the day of the week for a specified date. Create a trigger that displays the message "Emp table updated" when an update to the employee table increases the employee's basic salary.

  Create a corresponding xmlschema file

A simple database with a single table contains data concerning car registration. The table contains four fields that store data relating to registration number (unique), make of car, year of manufacture and car colour

  Explaining content of document in natural language

Explain the content of this document in natural language;Design the graph representation of document;

  Study and modify the postgresql source code

Write a Assignment to study and modify the PostgreSQL source code, with a focus on one of the core modules - the buffer manager

  When does oracle stop processing the query

How does Oracle process this query? That is, what does Explain Plan tell you about how the query is processed - how would you recognize that the results were not correct?

  Show the database development processes

Assume you were a newly hired IT Security Manager at a software development company that in the past hasn't paid much attention to security, especially in its database development processes.

  Create database to produce reports using surrogate keys

Complete following task. In each exercise, represent answer in both DBDL and with diagram. You may use any of styles for diagram. Create database to produce following reports. Do not use any surrogate keys in design.

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!

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