A common approach to clustering is called multidimensional scaling (MDS). To apply MDS, we rank each pair of objects we want to cluster from least similar (higher number) to most similar (lower number). For example, in the file P08_37.xlsx, we compared the similarity of 10 banks and found banks 5 and 10 to be most similar and banks 9 and 10 to be least similar. We now assign a location in the x - y plane to each bank. The goal is to ensure that when we rank the distances between pair of banks, the ordering of these distances matches (as closely as possible) the similarity rankings of the banks. a. Constrain each bank to have an x and y coordinate between −1 and +1 and determine the “location” of each bank. ( Hint : Use Excel’s RANK function to rank the distances from smallest to largest.) b. How does this method lead to a natural clustering of banks? c. How could you determine whether you need more than two dimensions to adequately locate the banks?

BuyFind

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659
BuyFind

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

Solutions

Chapter
Section
Chapter 8, Problem 37P
Textbook Problem

A common approach to clustering is called multidimensional scaling (MDS). To apply MDS, we rank each pair of objects we want to cluster from least similar (higher number) to most similar (lower number). For example, in the file P08_37.xlsx, we compared the similarity of 10 banks and found banks 5 and 10 to be most similar and banks 9 and 10 to be least similar. We now assign a location in the x-y plane to each bank. The goal is to ensure that when we rank the distances between pair of banks, the ordering of these distances matches (as closely as possible) the similarity rankings of the banks.

a. Constrain each bank to have an x and y coordinate between −1 and +1 and determine the “location” of each bank. (Hint: Use Excel’s RANK function to rank the distances from smallest to largest.)

b. How does this method lead to a natural clustering of banks?

c. How could you determine whether you need more than two dimensions to adequately locate the banks?

Expert Solution

Want to see the full answer?

Check out a sample textbook solution.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Chapter 8 Solutions

Practical Management Science
Ch. 8.6 - The adoption level of a new product can often be...Ch. 8.6 - Sales of a product over time often follow an...Ch. 8.7 - Visit biz.yahoo.com/r/. Under Research Tools,...Ch. 8.7 - Continuing the previous problem, determine the...Ch. 8.8 - An important problem in operations management is...Ch. 8.8 - The traveling salesperson problem is notoriously...Ch. 8.8 - An important problem in operations management is...Ch. 8.8 - You are operating a Web site to match up sellers...Ch. 8.8 - The 30 teams in the NBA are each assigned to one...Ch. 8 - Fourteen jobs must be assigned to one of three...Ch. 8 - Nine jobs need to be completed within eight weeks....Ch. 8 - Eight students need to be assigned to four dorm...Ch. 8 - The costs of producing product A, product B, or...Ch. 8 - Cook County needs to build two hospitals. There...Ch. 8 - The file P08_25.xlsx contains quarterly revenue...Ch. 8 - Music radio WABC has commercials of the following...Ch. 8 - A Wall Street firm is trying to package nine...Ch. 8 - During the next 12 months, the amounts of electric...Ch. 8 - Bus 99 serves towns 1 through 10. We assume that...Ch. 8 - Ten data sets must be assigned for storage to one...Ch. 8 - Xerox is trying to determine how many maintenance...Ch. 8 - You are the Democratic campaign manager for the...Ch. 8 - A steel manufacturer needs to cool 17 pieces of...Ch. 8 - Suppose you are the ad manager for Fox NFL...Ch. 8 - Assume that a consumers purchase decision on an...Ch. 8 - An important problem in manufacturing is the...Ch. 8 - A common approach to clustering is called...Ch. 8 - Based on Meneses et al. (2004). A string is a list...Ch. 8 - A company has nine jobs that must be assigned to...Ch. 8 - ASSIGNING MBA STUDENTS TO TEAMS The MBA program at...Ch. 8 - PROJECT SELECTION AT EWING NATURAL GAS This is an...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Explain vendor exploitation.

Accounting Information Systems

If you were the CFO of a company that had to decide on hundreds of potential projects every year, would you wan...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

Why is it necessary to journalize and post adjusting entries?

College Accounting (Book Only): A Career Approach

Why do economists make assumptions?

Principles of Microeconomics (MindTap Course List)