Subset the data set to include only those individuals who lived in an urban area Cluster the individuals using a combination of numerical and categorical variables Determine the appropriate number of clusters and write a report to describe the differences between clusters ID Age Urban Mother Edu Father Edu Siblings Black Hispanic White Christian WomenPlace Male FamilySize Self Esteem Height Weight Outgoing Kid Outgoing Adult HealthPlan Income Marital Status Education WeeksEmployed NumberSpouses 1 21 1 8 8 1 0 0 1 1 0 0 5 65 2 20 1 5 8 8 0 0 1 1 1 0 5 16 62 120 0 1 1 0 1 12 0 1 3 18 1 10 12 3 0 0 1 1 0 0 5 20 1 1 1 0 1 12 52 1 4 17 1 11 12 3 0 0 1 1 0 0 5 67 110 0 1 5 20 1 12 12 1 0 0 1 1 0 1 4 23 63 130 6 19 1 12 12 1 0 0 1 1 0 1 4 27 64 200 1 1 1 40000 1 16 52 1 7 15 1 12 12 1 0 0 1 1 0 1 3 26 65 131 0 1 1 25000 3 12 52 2 8 21 1 9 6 7 0 0 1 0 0 0 3 23 65 179 1 1 1 27400 3 13 52 2 9 16 1 12 10 4 0 0 1 1 0 1 6 26 66 145 1 1 1 52000 1 14 52 1 10 19 1 12 12 3 0 0 1 1 0 0 3 19 66 115 0 1 11 20 1 12 12 1 0 0 1 1 0 1 3 71 155 1 1 1 55000 0 16 52 0 12 20 1 15 12 3 0 0 1 1 0 0 3 30 66 118 0 1 13 21 1 12 16 2 0 0 1 1 0 1 5 25 71 180 0 1 1 60000 2 16 52 1 14 16 1 12 12 2 0 0 1 1 0 0 5 21 67 135 1 1 1 48000 2 18 52 1 15 15 1 12 12 1 0 0 1 1 0 1 4 23 73 185 1 0 1 0 1 16 0 1 16 21 1 12 12 3 0 0 1 1 0 0 4 25 63 130 1 1 1 38000 1 13 52 1 17 22 1 12 15 2 0 0 1 0 0 1 2 24 69 160 1 1 0 48000 0 13 52 1 18 21 1 12 16 2 0 0 1 0 0 1 1 28 69 155 1 1 1 120000 3 13 52 2 19 22 1 10 12 3 0 0 1 1 0 0 2 28 64 120 1 1 20 20 1 12 18 2 0 0 1 1 0 0 5 21 64 120 0 1 1 52000 1 17 52 1 21 18 1 12 18 2 0 0 1 1 0 0 5 28 62 133 1 1 1 82000 1 16 52 1 22 16 1 12 12 1 0 0 1 1 0 0 4 17 64 110 0 1 1 36000 1 16 52 1 23 21 1 12 12 2 0 0 1 1 0 1 5 72 175 24 18 1 12 12 2 0 0 1 1 0 1 5 28 71 180 1 1 25 20 1 14 16 1 0 0 1 0 0 0 3 19 67 125 0 1 1 20000 1 14 52 1 26 17 1 16 17 2 0 0 1 1 0 1 4 25 67 136 1 1 27 19 1 14 20 1 0 0 1 1 0 0 4 23 63 123 1 1 1 13126 1 16 44 2 28 15 1 14 20 1 0 0 1 0 0 0 4 19 65 114 0 1 1 24000 3 13 52 3 29 19 1 0 4 1 0 0 1 0 1 0 4 30 67 146 0 1 1 50000 1 12 52 1 30 21 1 6

Question: Subset the data set to include only those individuals who lived in an urban area. Cluster the individuals using a combination of numerical and categorical

Subset the data set to include only those individuals who lived in an urban area. Cluster the individuals using a combination of numerical and categorical variables. Determine the appropriate number of clusters and write a report to describe the differences between clusters.

ID	Age	Urban	Mother_Edu	Father_Edu	Siblings	Black	Hispanic	White	Christian	WomenPlace	Male	FamilySize	Self_Esteem	Height	Weight	Outgoing_Kid	Outgoing_Adult	HealthPlan	Income	Marital_Status	Education	WeeksEmployed	NumberSpouses
1	21	1	8	8	1	0	0	1	1	0	0	5		65
2	20	1	5	8	8	0	0	1	1	1	0	5	16	62	120	0	1	1	0	1	12	0	1
3	18	1	10	12	3	0	0	1	1	0	0	5	20			1	1	1	0	1	12	52	1
4	17	1	11	12	3	0	0	1	1	0	0	5		67	110	0	1
5	20	1	12	12	1	0	0	1	1	0	1	4	23	63	130
6	19	1	12	12	1	0	0	1	1	0	1	4	27	64	200	1	1	1	40000	1	16	52	1
7	15	1	12	12	1	0	0	1	1	0	1	3	26	65	131	0	1	1	25000	3	12	52	2
8	21	1	9	6	7	0	0	1	0	0	0	3	23	65	179	1	1	1	27400	3	13	52	2
9	16	1	12	10	4	0	0	1	1	0	1	6	26	66	145	1	1	1	52000	1	14	52	1
10	19	1	12	12	3	0	0	1	1	0	0	3	19	66	115	0	1
11	20	1	12	12	1	0	0	1	1	0	1	3		71	155	1	1	1	55000	0	16	52	0
12	20	1	15	12	3	0	0	1	1	0	0	3	30	66	118	0	1
13	21	1	12	16	2	0	0	1	1	0	1	5	25	71	180	0	1	1	60000	2	16	52	1
14	16	1	12	12	2	0	0	1	1	0	0	5	21	67	135	1	1	1	48000	2	18	52	1
15	15	1	12	12	1	0	0	1	1	0	1	4	23	73	185	1	0	1	0	1	16	0	1
16	21	1	12	12	3	0	0	1	1	0	0	4	25	63	130	1	1	1	38000	1	13	52	1
17	22	1	12	15	2	0	0	1	0	0	1	2	24	69	160	1	1	0	48000	0	13	52	1
18	21	1	12	16	2	0	0	1	0	0	1	1	28	69	155	1	1	1	120000	3	13	52	2
19	22	1	10	12	3	0	0	1	1	0	0	2	28	64	120	1	1
20	20	1	12	18	2	0	0	1	1	0	0	5	21	64	120	0	1	1	52000	1	17	52	1
21	18	1	12	18	2	0	0	1	1	0	0	5	28	62	133	1	1	1	82000	1	16	52	1
22	16	1	12	12	1	0	0	1	1	0	0	4	17	64	110	0	1	1	36000	1	16	52	1
23	21	1	12	12	2	0	0	1	1	0	1	5		72	175
24	18	1	12	12	2	0	0	1	1	0	1	5	28	71	180	1	1
25	20	1	14	16	1	0	0	1	0	0	0	3	19	67	125	0	1	1	20000	1	14	52	1
26	17	1	16	17	2	0	0	1	1	0	1	4	25	67	136	1	1
27	19	1	14	20	1	0	0	1	1	0	0	4	23	63	123	1	1	1	13126	1	16	44	2
28	15	1	14	20	1	0	0	1	0	0	0	4	19	65	114	0	1	1	24000	3	13	52	3
29	19	1	0	4	1	0	0	1	0	1	0	4	30	67	146	0	1	1	50000	1	12	52	1
30	21	1		6

Step by Step Solution

★★★★★

3.38 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To subset the data set to include only individuals who lived in an urban area we filter the rows where the Urban column has a value of 1 Then we cluster the individuals using a combination of numerica... 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 those individuals who lived in an urban area. Develop a decision tree model to predict an individuals body mass index (BMI) or whether an individual is going to be...

Subset the data to include only those individuals who lived in an urban area. Predict whether or not an individuals marriage will end up in a divorce, a separation, or a remarriage using predictor...

Subset the data to select only those individuals who lived in an urban area. Reduce the dimensionality of the data by converting numerical variables such as age, height, weight, number of years of...

1 of20 The F -ratio is typically used to test differences between a sample and a population mean. two independent means. two dependent means. three or more means. Question 2 of20 To determine whether...

\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...

Location Income ($1,000) Urban 27 Rural 25 Suburban 25 Suburban 26 Rural 30 Urban 29 Rural 33 Urban 30 Suburban 32 Urban 34 Urban 35 Urban 40 Rural 30 Rural 33 Urban 42 Suburban 32 Urban 43 Urban 43...

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...

This chapter presents students and early career executives with a sound understanding of theory. Theory is explored in terms of both anatomy (parts of the whole) and physiology (relationships with...

Describe the role of proteins present at the divisome. Does the FtsZ ring form before or after chromosome replication?

Why must the terms of a contract be sufficiently definite before a court will enforce the contract?

Margin of error and the confidence interval. A study based on a sample of size 25 reported a mean of 93 with a margin of error of 11 for 95% confidence. (a) Give the 95% confidence interval. (b) If...

J. Unless companies can increase charitable giving to these local communities their efforts to promote their CSR activities will come across as insincere.

The Chartered Financial Analyst (CFA) designation is the de facto professional certification for the financial industry. Employers encourage their prospective employees to complete the CFA exam....

Unlike small selective colleges that pay close attention to personal statements, teacher recommendations, etc., large, public state university systems primarily rely on a students grade point average...

The accompanying data file contains 40 observations on the response variable y along with the predictor variables x and d. Consider two linear regression models where Model 1 uses the variables x and...

EXTRA PROBLEM On January 1 , ABC Company had $ 1 9 0 , 0 0 0 in Accounts Receivable and during the month had Credit sales of $ 3 7 0 , 0 0 0 and Cash sales of $ 2 0 0 , 0 0 0 . During January, ABC...

Prepare journal entries to record the June transactions in the General Journal below. General Journal Date Description(Account Name) Debit Credit 1-Jun Cash $10,000 Accounts Receivable $1,500...

The Marx Company issued $96,000 of 7% bonds on April 1, 2010 at face value. The bonds pay interest semiannually on January 1 and July 1. The bonds are dated January 1, 2010, and mature on January 1,...