Included with this assignment is an excel spreadsheet that, Ask an Expert

Management Studies

Included with this assignment is an Excel spreadsheet that contains data with two dimension values.

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.

Plot the data on a scatter plot.

Determine the ideal number of clusters.

Choose random center points (centroids) for each cluster. (Note: Each student will select a different random set of centroids.)

Using a standard distance formula measure the distance from each data point to each center point.

Assign each data point to an initial cluster region based on closeness.

For each cluster calculate new center points.

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?

View complete question

Management Information System, Management Studies

Category:- Management Information System
Reference No.:- M92084393

Have any Question?Write your Review or question?

Related Questions in Management Information System

For this assignment research the internet or strayer

For this assignment, research the Internet or Strayer databases for information related to improper assumptions concerning accounting information systems. Write a five to seven (5-7) page paper in which you: Based on you ...

Discussion often laws and regulations have an immediate

Discussion : Often laws and regulations have an immediate impact on IT professionals and the security position of an organization. These laws seek to establish and implement controls; maintain, protect, and assess compli ...

Assignment1 you have been asked to help promote a new bill

Assignment 1) You have been asked to help promote a new bill in your state, to which there is much opposition to this bill. Discuss what distributive bargaining is. Discuss the pros and cons which might arise toward the ...

Assignmentread the article provided here titled agile in

Assignment Read the article provided here titled "Agile in Practice - An Agile Success Story" and complete this case study assignment. Write a four to five (4-5) page paper in which you: Determine the key reasons why Del ...

It is an accepted truth that without risk there can be no

It is an accepted truth that without risk there can be no gain. Every individual and organization who wants to succeed must take some risks. Network security and its impact on risk management is not about not taking risk ...

Assignmentan acceptable use policy aup is a very important

Assignment An Acceptable Use Policy (AUP) is a very important policy within organizations to define acceptable employee behavior when accessing company resources. Additionally, there are also legal implications within AU ...

Instructionsrecently a terminated employee used his mobile

Instructions Recently, a terminated employee used his mobile device to log in to the company network and steal sensitive data. As the manager of the information technology (IT) security department, you were asked by your ...

Research the art and evolution of code breaking

Research the art and evolution of code breaking (cryptanalysis). Explore how it was achieved during World War II between the Axis and Allies in terms of Enigma and Ultra. Then research how its done today -compare and con ...

Suppose that frames are 500 bytes long which includes 58

Suppose that frames are 500 bytes long which includes 58 bytes of overhead. Also assume that ACK frames are 64 bytes long. a) The transmission uses Stop-and-Wait ARQ. Let the transmission rate of the system be R where R= ...

Using jython 50 or higherdevelop three new methods for the

Using Jython 5.0 or higher Develop three new methods for the Turtle class as follows: Add a method to the Turtle class to draw a rectangle given a certain width and height Add a method to the Turtle class to draw a simpl ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Management Information System Expert