Scribd
Upload
42 views3 pages

DemoKTC

This document contains demographic information about 61 individuals including their age, gender, income, marital status, existing loans, mortgages, and number of children. It calculates the average and standard deviation for age and income. It then standardizes each data point for income and age and calculates the Euclidean distance between each standardized data point.

Uploaded by

Parv Pandya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
42 views3 pages

DemoKTC

This document contains demographic information about 61 individuals including their age, gender, income, marital status, existing loans, mortgages, and number of children. It calculates the average and standard deviation for age and income. It then standardizes each data point for income and age and calculates the Euclidean distance between each standardized data point.

Uploaded by

Parv Pandya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Age Female Income Married Loan Mortgage Children

48 1 17546.00 0 0 0 1
40 0 30085.10 1 1 1 3
51 1 16575.40 1 1 0 0
23 1 20375.40 1 0 0 3
57 1 50576.30 1 0 0 0
57 1 37869.60 1 0 0 2
22 0 8877.07 0 0 0 0
58 0 24946.60 1 1 0 0
37 1 25304.30 1 1 0 2
54 0 24212.10 1 1 0 2
66 1 59803.90 1 0 0 0
52 1 26658.80 0 1 1 0
44 1 15735.80 1 0 1 1
66 1 55204.70 1 1 1 1
36 0 19474.60 1 0 1 0
38 1 22342.10 1 1 1 0
37 1 17729.80 1 0 1 2
46 1 41016.00 1 0 1 0
62 1 26909.20 1 0 0 0
31 0 22522.80 1 1 0 0
61 0 57880.70 1 0 0 2
50 0 16497.30 1 0 0 2
54 0 38446.60 1 0 0 0
27 1 15538.80 0 1 1 0
22 0 12640.30 0 1 0 2
56 0 41034.00 1 1 1 0
45 0 20809.70 1 0 1 0
39 1 20114.00 1 0 0 1
39 1 29359.10 0 1 1 3
61 0 24270.10 1 0 0 1
45.966667 Average 28011.87
13.042327 std dev 13703.27722
Std Income Age u-v manhattan
-0.7637496 0.15590265 -0.919652 0.919652 1.5284313467
0.1512943 -0.4574848 0.608779 0.608779
-0.8345794 0.38592295 -1.220502 1.220502
-0.5572734 -1.7609332 1.20366 1.20366
1.64664462 0.84596354 0.800681 0.800681
0.71937008 0.84596354 -0.126593 0.126593
-1.3963669 -1.8376066 0.44124 0.44124
-0.223689 0.92263698 -1.146326 1.146326
-0.1975858 -0.6875051 0.489919 0.489919
-0.2772893 0.61594324 -0.893233 0.893233
2.32003098 1.53602444 0.784007 0.784007
-0.0987408 0.46259638 -0.561337 0.561337
-0.8958494 -0.1507911 -0.745058 0.745058
1.98440324 1.53602444 0.448379 0.448379
-0.6230095 -0.7641785 0.141169 0.141169
-0.413753 -0.6108317 0.197079 0.197079
-0.7503367 -0.6875051 -0.062832 0.062832
0.94897939 0.00255578 0.946424 0.946424
-0.0804678 1.22933071 -1.309798 1.309798
-0.4005664 -1.1475457 0.746979 0.746979
2.17968499 1.15265728 1.027028 1.027028
-0.8402787 0.30924951 -1.149528 1.149528
0.7614768 0.61594324 0.145534 0.145534
-0.9102255 -1.4542394 0.544014 0.544014
-1.1217442 -1.8376066 0.715862 0.715862
0.95029295 0.76929011 0.181003 0.181003
-0.5255803 -0.0741177 -0.451463 0.451463
-0.5763492 -0.5341582 -0.042191 0.042191
0.09831427 -0.5341582 0.632473 0.632473
-0.2730567 1.15265728 -1.425714 1.425714
20.10846
-0.915 0.837225

Eucledian 1.212225

You might also like