{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["testo","dati","k=2","k=3","k=4"],"not_rendered":{"charts":9,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":6},"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":"testo","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"AVVERTENZA: quando si esegue la cluster analysis e si seleziona il dataset di input occorre selezionare anche la colonna delle etichette di riga e la prima riga (nomi delle variabili)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Criterio di Calinski Harabasz "]
[null,"Si sceglie il valore di k che massimizza il rapporto tra"]
[]
[]
[]
[null,"dove B e W sono rispettivamente la  DEVfra complessiva e la DEVnei complessiva"]

{"sheet":"dati","index":1,"n_rows":65,"n_cols":35,"rows_kept":65,"cut":false,"hidden":false,"merged":[[60,11,63,13]]}
["Data base originario",null,null,null,null,null,null,null,null,null,null,"n=",22]
["marca","tipo","prezzo","calcio","Z_prezzo","Z_calcio","k=2","k=3","k=4"]
["Fiuggi","O",0.85,15.9,{"$f":"(C3-C$25)/C$26","v":2.0495957903248376},{"$f":"(D3-D$25)/D$26","v":-0.67965195736382356},1,1,1,null,null,"Etichette di riga","Varianza di Z_prezzo","Varianza di Z_calcio",null,null,null,null,null,null,null,"Etichette di riga","Varianza di Z_prezzo","Varianza di Z_calcio",null,null,null,null,null,null,"Etichette di riga","Varianza di Z_prezzo","Varianza di Z_calcio"]
["Rocchetta","O",0.81,57,1.8455636302020035,-0.28570007469630482,1,1,1,null,null,1,0.66408361867003085,1.5248702674352426,null,null,null,null,null,null,null,1,2.0814561182193714E-2,7.7599042928641226E-2,null,null,null,null,null,null,1,2.0814561182193714E-2,7.7599042928641226E-2]
["Panna","O",0.42,30.2,-0.1437499309956338,-0.54258354076660897,2,3,3,null,null,2,0.33608082537394146,0.16237703433630415,null,null,null,null,null,null,null,2,0.54291313750225279,0.61883499893824323,null,null,null,null,null,null,2,0.25237655433411499,0.46491192414322269]
["S.Benedetto","O",0.44,46,-4.1733850934216429E-2,-0.39113731823262371,2,3,3,null,null,"Totale complessivo",1.0000000000000007,0.99999999999999944,null,null,null,null,null,null,null,3,0.35124571994954068,0.20922435109658,null,null,null,null,null,null,3,0.37226042114310287,3.5406945946453584E-2]
["Fabia","O",0.35,133.9,-0.50080621121059432,0.45140210966214278,2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,"Totale complessivo",1.0000000000000007,0.99999999999999944,null,null,null,null,null,null,4,9.9519620652369897E-2,1.1800493439213458]
["Fonteviva","O",0.3,7.48,-0.75584641136413744,-0.76035937468889669,2,3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totale complessivo",1.0000000000000007,0.99999999999999978]
["Conad Lieta","O",0.28999999999999998,39.5,-0.80685445139484613,-0.45344114395863033,2,3,3]
["S.Bernardo","O",0.5,10,0.26431438925003542,-0.73620466071512192,2,3,3,null,null,"Etichette di riga","Conteggio di marca","Media di Z_prezzo","Media di Z_calcio",null,null,null,null,null,null,"Etichette di riga","Conteggio di marca","Media di Z_prezzo","Media di Z_calcio",null,null,null,null,null,"Etichette di riga","Conteggio di marca","Media di Z_prezzo","Media di Z_calcio"]
["Guizza Caudana","O",0.19,8.36,-1.3169348517019324,-0.7519243952059913,2,3,3,null,null,1,7,1.0950167554644334,0.96585369922831177,null,null,null,null,null,null,1,2,1.9475797102634207,-0.48267601603006416,null,null,null,null,null,1,2,1.9475797102634207,-0.48267601603006416]
["Levissima","O",0.44,19.5,-4.1733850934216429E-2,-0.64514522311557376,2,3,3,null,null,2,15,-0.51100781921673588,-0.45073172630654551,null,null,null,null,null,null,2,4,0.8764108696185392,1.8041140182133248,null,null,null,null,null,2,3,1.182459109802791,1.5262229801354057]
["Vera","O",0.4,36,-0.2457660110570509,-0.48698935781109542,2,3,3,null,null,"Totale complessivo",22,-2.2141379638831248E-16,-1.5139404881252134E-17,null,null,null,null,null,null,3,16,-0.46255018118756269,-0.39069400254957326,null,null,null,null,null,3,13,-0.54789055585432522,-0.58841556215274593]
["Fontealta","O",0.5,4.8,0.26431438925003542,-0.78604772129592726,2,3,3,null,null,null,null,null,null,null,null,null,null,null,null,"Totale complessivo",22,-2.2456783907190669E-16,-7.0650556112509961E-17,null,null,null,null,null,4,4,-7.9989880957247947E-2,1.0090213499099019]
["Norda","O",0.2,7.9,-1.2659268116712237,-0.75633358902660097,2,3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totale complessivo",22,-2.1889056224143712E-16,-2.0185873175002847E-17]
["Conad Flaminia","O",0.35,72,-0.50080621121059432,-0.14192201532859722,2,3,3,null,null,null,"Prezzo","Calcio",null,null,null,null,null,null,null,null,"Prezzo","Calcio",null,null,null,null,null,null,null,"Prezzo","Calcio"]
["Pejo","O",0.25,18.100000000000001,-1.0108866115176807,-0.65856450865655991,2,3,3,null,null,"VARnei=",{"$f":"SUM(M4:M5*($M11:$M12-1))/(n-1)","v":0.4137920603454936},{"$f":"SUM(N4:N5*($M11:$M12-1))/(n-1)","v":0.54392857549141493},null,null,null,null,null,null,null,"VARnei=",{"$f":"SUM(W4:W6*($W11:$W13-1))/(n-1)","v":0.3294399891872411},{"$f":"SUM(X4:X6*($W11:$W13-1))/(n-1)","v":0.24154615743771765},null,null,null,null,null,null,"VARnei=",{"$f":"SUM(AF4:AF7*($AF11:$AF14-1))/(n-1)","v":0.25196436121546517},{"$f":"SUM(AG4:AG7*($AF11:$AF14-1))/(n-1)","v":0.23678353687316983}]
["Guizza","O",0.15,30.6,-1.5209670118247669,-0.53874945918347017,2,3,3,null,null,"Varfra=",{"$f":"SUM((N11:N12)^2*$M11:$M12)/(n-1)","v":0.58620793965450702},{"$f":"SUM((O11:O12)^2*$M11:$M12)/(n-1)","v":0.45607142450858468},null,null,null,null,null,null,null,"Varfra=",{"$f":"SUM((X11:X13)^2*$W11:$W13)/(n-1)","v":0.67056001081275951},{"$f":"SUM((Y11:Y13)^2*$W11:$W13)/(n-1)","v":0.75845384256228188},null,null,null,null,null,null,"Varfra=",{"$f":"SUM((AG11:AG14)^2*($AF11:$AF14))/(n-1)","v":0.74803563878453549},{"$f":"SUM((AH11:AH14)^2*($AF11:$AF14))/(n-1)","v":0.76321646312682978}]
["Aura","O",0.44,132.4,-4.1733850934216429E-2,0.43702430372537204,2,3,4,null,null,"Vartot",{"$f":"SUM(M17:M18)","v":1.0000000000000007},{"$f":"SUM(N17:N18)","v":0.99999999999999956},null,null,null,null,null,null,null,"Vartot",{"$f":"SUM(W17:W18)","v":1.0000000000000007},{"$f":"SUM(X17:X18)","v":0.99999999999999956},null,null,null,null,null,null,"Vartot",{"$f":"SUM(AF17:AF18)","v":1.0000000000000007},{"$f":"SUM(AG17:AG18)","v":0.99999999999999956}]
["S.Gemini","M",0.79,328.1,1.7435475501405862,2.3128487182760638,1,2,2]
["S.Pellegrino","M",0.6,208,0.77439478955712171,1.1616657229386183,1,2,2,null,null,null,"Prezzo","Calcio",null,null,null,null,null,null,null,null,"Prezzo","Calcio",null,null,null,null,null,null,null,"Prezzo","Calcio"]
["Gaudianello","M",0.5,140,0.26431438925003542,0.50987185380501043,1,3,4,null,null,"DEVnei",{"$f":"M17*(n-1)","v":8.6896332672553651},{"$f":"N17*(n-1)","v":11.422500085319713},{"$f":"SUM(M22:N22)","v":20.112133352575079},"DEVnei complessiva (W)",null,null,null,null,null,"DEVnei",{"$f":"W17*(n-1)","v":6.918239772932063},{"$f":"X17*(n-1)","v":5.0724693061920707},{"$f":"SUM(W22:X22)","v":11.990709079124134},"DEVnei complessiva (W)",null,null,null,null,"DEVnei",{"$f":"AF17*(n-1)","v":5.291251585524769},{"$f":"AG17*(n-1)","v":4.9724542743365667},{"$f":"SUM(AF22:AG22)","v":10.263705859861336},"Devnei complessiva (W)"]
["Ferrarelle","M",0.44,362,-4.1733850934216429E-2,2.6377871324470825,1,2,4,null,null,"DEVfra",{"$f":"M18*(n-1)","v":12.310366732744647},{"$f":"N18*(n-1)","v":9.5774999146802777},{"$f":"SUM(M23:N23)","v":21.887866647424925},"DEVfra complessiva (B)",null,null,null,null,null,"DEVfra",{"$f":"W18*(n-1)","v":14.081760227067949},{"$f":"X18*(n-1)","v":15.927530693807919},{"$f":"SUM(W23:X23)","v":30.00929092087587},"DEVfra complessiva (B)",null,null,null,null,"DEVfra",{"$f":"AF18*(n-1)","v":15.708748414475245},{"$f":"AG18*(n-1)","v":16.027545725663426},{"$f":"SUM(AF23:AG23)","v":31.736294140138671},"DEVfra complessiva (B)"]
["Uliveto","M",0.65,202,1.0294349897106652,1.1041544991915351,1,2,2,null,null,"DEVtot",{"$f":"SUM(M22:M23)","v":21.000000000000014},{"$f":"SUM(N22:N23)","v":20.999999999999993},{"$f":"SUM(O22:O23)","v":42},null,null,null,null,null,null,"DEVtot",{"$f":"SUM(W22:W23)","v":21.000000000000014},{"$f":"SUM(X22:X23)","v":20.999999999999989},{"$f":"SUM(Y22:Y23)","v":42},null,null,null,null,null,"DEVtot",{"$f":"SUM(AF22:AF23)","v":21.000000000000014},{"$f":"SUM(AG22:AG23)","v":20.999999999999993},{"$f":"SUM(AH22:AH23)","v":42.000000000000007}]
[null,"Media",{"$f":"AVERAGE(C3:C24)","v":0.44818181818181824},{"$f":"AVERAGE(D3:D24)","v":86.806363636363642},{"$f":"AVERAGE(E3:E24)","v":-2.4223047810003414E-16},{"$f":"AVERAGE(F3:F24)","v":0},null,null,null,null,null,"R2",{"$f":"M23/M24","v":0.58620793965450657},{"$f":"N23/N24","v":0.45607142450858479},{"$f":"AVERAGE(M25:N25)","v":0.52113968208154571},"R2 complessivo",null,null,null,null,null,"R2",{"$f":"W23/W24","v":0.67056001081275907},{"$f":"X23/X24","v":0.75845384256228221},{"$f":"AVERAGE(W25:X25)","v":0.71450692668752058},"R2 complessivo",null,null,null,null,"R2",{"$f":"AF23/AF24","v":0.74803563878453494},{"$f":"AG23/AG24","v":0.76321646312683011},{"$f":"AVERAGE(AF25:AG25)","v":0.75562605095568247},"R2 complessivo"]
[null,"sigma",{"$f":"STDEV(C3:C24)","v":0.19604752493880664},{"$f":"STDEV(D3:D24)","v":104.3274618252984},{"$f":"STDEV(E3:E24)","v":1.0000000000000004},{"$f":"STDEV(F3:F24)","v":0.99999999999999978}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k=2","k=3","k=4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R2",{"$f":"O25","v":0.52113968208154571},{"$f":"Y25","v":0.71450692668752058},{"$f":"AH25","v":0.75562605095568247}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"R2 = 1- W/T = B/T"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"R2=",{"$f":"1-O22/O24","v":0.52113968208154571}]
[null,null,null,"R2 si può ottenere anche attraverso la funzione REGR.LIN"]
[null,null,null,null,"k=2","v.dicotomica",null,"VAR DIPENDENTE PREZZO",null,null,null,"VAR DIPENDENTE CALCIO"]
[null,null,null,null,1,{"$f":"IF(E44=1,1,0)","v":1},null,{"$f":"LINEST(C3:C24,F44:F65,1,1)","v":0.31485714285714284},0.34800000000000009,null,null,{"$f":"LINEST(D3:D24,F44:F65,1,1)","v":147.78876190476191},39.782666666666671]
[null,null,null,null,1,{"$f":"IF(E45=1,1,0)","v":1},null,5.9151230141146538E-2,3.3365793718660282E-2,null,null,36.08950452323888,20.357226053586608]
[null,null,null,null,2,0,"R2",0.58620793965450668,0.12922516340536333,null,null,0.45607142450858484,78.843197480520672]
[null,null,null,null,2,0,null,28.333455173840495,20,null,null,16.76953354019118,20]
[null,null,null,null,2,0,null,0.47314441558441572,0.33398285714285708,null,null,104243.6093300433,124324.99577904762]
[null,null,null,null,2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La curva di R2 mostra un salto notevole passando da una soluzione con 2 gruppi ad una con 3 gruppi."]
[null,null,null,null,2,0]
[null,null,null,null,2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrambe le soluzioni con k=3 e k=4 sembrano accettabili"]
[null,null,null,null,2,0,null,null,null,null,null,null,"Implementazione criterio di Calinski Harabasz "]
[null,null,null,null,2,0,null,null,null,null,null,null,2,3,4]
[null,null,null,null,2,0,null,null,null,null,null,null,{"$f":"\"k=\"&M53","v":"k=2"},{"$f":"\"k=\"&N53","v":"k=3"},"k=4"]
[null,null,null,null,2,0,null,null,null,null,null,"W",{"$f":"O22","v":20.112133352575079},{"$f":"Y22","v":11.990709079124134},{"$f":"AH22","v":10.263705859861336}]
[null,null,null,null,2,0,null,null,null,null,null,"B",{"$f":"O23","v":21.887866647424925},{"$f":"Y23","v":30.00929092087587},{"$f":"AH23","v":31.736294140138671}]
[null,null,null,null,2,0,null,null,null,null,null,null,{"$f":"M56*(n-M53)/(M55*(M53-1))","v":21.765832856933091},{"$f":"N56*(n-N53)/(N55*(N53-1))","v":23.77576354051158},{"$f":"O56*(n-O53)/(O55*(O53-1))","v":18.552535257806444}]
[null,null,null,null,2,0]
[null,null,null,null,2,0,null,null,null,null,null,"L'indice di Calinski Harabasz  segnala che il numero ottimo di gruppi è pari a 3"]
[null,null,null,null,2,0]
[null,null,null,null,1,1,null,null,null,null,null,"Si noti che i valori dell'allocazione per k=3 e k=4 ottenuti dalla macro kmeans sono diversi da quelli ottenuti in MATLAB tramite la funzione kmens"]
[null,null,null,null,1,1]
[null,null,null,null,1,1]
[null,null,null,null,1,1]
[null,null,null,null,1,1]

{"sheet":"k=2","index":2,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Nome riga","Gruppo"]
["Fiuggi",1,{"$f":"B2&A2","v":"1Fiuggi"}]
["Rocchetta",1,{"$f":"B3&A3","v":"1Rocchetta"}]
["Panna",2,"2Panna"]
["S.Benedetto",2,"2S.Benedetto"]
["Fabia",2,"2Fabia"]
["Fonteviva",2,"2Fonteviva"]
["Conad Lieta",2,"2Conad Lieta"]
["S.Bernardo",2,"2S.Bernardo"]
["Guizza Caudana",2,"2Guizza Caudana"]
["Levissima",2,"2Levissima"]
["Vera",2,"2Vera"]
["Fontealta",2,"2Fontealta"]
["Norda",2,"2Norda"]
["Conad Flaminia",2,"2Conad Flaminia"]
["Pejo",2,"2Pejo"]
["Guizza",2,"2Guizza"]
["Aura",2,"2Aura"]
["S.Gemini",1,"1S.Gemini"]
["S.Pellegrino",1,"1S.Pellegrino"]
["Gaudianello",1,"1Gaudianello"]
["Ferrarelle",1,"1Ferrarelle"]
["Uliveto",1,"1Uliveto"]
[]
[null,"prezzo","calcio"]
["Centroide 1",1.0950167554644334,0.96585369922831177,null,"I centroidi calcolati sui dati standardizzati devono essere riportati nella scala originaria"]
["Centroide 2",-0.51100781921673588,-0.45073172630654551]
[]
[]
[]
["Centroide 1",{"$f":"B26*dati!C$26+dati!C$25","v":0.66285714285714292},{"$f":"C26*dati!D$26+dati!D$25","v":187.57142857142858},null,"Centroidi sulla scala originaria"]
["Centroide 2",{"$f":"B27*dati!C$26+dati!C$25","v":0.34800000000000003},{"$f":"C27*dati!D$26+dati!D$25","v":39.782666666666671}]

{"sheet":"k=3","index":3,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Nome riga","Gruppo"]
["Fiuggi",1,{"$f":"B2&A2","v":"1Fiuggi"}]
["Rocchetta",1,{"$f":"B3&A3","v":"1Rocchetta"}]
["Panna",3,"3Panna"]
["S.Benedetto",3,"3S.Benedetto"]
["Fabia",3,"3Fabia"]
["Fonteviva",3,"3Fonteviva"]
["Conad Lieta",3,"3Conad Lieta"]
["S.Bernardo",3,"3S.Bernardo"]
["Guizza Caudana",3,"3Guizza Caudana"]
["Levissima",3,"3Levissima"]
["Vera",3,"3Vera"]
["Fontealta",3,"3Fontealta"]
["Norda",3,"3Norda"]
["Conad Flaminia",3,"3Conad Flaminia"]
["Pejo",3,"3Pejo"]
["Guizza",3,"3Guizza"]
["Aura",3,"3Aura"]
["S.Gemini",2,"2S.Gemini"]
["S.Pellegrino",2,"2S.Pellegrino"]
["Gaudianello",3,"3Gaudianello"]
["Ferrarelle",2,"2Ferrarelle"]
["Uliveto",2,"2Uliveto"]
[]
[null,"prezzo","calcio"]
["C1",1.9475797102634207,-0.48267601603006416,null,"I centroidi calcolati sui dati standardizzati devono essere riportati nella scala originaria"]
["C2",0.8764108696185392,1.8041140182133248]
["C3",-0.46255018118756269,-0.39069400254957326]
[]
[]
["Centroide 1",{"$f":"B26*dati!C$26+dati!C$25","v":0.83000000000000007},{"$f":"C26*dati!D$26+dati!D$25","v":36.450000000000003},null,"Centroidi sulla scala originaria"]
["Centroide 2",{"$f":"B27*dati!C$26+dati!C$25","v":0.62},{"$f":"C27*dati!D$26+dati!D$25","v":275.02499999999998}]
["Centroide 3",{"$f":"B28*dati!C$26+dati!C$25","v":0.35750000000000004},{"$f":"C28*dati!D$26+dati!D$25","v":46.046250000000001}]

{"sheet":"k=4","index":4,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Nome riga","Gruppo"]
["Fiuggi",1]
["Rocchetta",1]
["Panna",3]
["S.Benedetto",3]
["Fabia",4]
["Fonteviva",3]
["Conad Lieta",3]
["S.Bernardo",3]
["Guizza Caudana",3]
["Levissima",3]
["Vera",3]
["Fontealta",3]
["Norda",3]
["Conad Flaminia",3]
["Pejo",3]
["Guizza",3]
["Aura",4]
["S.Gemini",2]
["S.Pellegrino",2]
["Gaudianello",4]
["Ferrarelle",4]
["Uliveto",2]
[]
[null,"prezzo","calcio"]
["Centroid 1",1.9475797102634207,-0.48267601603006416,null,"I centroidi calcolati sui dati standardizzati devono essere riportati nella scala originaria"]
["Centroid 2",1.182459109802791,1.5262229801354057]
["Centroid 3",-0.54789055585432522,-0.58841556215274593]
["Centroid 4",-7.9989880957247947E-2,1.0090213499099019]
[]
["Centroide 1",{"$f":"B26*dati!C$26+dati!C$25","v":0.83000000000000007},{"$f":"C26*dati!D$26+dati!D$25","v":36.450000000000003},null,"Centroidi sulla scala originaria"]
["Centroide 2",{"$f":"B27*dati!C$26+dati!C$25","v":0.68},{"$f":"C27*dati!D$26+dati!D$25","v":246.03333333333333}]
["Centroide 3",{"$f":"B28*dati!C$26+dati!C$25","v":0.34076923076923077},{"$f":"C28*dati!D$26+dati!D$25","v":25.418461538461543}]
["Centroide 4",{"$f":"B29*dati!C$26+dati!C$25","v":0.4325},{"$f":"C29*dati!D$26+dati!D$25","v":192.07499999999999}]