Question: F3 F1 36.8 35.3 Name A B D E F G F2 13.8 13.2 13.2 13.7 14.4 13.9 16.1 15.1 15.8 12.9 16.1 13.6 12.9

F3 F1 36.8 35.3 Name A B D E F G F2 13.8 13.2

F3 F1 36.8 35.3 Name A B D E F G F2 13.8 13.2

F3 F1 36.8 35.3 Name A B D E F G F2 13.8 13.2 13.2 13.7 14.4 13.9 16.1 15.1 15.8 12.9 16.1 13.6 12.9 12.7 $72,245 $70,639 $64,879 $75,591 $80,615 $76,507 $107,935 $82,557 $88,041 $64,597 34.8 39.3 36.6 35.7 40.5 43.1 37.7 40.4 33.8 36.2 39.1 39.4 36.1 35.3 36.6 34.4 38.1 37.9 1 J K L M N O P Q R S T ZZ Balance $35,206 $33,434 $28,162 $36,708 $38,766 $34,811 $41,032 $41,742 $51,107 $34,936 $32,150 $37,996 $26,785 $32,576 $56,569 $26,144 $24,558 $34,811 $26,773 $24,890 $40,550 $76,771 $53,713 $60,262 12.8 12.7 13.9 12.8 12.7 13.5 $48,600 $51,419 $76,507 $60,753 $47,388 $67,500 You are working in a bank. The datafile provided contains independent variables (F1, F2, F3) and 1 dependent variable (Balance) of a list of VIP customers at your bank. Mr. ZZ has been identified as a very profitable and ideal customer for the bank. Your manager would like you to identify a special group/cluster (called VIP cluster) of 7 other VIP customers who are very similar to Mr. ZZ in order to target a very special promotion. Perform the following tasks : (ii) Calculate the centroid for the VIP cluster and explain the centroid concept and VIP cluster centroid values, to a business manager who has not been trained in analytics. Copy-paste (or snip) your relevant work from EXCEL to show how you do this

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Hari has income of $6,000. Wine costs $6 per glass, and cheese costs $12 per pound. Draw Haris budget constraint with wine on the vertical axis. What is the slope of this budget constraint?

Q:

TYPO*** the question is for the past 3 years*** F3 F1 36.8 35.3 Name A B D E F G F2 13.8 13.2 13.2 13.7 14.4 13.9 16.1 15.1 15.8 12.9 16.1 13.6 12.9 12.7 $72,245 $70,639 $64,879 $75,591 $80,615...

Q:

Download ICE Europe Brent Crude Electronic Energy Futures prices for the period over the last two years into Excel format. Using these data, answer the following questions: Suppose that an exchange...

Q:

Download ICE Europe Brent Crude Electronic Energy Futures prices for the period over the last two years into Excel format. Using these data, answer the following questions Suppose that an exchange...

Q:

Multiple Regression / Model Building NBA Advanced Statistics Predicting Playoff Wins in a Season. What we are trying to do is predict NBA playoff victories in a season for any given team (dependent...

Q:

march April Calculate timeliness costs for each year. Any planting after April 1 incurs a timeliness cost as the hot, dry conditions of summer will limit how many bolls are set on the plant and...

Q:

In this part, you are required to use Excel software and a sample of 838 real mutual funds to answer the following questions. Please provide your answer in Excel worksheet. Construct a summary table...

Q:

Recently Santa Fe, New Mexico, was named one of the safest places to live in the United States. Since then housing development projects have been springing up all around Santa Fe. Six housing...

Q:

This is a simple R script that i can use some help with please. Use boxplot( ) and qqnorm( ) to determine if sales can be considered normally distributed. Discuss your findings. Determine if any of...

Q:

PLEASE HELP Task #1. Examine performance measures (i.e., putting, driving yard, driving accuracy, greens in regulation, sand save percentage) and identify important predictors of Earnings per Round...

Q:

What are the excel formulas for Excel question #2-4 (Bordered in RED)? A B D E F G 1 J K L M N 0 Q R S T U V W 1 Male Female Total 2 Email ID Time of Day Offer S1 S2 S3 Delivered Opened Open Rate...

Q:

An article in Money looks at the relationship between peoples investments in large-cap stocks and international stocks. Suppose that the following data are available for a random sample of families,...

Q:

Correctly label the components of the respiratory system. Pharynx Nasal cavity Hard palate Nostril Larynx Epiglottis Posterior nasal aperture re to search PA) pll 14 O B F6 $5 36

Q:

4. What is entered in the Posting Reference column of the general journal? a. the ledger account number b. the date of the transaction c. the amount of the transaction d. a description of the...

Q:

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...