Subset the data to include only one of the three colleges Find a combination of numerical and categorical variables to include in cluster analysis Determine the appropriate number of clusters and write a report to explain your decision and describe how each cluster is different from other clusters Applicant Edu Parent1 Edu Parent2 Gender White Asian HSGPA SAT ACT College Admitted Enrolled College GPA 1 4 4 M 0 1 4 08 1460 Business Economics Yes No 2 3 3 F 0 0 3 59 1180 Math Science No No 3 7 7 M 1 0 4 25 1340 Arts Letters Yes No 4 6 6 M 0 1 3 00 1190 Business Economics No No 5 6 7 F 1 0 3 90 1290 Business Economics No No 6 1 2 F 0 0 3 36 1090 Arts Letters No No 7 6 6 F 1 0 4 26 1430 Math Science Yes Yes 3 956 8 7 6 F 1 0 4 32 1240 Math Science Yes No 9 7 6 F 1 0 3 41 1230 Arts Letters No No 10 6 6 M 0 1 3 75 1510 Arts Letters Yes No 11 7 7 M 1 0 2 62 1330 Arts Letters No No 12 7 7 M 1 0 2 46 1170 Arts Letters No No 13 4 6 F 1 0 3 83 1210 Business Economics No No 14 6 6 M 0 0 3 88 1340 Business Economics Yes No 15 7 6 M 1 0 3 21 1190 Math Science No No 16 7 7 M 1 0 3 62 1460 Business Economics Yes No 17 7 7 M 0 0 3 72 1270 Arts Letters No No 18 7 7 M 1 0 4 12 1460 Math Science Yes No 19 6 6 F 0 0 3 11 930 Arts Letters No No 20 1 1 M 0 0 3 11 880 Math Science No No 21 7 6 M 1 0 4 25 1560 Business Economics Yes No 22 7 7 M 1 0 3 23 1510 Math Science No No 23 3 3 M 0 0 3 67 1430 Math Science Yes No 24 6 6 M 1 0 3 52 1450 Math Science Yes No 25 4 7 M 0 0 3 60 1040 Arts Letters No No 26 5 5 F 1 0 3 88 1220 Arts Letters No No 27 6 7 F 0 1 4 05 1360 Arts Letters Yes No 28 6 7 M 1 0 4 06 1220 Business Economics No No 29 7 6 M 1 0 3 95 1340 Math Science Yes Yes 3 361 30 7 6 F 0 1 3 96 1340 Math Science Yes No

Question: Subset the data to include only one of the three colleges. Find a combination of numerical and categorical variables to include in cluster analysis. Determine

Subset the data to include only one of the three colleges. Find a combination of numerical and categorical variables to include in cluster analysis. Determine the appropriate number of clusters and write a report to explain your decision and describe how each cluster is different from other clusters.

Applicant	Edu_Parent1	Edu_Parent2	Gender	White	Asian	HSGPA	SAT/ACT	College	Admitted	Enrolled	College_GPA
1	4	4	M	0	1	4.08	1460	Business & Economics	Yes	No
2	3	3	F	0	0	3.59	1180	Math & Science	No	No
3	7	7	M	1	0	4.25	1340	Arts & Letters	Yes	No
4	6	6	M	0	1	3.00	1190	Business & Economics	No	No
5	6	7	F	1	0	3.90	1290	Business & Economics	No	No
6	1	2	F	0	0	3.36	1090	Arts & Letters	No	No
7	6	6	F	1	0	4.26	1430	Math & Science	Yes	Yes	3.956
8	7	6	F	1	0	4.32	1240	Math & Science	Yes	No
9	7	6	F	1	0	3.41	1230	Arts & Letters	No	No
10	6	6	M	0	1	3.75	1510	Arts & Letters	Yes	No
11	7	7	M	1	0	2.62	1330	Arts & Letters	No	No
12	7	7	M	1	0	2.46	1170	Arts & Letters	No	No
13	4	6	F	1	0	3.83	1210	Business & Economics	No	No
14	6	6	M	0	0	3.88	1340	Business & Economics	Yes	No
15	7	6	M	1	0	3.21	1190	Math & Science	No	No
16	7	7	M	1	0	3.62	1460	Business & Economics	Yes	No
17	7	7	M	0	0	3.72	1270	Arts & Letters	No	No
18	7	7	M	1	0	4.12	1460	Math & Science	Yes	No
19	6	6	F	0	0	3.11	930	Arts & Letters	No	No
20	1	1	M	0	0	3.11	880	Math & Science	No	No
21	7	6	M	1	0	4.25	1560	Business & Economics	Yes	No
22	7	7	M	1	0	3.23	1510	Math & Science	No	No
23	3	3	M	0	0	3.67	1430	Math & Science	Yes	No
24	6	6	M	1	0	3.52	1450	Math & Science	Yes	No
25	4	7	M	0	0	3.60	1040	Arts & Letters	No	No
26	5	5	F	1	0	3.88	1220	Arts & Letters	No	No
27	6	7	F	0	1	4.05	1360	Arts & Letters	Yes	No
28	6	7	M	1	0	4.06	1220	Business & Economics	No	No
29	7	6	M	1	0	3.95	1340	Math & Science	Yes	Yes	3.361
30	7	6	F	0	1	3.96	1340	Math & Science	Yes	No

Step by Step Solution

★★★★★

3.40 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer Using both categorical and numerical data cluster analysis was done on candidates from the Business Economics college Based on the Elbow and Silhouette procedures the ideal number of clusters w... View full answer

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 Business Analytics Data Questions!

Subset the data to include only one of the three colleges. Group college applicants into clusters based on categorical variables of your choice (e.g., sex, parents education). Determine the...

Subset the data to include only one of the colleges. Predict whether an admitted applicant will eventually decide to enroll at the college using predictor variables such as gender, race, high school...

The net promoter score (NPS) is a key indicator of customer satisfaction and loyalty. Use data on employees in the software product group with a college degree to develop the logistic regression...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

BE01106 - BUSINESS STATISTICS ASSIGNMENT - PART III SEMESTER 2, 2016 _________________________________________________________________________ The complete BEO1106 assignment (all three parts)...

As a health care leader you will be responsible for not only the acquisition planning and management of HIT solutions but also for strategies to manage the different types of data acquired by these...

Exploratory Data Analysis Introduction This chapter will show you how to use visualisation and transformation to explore your data in a systematic way, a task that statisticians call exploratory data...

2.2 51 Summarizing Data for a Quantitative Variable Exercises Methods 11. Consider the following data. WEB 14 19 24 19 16 20 24 20 file Frequency a. b. SELF test 21 22 24 18 17 23 26 22 23 25 25 19...

What attributes should the company focus on while designing the communication plan? For the exclusive use of J. Barry, 2020. A00183 March 31, 2014 Revised 18 June 2019 Cerenity Sanitiser: Marketing...

Jesse condo is worth $450,000. She owes $250,000 on her 7%... Jesse condo is worth $450,000. She owes $250,000 on her 7% fixed-rate mortgage compounds semiannually that has three years remaining in...

Marcus Weber, IS project manager at ICAN Mutual Insurance Co., is reviewing the staffing arrangements for his next major project, the development of an expert system-based underwriters assistant....

When a note is dishonored, the payee will reduce Accounts Receivable and Allowance for Doubtful Accounts. the note holder transfers the customer's debt from the Notes Receivable account to the Bad...

C. Were you told of or did you discuss immediate impacts?

Consider a binary response variable y and a predictor variable x. The following table contains the parameter estimates of the linear probability model (LPM) and the logistic regression model, with...

Numerous attempts have been made to understand happiness. Because there is no unique way to quantify it, researchers often rely on surveys to capture a subjective assessment of well-being. One study...

The facility manager at a pharmaceutical company wants to build a regression model to forecast monthly electricity cost (Cost in $). Three main variables are thought to influence electricity cost:...

Toledo Limited is trying to determine the value of its ending inventory at February 28, 2012, the company's year-end. The accountant counted everything that was in the warehouse as of February 28,...

Does creative accounting represent the unacceptable face of accounting flexibility?

Fastball Delivery Company acquired an adjacent lot to construct a new warehouse, paying $35,000 and giving a short-term note for $301,000. Legal fees paid were $1,680, delinquent taxes assumed were...