{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Taul1","Taul2","Taul3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Taul1","index":0,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,3,5,5],[5,12,5,13],[5,0,5,2]]}
["K-means-demo spreadsheet",null,null,null,null,"Vesa Ollikainen",null,null,null,null,null,null,null,null,"In the example there are 3 variables, 20 observations and 2 clusters."]
["Scaling information",null,null,null,null,null,null,null,null,null,null,null,null,null,"You can modify the contents of the green cells."]
[{"$f":"AVERAGE(A$7:A$44)","v":41.842105263157897},{"$f":"AVERAGE(B7:B44)","v":3362.1052631578946},6.2631578947368425,"Mean",null,null,null,null,null,null,null,null,null,null,"Press green arrow for the next iteration."]
[{"$f":"_xlfn.STDEV.S(A$7:A$44)","v":16.650869706664096},{"$f":"_xlfn.STDEV.S(B$7:B$44)","v":1312.9084716653938},2.2813764184310097,"Standard deviation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original cluster centerpoints"]
["Data",null,null,"Standardized values",null,null,null,null,null,null,null,null,"Distances",null,null,null,null,null,null,null,null,null,null,"OLD","Age","Income","Health"]
["Age","Income","Health","Age","Income","Health",null,null,null,null,null,null,"C1","C2","Cluster",null,null,null,null,null,null,null,null,"C1",33.75,2665,7.5833333333333339]
[50,2710,7,{"$f":"(A8-A$3)/A$4","v":0.48993805612310498},{"$f":"(B8-B$3)/B$4","v":-0.49668752790566906},0.32298138058686177,{"$f":"D8-Y$20","v":0.97592499889037887},{"$f":"E8-Z$20","v":3.4275047325209584E-2},{"$f":"F8-AA$20","v":-0.25569359296459926},{"$f":"D8-Y$21","v":-0.3431824171922207},{"$f":"E8-Z$21","v":-1.4069090854443185},{"$f":"F8-AA$21","v":1.3149956209607949},{"$f":"SQRT(G8*G8+H8*H8+I8*I8)","v":1.0094471733634591},{"$f":"SQRT(J8*J8+K8*K8+L8*L8)","v":1.9561137056218718},{"$f":"IF(M8<N8,\"C1\",\"C2\")","v":"C1"},{"$f":"IF($O8=\"C1\",D8,\"\")","v":0.48993805612310498},{"$f":"IF($O8=\"C1\",E8,\"\")","v":-0.49668752790566906},{"$f":"IF($O8=\"C1\",F8,\"\")","v":0.32298138058686177},{"$f":"IF($O8=\"C2\",D8,\"\")","v":""},{"$f":"IF($O8=\"C2\",E8,\"\")","v":""},"",null,null,"C2",55.714285714285708,4557.1428571428569,4]
[47,4230,6,{"$f":"(A9-A$3)/A$4","v":0.30976728709718893},0.66104740396807793,-0.11535049306673656,0.79575422986446276,1.1920099791989567,-0.69402546661819753,-0.52335318621813676,-0.24917415357057138,0.87666374730719676,{"$f":"SQRT(G9*G9+H9*H9+I9*I9)","v":1.5924144979155672},{"$f":"SQRT(J9*J9+K9*K9+L9*L9)","v":1.0509641488533199},{"$f":"IF(M9<N9,\"C1\",\"C2\")","v":"C2"},{"$f":"IF($O9=\"C1\",D9,\"\")","v":""},{"$f":"IF($O9=\"C1\",E9,\"\")","v":""},{"$f":"IF($O9=\"C1\",F9,\"\")","v":""},{"$f":"IF($O9=\"C2\",D9,\"\")","v":0.30976728709718893},{"$f":"IF($O9=\"C2\",E9,\"\")","v":0.66104740396807793},{"$f":"IF($O9=\"C2\",F9,\"\")","v":-0.11535049306673656}]
[62,5160,4,1.2106211322267693,1.36939838202241,-0.99201424037393326,1.6966080749940431,1.9003609572532887,-1.5706892139253943,0.37750065891144358,0.45917682448376074,0,2.9928106078950605,0.59443258963617107,"C2","","","",1.2106211322267693,1.36939838202241,-0.99201424037393326]
[40,2640,7,-0.11063117396328197,-0.55000426818932846,0.32298138058686177,0.37535576880399185,-1.9041692958449818E-2,-0.25569359296459926,-0.94375164727860761,-1.4602258257279779,1.3149956209607949,0.45456985461896371,2.1799403929947503,"C1",-0.11063117396328197,-0.55000426818932846,0.32298138058686177,"","",""]
[24,1830,9,-1.0715419421015011,-1.1669551200431014,1.1996451278940583,-0.58555499933422728,-0.63599254481222278,0.62097015434259728,-1.9046624154168268,-2.0771766775817508,2.1916593682679917,1.0644083365355155,3.5701222182311736,"C1",-1.0715419421015011,-1.1669551200431014,1.1996451278940583,"","","",null,null,"NEW","Age","Income","Health"]
[36,2540,8,-0.35085886599783672,-0.62617104002312762,0.76131325424046004,0.13512807676943711,-9.5208464792248981E-2,0.18263828068899901,-1.1839793393131623,-1.5363925975617769,1.7533274946143933,0.24633511822827331,2.6146637629213134,"C1",-0.35085886599783672,-0.62617104002312762,0.76131325424046004,"","","",null,null,"C1",{"$f":"Y25*A$4+A$3","v":33.75},{"$f":"Z25*B$4+B$3","v":2665},7.5833333333333339]
[70,3120,5,1.691076516295879,-0.18440376338709255,-0.55368236672033488,2.1770634590631528,0.34655881184378612,-1.1323573402717959,0.85795604298055328,-1.0946253209257419,0.43833187365359838,2.4782940626410768,1.4582276901634075,"C2","","","",1.691076516295879,-0.18440376338709255,-0.55368236672033488,null,null,"C2",{"$f":"Y26*A$4+A$3","v":55.714285714285708},{"$f":"Z26*B$4+B$3","v":4557.1428571428569},4]
[18,630,8,-1.4318834801533333,-2.0809563820486914,0.76131325424046004,-0.9458965373860595,-1.5499938068178127,0.18263828068899901,-2.2650039534686588,-2.9911779395873408,1.7533274946143933,1.8249815895470141,4.1414424635473823,"C1",-1.4318834801533333,-2.0809563820486914,0.76131325424046004,"","",""]
[35,3800,8,-0.41091578900647546,0.33353028508274163,0.76131325424046004,7.507115376079837E-2,0.86449286031362027,0.18263828068899901,-1.2440362623218011,-0.57669127245590768,1.7533274946143933,0.88675832402816246,2.225838347470273,"C1",-0.41091578900647546,0.33353028508274163,0.76131325424046004,"","","",null,null,null,"Status",{"$f":"IF(AND(Y7=Y13,Y8=Y14,Z7=Z13,Z8=Z14,AA7=AA13,AA8=AA14),\"FINISHED!\",\"Go on. Iterate!\")","v":"FINISHED!"}]
[24,1950,10,-1.0715419421015011,-1.0755549938425426,1.6379770015476567,-0.58555499933422728,-0.54459241861166396,1.0593020279961958,-1.9046624154168268,-1.9857765513811918,2.6299912419215898,1.3272438909904472,3.8062975923200102,"C1",-1.0715419421015011,-1.0755549938425426,1.6379770015476567,"","",""]
[24,2480,7,-1.0715419421015011,-0.67187110312340703,0.32298138058686177,-0.58555499933422728,-0.14090852789252839,-0.25569359296459926,-1.9046624154168268,-1.5820926606620564,1.3149956209607949,0.65430045389048341,2.8035637297497398,"C1",-1.0715419421015011,-0.67187110312340703,0.32298138058686177,"","","",null,null,"Scaled cluster centerpoints"]
[27,3120,6,-0.891371173075585,-0.18440376338709255,-0.11535049306673656,-0.40538423030831117,0.34655881184378612,-0.69402546661819753,-1.7244916463909106,-1.0946253209257419,0.87666374730719676,0.87527751745594695,2.2227495039987106,"C1",-0.891371173075585,-0.18440376338709255,-0.11535049306673656,"","","",null,null,"OLD","Age","Income","Health"]
[63,2990,9,1.270678055235408,-0.28342056677103145,1.1996451278940583,1.7566649980026818,0.2475420084598472,0.62097015434259728,0.43755758192008232,-1.1936421243096809,2.1916593682679917,1.8795618887773731,2.5336947221279695,"C1",1.270678055235408,-0.28342056677103145,1.1996451278940583,"","","",null,null,"C1",{"$f":"(Y7-A$3)/A$4","v":-0.48598694276727383},{"$f":"(Z7-B$3)/B$4","v":-0.53096257523087864},0.57867497355146102]
[29,4000,7,-0.77125732705830763,0.48586382875033995,0.32298138058686177,-0.2852703842910338,1.0168264039812187,-0.25569359296459926,-1.6043778003736333,-0.42435772878830935,1.3149956209607949,1.0865975986859517,2.1173854376235277,"C1",-0.77125732705830763,0.48586382875033995,0.32298138058686177,"","","",null,null,"C2",{"$f":"(Y8-A$3)/A$4","v":0.83312047331532568},{"$f":"(Z8-B$3)/B$4","v":0.91022155753864931},-0.99201424037393326]
[35,3290,5,-0.41091578900647546,-5.4920251269633992E-2,-0.55368236672033488,7.507115376079837E-2,0.47604232396124463,-1.1323573402717959,-1.2440362623218011,-0.96514180880828326,0.43833187365359838,1.2306441883813597,1.6343989000675436,"C1",-0.41091578900647546,-5.4920251269633992E-2,-0.55368236672033488,"","",""]
[55,4740,5,0.79022267116629841,1.0494979403204536,-0.55368236672033488,1.2762096139335721,1.5804605155513323,-1.1323573402717959,-4.2897802149027275E-2,0.13927638278180432,0.43833187365359838,2.3256826021580581,0.46192311447975293,"C2","","","",0.79022267116629841,1.0494979403204536,-0.55368236672033488]
[62,6000,3,1.2106211322267693,{"$f":"(B24-B$3)/B$4","v":2.0091992654263229},{"$f":"(C24-C$3)/C$4","v":-1.4303461140275315},1.6966080749940431,2.5401618406572015,-2.0090210875789927,0.37750065891144358,1.0989777078876735,-0.43833187365359827,3.6560999531198615,1.2419313915725347,"C2","","","",1.2106211322267693,2.0091992654263229,-1.4303461140275315,null,null,"NEW","Age","Income","Health"]
[30,3530,1,-0.71120040404966889,0.12788000113148396,-2.3070098613347283,-0.22521346128239506,0.65884257636236265,-2.8856848348861894,-1.5443208773649946,-0.78234155640716541,-1.3149956209607949,2.9684965234715581,2.1739822368853519,"C2","","","",-0.71120040404966889,0.12788000113148396,-2.3070098613347283,null,null,"C1",{"$f":"AVERAGE(P:P)","v":-0.48598694276727389},{"$f":"AVERAGE(Q:Q)","v":-0.53096257523087875},{"$f":"AVERAGE(R:R)","v":0.5786749735514608}]
[64,5120,4,1.3307349782440467,1.3389316732888903,-0.99201424037393326,1.8167219210113206,1.8698942485197689,-1.5706892139253943,0.49761450492872106,0.42871011575024098,0,3.0436898077287617,0.65682003536892908,"C2","","","",1.3307349782440467,1.3389316732888903,-0.99201424037393326,null,null,"C2",{"$f":"AVERAGE(S:S)","v":0.8331204733153259},{"$f":"AVERAGE(T:T)","v":0.91022155753864931},{"$f":"AVERAGE(U:U)","v":-0.99201424037393326}]

{"sheet":"Taul2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Taul3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}