{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Testo","It0","It1","It2","It3","It4","It5","It6"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":32,"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":"Testo","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"It0","index":1,"n_rows":101,"n_cols":9,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Intercetta","Debito","Insolvenza"]
[null,null,null,"beta0",0,1,1,20,0]
[null,null,null,"beta1",0,2,1,23,0]
[null,null,null,null,null,3,1,24,0]
[null,null,null,null,null,4,1,25,0]
[null,null,null,"Iterations",6,5,1,25,1]
[null,null,null,null,null,6,1,26,0]
[null,null,null,null,null,7,1,26,0]
[null,null,null,null,null,8,1,28,0]
[null,null,null,null,null,9,1,28,0]
[null,null,null,null,null,10,1,29,0]
[null,null,null,null,null,11,1,30,0]
[null,null,null,null,null,12,1,30,0]
[null,null,null,null,null,13,1,30,0]
[null,null,null,null,null,14,1,30,0]
[null,null,null,null,null,15,1,30,0]
[null,null,null,null,null,16,1,30,1]
[null,null,null,null,null,17,1,32,0]
[null,null,null,null,null,18,1,32,0]
[null,null,null,null,null,19,1,33,0]
[null,null,null,null,null,20,1,33,0]
[null,null,null,null,null,21,1,34,0]
[null,null,null,null,null,22,1,34,0]
[null,null,null,null,null,23,1,34,1]
[null,null,null,null,null,24,1,34,0]
[null,null,null,null,null,25,1,34,0]
[null,null,null,null,null,26,1,35,0]
[null,null,null,null,null,27,1,35,0]
[null,null,null,null,null,28,1,36,0]
[null,null,null,null,null,29,1,36,1]
[null,null,null,null,null,30,1,36,0]
[null,null,null,null,null,31,1,37,0]
[null,null,null,null,null,32,1,37,1]
[null,null,null,null,null,33,1,37,0]
[null,null,null,null,null,34,1,38,0]
[null,null,null,null,null,35,1,38,0]
[null,null,null,null,null,36,1,39,0]
[null,null,null,null,null,37,1,39,1]
[null,null,null,null,null,38,1,40,0]
[null,null,null,null,null,39,1,40,1]
[null,null,null,null,null,40,1,41,0]
[null,null,null,null,null,41,1,41,0]
[null,null,null,null,null,42,1,42,0]
[null,null,null,null,null,43,1,42,0]
[null,null,null,null,null,44,1,42,0]
[null,null,null,null,null,45,1,42,1]
[null,null,null,null,null,46,1,43,0]
[null,null,null,null,null,47,1,43,0]
[null,null,null,null,null,48,1,43,1]
[null,null,null,null,null,49,1,44,0]
[null,null,null,null,null,50,1,44,0]
[null,null,null,null,null,51,1,44,1]
[null,null,null,null,null,52,1,44,1]
[null,null,null,null,null,53,1,45,0]
[null,null,null,null,null,54,1,45,1]
[null,null,null,null,null,55,1,46,0]
[null,null,null,null,null,56,1,46,1]
[null,null,null,null,null,57,1,47,0]
[null,null,null,null,null,58,1,47,0]
[null,null,null,null,null,59,1,47,1]
[null,null,null,null,null,60,1,48,0]
[null,null,null,null,null,61,1,48,1]
[null,null,null,null,null,62,1,48,1]
[null,null,null,null,null,63,1,49,0]
[null,null,null,null,null,64,1,49,0]
[null,null,null,null,null,65,1,49,1]
[null,null,null,null,null,66,1,50,0]
[null,null,null,null,null,67,1,50,1]
[null,null,null,null,null,68,1,51,0]
[null,null,null,null,null,69,1,52,0]
[null,null,null,null,null,70,1,52,1]
[null,null,null,null,null,71,1,53,1]
[null,null,null,null,null,72,1,53,1]
[null,null,null,null,null,73,1,54,1]
[null,null,null,null,null,74,1,55,0]
[null,null,null,null,null,75,1,55,1]
[null,null,null,null,null,76,1,55,1]
[null,null,null,null,null,77,1,56,1]
[null,null,null,null,null,78,1,56,1]
[null,null,null,null,null,79,1,56,1]
[null,null,null,null,null,80,1,57,0]
[null,null,null,null,null,81,1,57,0]
[null,null,null,null,null,82,1,57,1]
[null,null,null,null,null,83,1,57,1]
[null,null,null,null,null,84,1,57,1]
[null,null,null,null,null,85,1,57,1]
[null,null,null,null,null,86,1,58,0]
[null,null,null,null,null,87,1,58,1]
[null,null,null,null,null,88,1,58,1]
[null,null,null,null,null,89,1,59,1]
[null,null,null,null,null,90,1,59,1]
[null,null,null,null,null,91,1,60,0]
[null,null,null,null,null,92,1,60,1]
[null,null,null,null,null,93,1,61,1]
[null,null,null,null,null,94,1,62,1]
[null,null,null,null,null,95,1,62,1]
[null,null,null,null,null,96,1,63,1]
[null,null,null,null,null,97,1,64,0]
[null,null,null,null,null,98,1,64,1]
[null,null,null,null,null,99,1,65,1]
[null,null,null,null,null,100,1,69,1]

{"sheet":"It1","index":2,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,10,0,11],[5,0,6,0]]}
["Beta iteration (i-1)",null,null,null,"Beta (iteration i)",null,"exp(X*beta)","Calcolo del vettore p =probabilità stimate dato beta","Calcolo diagonale principale matrice W","Calcolo di z","Calcolo di Xw",null,"Calcolo di zw"]
["beta0",{"$f":"It0!E2:E3","v":0},null,null,{"$f":"Q4","v":-4.1518414064269074},1,{"$f":"EXP(MMULT(It0!G2:H2,B$2:B$3))","v":1},{"$f":"G2/(1+G2)","v":0.5},{"$f":"H2*(1-H2)","v":0.25},{"$f":"MMULT(X,B2:B3)+(y-H2:H101)/I2:I101","v":-2},{"$f":"SQRT(I2:I101)*X","v":0.5},10,{"$f":"SQRT(I2:I101)*J2:J101","v":-1},null,null,"Calcolo del nuovo beta"]
["beta1",0,null,null,{"$f":"P4","v":8.7242933898758618E-2},2,{"$f":"EXP(MMULT(It0!G3:H3,B$2:B$3))","v":1},{"$f":"G3/(1+G3)","v":0.5},{"$f":"H3*(1-H3)","v":0.25},-2,0.5,11.5,-1]
[null,null,null,null,null,3,{"$f":"EXP(MMULT(It0!G4:H4,B$2:B$3))","v":1},{"$f":"G4/(1+G4)","v":0.5},0.25,-2,0.5,12,-1,null,null,{"$f":"LINEST(M2:M101,K2:L101,0,1)","v":8.7242933898758618E-2},-4.1518414064269074]
["Iterazione",1,null,null,null,4,{"$f":"EXP(MMULT(It0!G5:H5,B$2:B$3))","v":1},0.5,0.25,-2,0.5,12.5,-1,null,null,1.4715207115355162E-2,0.67523402012553113]
["Criterio di convergenza",null,null,null,null,5,{"$f":"EXP(MMULT(It0!G6:H6,B$2:B$3))","v":1},0.5,0.25,2,0.5,12.5,1,null,null,0.27841488770405787,0.85808585763750467]
[null,{"$f":"SUMSQ(E2:E3-B2:B3)/SUMSQ(E2:E3)","v":1},null,null,null,6,{"$f":"EXP(MMULT(It0!G7:H7,B$2:B$3))","v":1},0.5,0.25,-2,0.5,13,-1,null,null,18.906057324397427,98]
[null,null,null,null,null,7,{"$f":"EXP(MMULT(It0!G8:H8,B$2:B$3))","v":1},0.5,0.25,-2,0.5,13,-1,null,null,27.841488770405789,72.158511229594211]
[null,null,null,null,null,8,{"$f":"EXP(MMULT(It0!G9:H9,B$2:B$3))","v":1},0.5,0.25,-2,0.5,14,-1]
[null,null,null,null,null,9,{"$f":"EXP(MMULT(It0!G10:H10,B$2:B$3))","v":1},0.5,0.25,-2,0.5,14,-1,null,null,"Regressione di zw su Xw"]
[null,null,null,null,null,10,{"$f":"EXP(MMULT(It0!G11:H11,B$2:B$3))","v":1},0.5,0.25,-2,0.5,14.5,-1]
[null,null,null,null,null,11,{"$f":"EXP(MMULT(It0!G12:H12,B$2:B$3))","v":1},0.5,0.25,-2,0.5,15,-1]
[null,null,null,null,null,12,{"$f":"EXP(MMULT(It0!G13:H13,B$2:B$3))","v":1},0.5,0.25,-2,0.5,15,-1]
[null,null,null,null,null,13,{"$f":"EXP(MMULT(It0!G14:H14,B$2:B$3))","v":1},0.5,0.25,-2,0.5,15,-1]
[null,null,null,null,null,14,{"$f":"EXP(MMULT(It0!G15:H15,B$2:B$3))","v":1},0.5,0.25,-2,0.5,15,-1]
[null,null,null,null,null,15,{"$f":"EXP(MMULT(It0!G16:H16,B$2:B$3))","v":1},0.5,0.25,-2,0.5,15,-1]
[null,null,null,null,null,16,{"$f":"EXP(MMULT(It0!G17:H17,B$2:B$3))","v":1},0.5,0.25,2,0.5,15,1]
[null,null,null,null,null,17,{"$f":"EXP(MMULT(It0!G18:H18,B$2:B$3))","v":1},0.5,0.25,-2,0.5,16,-1]
[null,null,null,null,null,18,{"$f":"EXP(MMULT(It0!G19:H19,B$2:B$3))","v":1},0.5,0.25,-2,0.5,16,-1]
[null,null,null,null,null,19,{"$f":"EXP(MMULT(It0!G20:H20,B$2:B$3))","v":1},0.5,0.25,-2,0.5,16.5,-1]
[null,null,null,null,null,20,{"$f":"EXP(MMULT(It0!G21:H21,B$2:B$3))","v":1},0.5,0.25,-2,0.5,16.5,-1]
[null,null,null,null,null,21,{"$f":"EXP(MMULT(It0!G22:H22,B$2:B$3))","v":1},0.5,0.25,-2,0.5,17,-1]
[null,null,null,null,null,22,{"$f":"EXP(MMULT(It0!G23:H23,B$2:B$3))","v":1},0.5,0.25,-2,0.5,17,-1]
[null,null,null,null,null,23,{"$f":"EXP(MMULT(It0!G24:H24,B$2:B$3))","v":1},0.5,0.25,2,0.5,17,1]
[null,null,null,null,null,24,{"$f":"EXP(MMULT(It0!G25:H25,B$2:B$3))","v":1},0.5,0.25,-2,0.5,17,-1]
[null,null,null,null,null,25,{"$f":"EXP(MMULT(It0!G26:H26,B$2:B$3))","v":1},0.5,0.25,-2,0.5,17,-1]
[null,null,null,null,null,26,{"$f":"EXP(MMULT(It0!G27:H27,B$2:B$3))","v":1},0.5,0.25,-2,0.5,17.5,-1]
[null,null,null,null,null,27,{"$f":"EXP(MMULT(It0!G28:H28,B$2:B$3))","v":1},0.5,0.25,-2,0.5,17.5,-1]
[null,null,null,null,null,28,{"$f":"EXP(MMULT(It0!G29:H29,B$2:B$3))","v":1},0.5,0.25,-2,0.5,18,-1]
[null,null,null,null,null,29,{"$f":"EXP(MMULT(It0!G30:H30,B$2:B$3))","v":1},0.5,0.25,2,0.5,18,1]
[null,null,null,null,null,30,{"$f":"EXP(MMULT(It0!G31:H31,B$2:B$3))","v":1},0.5,0.25,-2,0.5,18,-1]
[null,null,null,null,null,31,{"$f":"EXP(MMULT(It0!G32:H32,B$2:B$3))","v":1},0.5,0.25,-2,0.5,18.5,-1]
[null,null,null,null,null,32,{"$f":"EXP(MMULT(It0!G33:H33,B$2:B$3))","v":1},0.5,0.25,2,0.5,18.5,1]
[null,null,null,null,null,33,{"$f":"EXP(MMULT(It0!G34:H34,B$2:B$3))","v":1},0.5,0.25,-2,0.5,18.5,-1]
[null,null,null,null,null,34,{"$f":"EXP(MMULT(It0!G35:H35,B$2:B$3))","v":1},0.5,0.25,-2,0.5,19,-1]
[null,null,null,null,null,35,{"$f":"EXP(MMULT(It0!G36:H36,B$2:B$3))","v":1},0.5,0.25,-2,0.5,19,-1]
[null,null,null,null,null,36,{"$f":"EXP(MMULT(It0!G37:H37,B$2:B$3))","v":1},0.5,0.25,-2,0.5,19.5,-1]
[null,null,null,null,null,37,{"$f":"EXP(MMULT(It0!G38:H38,B$2:B$3))","v":1},0.5,0.25,2,0.5,19.5,1]
[null,null,null,null,null,38,{"$f":"EXP(MMULT(It0!G39:H39,B$2:B$3))","v":1},0.5,0.25,-2,0.5,20,-1]
[null,null,null,null,null,39,{"$f":"EXP(MMULT(It0!G40:H40,B$2:B$3))","v":1},0.5,0.25,2,0.5,20,1]
[null,null,null,null,null,40,{"$f":"EXP(MMULT(It0!G41:H41,B$2:B$3))","v":1},0.5,0.25,-2,0.5,20.5,-1]
[null,null,null,null,null,41,{"$f":"EXP(MMULT(It0!G42:H42,B$2:B$3))","v":1},0.5,0.25,-2,0.5,20.5,-1]
[null,null,null,null,null,42,{"$f":"EXP(MMULT(It0!G43:H43,B$2:B$3))","v":1},0.5,0.25,-2,0.5,21,-1]
[null,null,null,null,null,43,{"$f":"EXP(MMULT(It0!G44:H44,B$2:B$3))","v":1},0.5,0.25,-2,0.5,21,-1]
[null,null,null,null,null,44,{"$f":"EXP(MMULT(It0!G45:H45,B$2:B$3))","v":1},0.5,0.25,-2,0.5,21,-1]
[null,null,null,null,null,45,{"$f":"EXP(MMULT(It0!G46:H46,B$2:B$3))","v":1},0.5,0.25,2,0.5,21,1]
[null,null,null,null,null,46,{"$f":"EXP(MMULT(It0!G47:H47,B$2:B$3))","v":1},0.5,0.25,-2,0.5,21.5,-1]
[null,null,null,null,null,47,{"$f":"EXP(MMULT(It0!G48:H48,B$2:B$3))","v":1},0.5,0.25,-2,0.5,21.5,-1]
[null,null,null,null,null,48,{"$f":"EXP(MMULT(It0!G49:H49,B$2:B$3))","v":1},0.5,0.25,2,0.5,21.5,1]
[null,null,null,null,null,49,{"$f":"EXP(MMULT(It0!G50:H50,B$2:B$3))","v":1},0.5,0.25,-2,0.5,22,-1]
[null,null,null,null,null,50,{"$f":"EXP(MMULT(It0!G51:H51,B$2:B$3))","v":1},0.5,0.25,-2,0.5,22,-1]
[null,null,null,null,null,51,{"$f":"EXP(MMULT(It0!G52:H52,B$2:B$3))","v":1},0.5,0.25,2,0.5,22,1]
[null,null,null,null,null,52,{"$f":"EXP(MMULT(It0!G53:H53,B$2:B$3))","v":1},0.5,0.25,2,0.5,22,1]
[null,null,null,null,null,53,{"$f":"EXP(MMULT(It0!G54:H54,B$2:B$3))","v":1},0.5,0.25,-2,0.5,22.5,-1]
[null,null,null,null,null,54,{"$f":"EXP(MMULT(It0!G55:H55,B$2:B$3))","v":1},0.5,0.25,2,0.5,22.5,1]
[null,null,null,null,null,55,{"$f":"EXP(MMULT(It0!G56:H56,B$2:B$3))","v":1},0.5,0.25,-2,0.5,23,-1]
[null,null,null,null,null,56,{"$f":"EXP(MMULT(It0!G57:H57,B$2:B$3))","v":1},0.5,0.25,2,0.5,23,1]
[null,null,null,null,null,57,{"$f":"EXP(MMULT(It0!G58:H58,B$2:B$3))","v":1},0.5,0.25,-2,0.5,23.5,-1]
[null,null,null,null,null,58,{"$f":"EXP(MMULT(It0!G59:H59,B$2:B$3))","v":1},0.5,0.25,-2,0.5,23.5,-1]
[null,null,null,null,null,59,{"$f":"EXP(MMULT(It0!G60:H60,B$2:B$3))","v":1},0.5,0.25,2,0.5,23.5,1]
[null,null,null,null,null,60,{"$f":"EXP(MMULT(It0!G61:H61,B$2:B$3))","v":1},0.5,0.25,-2,0.5,24,-1]
[null,null,null,null,null,61,{"$f":"EXP(MMULT(It0!G62:H62,B$2:B$3))","v":1},0.5,0.25,2,0.5,24,1]
[null,null,null,null,null,62,{"$f":"EXP(MMULT(It0!G63:H63,B$2:B$3))","v":1},0.5,0.25,2,0.5,24,1]
[null,null,null,null,null,63,{"$f":"EXP(MMULT(It0!G64:H64,B$2:B$3))","v":1},0.5,0.25,-2,0.5,24.5,-1]
[null,null,null,null,null,64,{"$f":"EXP(MMULT(It0!G65:H65,B$2:B$3))","v":1},0.5,0.25,-2,0.5,24.5,-1]
[null,null,null,null,null,65,{"$f":"EXP(MMULT(It0!G66:H66,B$2:B$3))","v":1},0.5,0.25,2,0.5,24.5,1]
[null,null,null,null,null,66,{"$f":"EXP(MMULT(It0!G67:H67,B$2:B$3))","v":1},0.5,{"$f":"H67*(1-H67)","v":0.25},-2,0.5,25,-1]
[null,null,null,null,null,67,{"$f":"EXP(MMULT(It0!G68:H68,B$2:B$3))","v":1},{"$f":"G68/(1+G68)","v":0.5},0.25,2,0.5,25,1]
[null,null,null,null,null,68,{"$f":"EXP(MMULT(It0!G69:H69,B$2:B$3))","v":1},0.5,0.25,-2,0.5,25.5,-1]
[null,null,null,null,null,69,{"$f":"EXP(MMULT(It0!G70:H70,B$2:B$3))","v":1},0.5,0.25,-2,0.5,26,-1]
[null,null,null,null,null,70,{"$f":"EXP(MMULT(It0!G71:H71,B$2:B$3))","v":1},0.5,0.25,2,0.5,26,1]
[null,null,null,null,null,71,{"$f":"EXP(MMULT(It0!G72:H72,B$2:B$3))","v":1},0.5,0.25,2,0.5,26.5,1]
[null,null,null,null,null,72,{"$f":"EXP(MMULT(It0!G73:H73,B$2:B$3))","v":1},0.5,0.25,2,0.5,26.5,1]
[null,null,null,null,null,73,{"$f":"EXP(MMULT(It0!G74:H74,B$2:B$3))","v":1},0.5,0.25,2,0.5,27,1]
[null,null,null,null,null,74,{"$f":"EXP(MMULT(It0!G75:H75,B$2:B$3))","v":1},0.5,0.25,-2,0.5,27.5,-1]
[null,null,null,null,null,75,{"$f":"EXP(MMULT(It0!G76:H76,B$2:B$3))","v":1},0.5,0.25,2,0.5,27.5,1]
[null,null,null,null,null,76,{"$f":"EXP(MMULT(It0!G77:H77,B$2:B$3))","v":1},0.5,0.25,2,0.5,27.5,1]
[null,null,null,null,null,77,{"$f":"EXP(MMULT(It0!G78:H78,B$2:B$3))","v":1},0.5,0.25,2,0.5,28,1]
[null,null,null,null,null,78,{"$f":"EXP(MMULT(It0!G79:H79,B$2:B$3))","v":1},0.5,0.25,2,0.5,28,1]
[null,null,null,null,null,79,{"$f":"EXP(MMULT(It0!G80:H80,B$2:B$3))","v":1},0.5,0.25,2,0.5,28,1]
[null,null,null,null,null,80,{"$f":"EXP(MMULT(It0!G81:H81,B$2:B$3))","v":1},0.5,0.25,-2,0.5,28.5,-1]
[null,null,null,null,null,81,{"$f":"EXP(MMULT(It0!G82:H82,B$2:B$3))","v":1},0.5,0.25,-2,0.5,28.5,-1]
[null,null,null,null,null,82,{"$f":"EXP(MMULT(It0!G83:H83,B$2:B$3))","v":1},0.5,0.25,2,0.5,28.5,1]
[null,null,null,null,null,83,{"$f":"EXP(MMULT(It0!G84:H84,B$2:B$3))","v":1},0.5,0.25,2,0.5,28.5,1]
[null,null,null,null,null,84,{"$f":"EXP(MMULT(It0!G85:H85,B$2:B$3))","v":1},0.5,0.25,2,0.5,28.5,1]
[null,null,null,null,null,85,{"$f":"EXP(MMULT(It0!G86:H86,B$2:B$3))","v":1},0.5,0.25,2,0.5,28.5,1]
[null,null,null,null,null,86,{"$f":"EXP(MMULT(It0!G87:H87,B$2:B$3))","v":1},0.5,0.25,-2,0.5,29,-1]
[null,null,null,null,null,87,{"$f":"EXP(MMULT(It0!G88:H88,B$2:B$3))","v":1},0.5,0.25,2,0.5,29,1]
[null,null,null,null,null,88,{"$f":"EXP(MMULT(It0!G89:H89,B$2:B$3))","v":1},0.5,0.25,2,0.5,29,1]
[null,null,null,null,null,89,{"$f":"EXP(MMULT(It0!G90:H90,B$2:B$3))","v":1},0.5,0.25,2,0.5,29.5,1]
[null,null,null,null,null,90,{"$f":"EXP(MMULT(It0!G91:H91,B$2:B$3))","v":1},0.5,0.25,2,0.5,29.5,1]
[null,null,null,null,null,91,{"$f":"EXP(MMULT(It0!G92:H92,B$2:B$3))","v":1},0.5,0.25,-2,0.5,30,-1]
[null,null,null,null,null,92,{"$f":"EXP(MMULT(It0!G93:H93,B$2:B$3))","v":1},0.5,0.25,2,0.5,30,1]
[null,null,null,null,null,93,{"$f":"EXP(MMULT(It0!G94:H94,B$2:B$3))","v":1},0.5,0.25,2,0.5,30.5,1]
[null,null,null,null,null,94,{"$f":"EXP(MMULT(It0!G95:H95,B$2:B$3))","v":1},0.5,0.25,2,0.5,31,1]
[null,null,null,null,null,95,{"$f":"EXP(MMULT(It0!G96:H96,B$2:B$3))","v":1},0.5,0.25,2,0.5,31,1]
[null,null,null,null,null,96,{"$f":"EXP(MMULT(It0!G97:H97,B$2:B$3))","v":1},0.5,0.25,2,0.5,31.5,1]
[null,null,null,null,null,97,{"$f":"EXP(MMULT(It0!G98:H98,B$2:B$3))","v":1},0.5,0.25,-2,0.5,32,-1]
[null,null,null,null,null,98,{"$f":"EXP(MMULT(It0!G99:H99,B$2:B$3))","v":1},0.5,0.25,2,0.5,32,1]
[null,null,null,null,null,99,{"$f":"EXP(MMULT(It0!G100:H100,B$2:B$3))","v":1},0.5,0.25,2,0.5,32.5,1]
[null,null,null,null,null,100,{"$f":"EXP(MMULT(It0!G101:H101,B$2:B$3))","v":1},0.5,0.25,2,0.5,34.5,1]

{"sheet":"It2","index":3,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,10,0,11],[5,0,6,0]]}
["Beta iteration (i-1)",null,null,null,"Beta (iteration i)",null,"exp(X*beta)","Calcolo del vettore p =probabilità stimate dato beta","Calcolo diagonale principale matrice W","Calcolo di z","Calcolo di Xw",null,"Calcolo di zw"]
["beta0",{"$f":"'It1'!E2:E3","v":-4.1518414064269074},null,null,{"$f":"Q4","v":-5.1811059744453987},1,{"$f":"EXP(MMULT(It0!G2:H2,B$2:B$3))","v":9.0086700952628981E-2},{"$f":"G2/(1+G2)","v":8.2641775992590344E-2},{"$f":"H2*(1-H2)","v":7.5812112853380853E-2},{"$f":"MMULT(X,B2:B3)+(y-H2:H101)/I2:I101","v":-3.4970694294043643},{"$f":"SQRT(I2:I101)*X","v":0.27533999501231354},5.5067999002462713,{"$f":"SQRT(I2:I101)*J2:J101","v":-0.96288307924991179},null,null,"Calcolo del nuovo beta"]
["beta1",8.7242933898758618E-2,null,null,{"$f":"P4","v":0.10832543606506241},2,{"$f":"EXP(MMULT(It0!G3:H3,B$2:B$3))","v":0.11703831411119543},{"$f":"G3/(1+G3)","v":0.10477555929164384},{"$f":"H3*(1-H3)","v":9.379764146676707E-2},-3.262292240866655,0.30626400615607291,7.0440721415896768,-0.99912269093969408]
[null,null,null,null,null,3,{"$f":"EXP(MMULT(It0!G4:H4,B$2:B$3))","v":0.12770772903209271},{"$f":"G4/(1+G4)","v":0.11324541434304417},0.10042089047331641,-3.1857187218887928,0.31689255351509354,7.6054212843622455,-1.0095305405601798,null,null,{"$f":"LINEST(M2:M101,K2:L101,0,1)","v":0.10832543606506241},-5.1811059744453987]
["Iterazione",2,null,null,null,4,{"$f":"EXP(MMULT(It0!G5:H5,B$2:B$3))","v":0.13934978625067471},0.12230641365128196,0.10734755483104348,-3.1101178452086162,0.32763936703492069,8.1909841758730177,-1.0189970422081625,null,null,2.0406721983450678E-2,0.95326023548917682]
["Criterio di convergenza",null,null,null,null,5,{"$f":"EXP(MMULT(It0!G6:H6,B$2:B$3))","v":0.13934978625067471},0.12230641365128196,0.10734755483104348,6.205418047284887,0.32763936703492069,8.1909841758730177,2.033139241199494,null,null,0.23162996117946877,0.94861806316887243]
[null,{"$f":"SUMSQ(E2:E3-B2:B3)/SUMSQ(E2:E3)","v":3.9464032777548438E-2},null,null,null,6,{"$f":"EXP(MMULT(It0!G7:H7,B$2:B$3))","v":0.15205315351922774},0.13198449486010627,0.11456458797662884,-3.0355782785784111,0.33847391033376389,8.8003216686778618,-1.0274640500746706,null,null,14.771356930075415,98]
[null,null,null,null,null,7,{"$f":"EXP(MMULT(It0!G8:H8,B$2:B$3))","v":0.15205315351922774},0.13198449486010627,0.11456458797662884,-3.0355782785784111,0.33847391033376389,8.8003216686778618,-1.0274640500746706,null,null,26.58478596565422,88.187870517485763]
[null,null,null,null,null,8,{"$f":"EXP(MMULT(It0!G9:H9,B$2:B$3))","v":0.18103964161269978},0.15328837003768278,0.1297910456488732,-2.890078898874366,0.36026524346496874,10.087426817019125,-1.0411949781359422]
[null,null,null,null,null,9,{"$f":"EXP(MMULT(It0!G10:H10,B$2:B$3))","v":0.18103964161269978},0.15328837003768278,0.1297910456488732,-2.890078898874366,0.36026524346496874,10.087426817019125,-1.0411949781359422,null,null,"Regressione di zw su Xw"]
[null,null,null,null,null,10,{"$f":"EXP(MMULT(It0!G11:H11,B$2:B$3))","v":0.19754352812341344},0.16495728421076272,0.13774637859657238,-2.8193398514863208,0.37114199249959895,10.76311778248837,-1.0463754100141565]
[null,null,null,null,null,11,{"$f":"EXP(MMULT(It0!G12:H12,B$2:B$3))","v":0.21555193744212744},0.17732844710503362,0.14588306895235092,-2.7501053269062758,0.38194642157290981,11.458392647187294,-1.0503928885604494]
[null,null,null,null,null,12,{"$f":"EXP(MMULT(It0!G13:H13,B$2:B$3))","v":0.21555193744212744},0.17732844710503362,0.14588306895235092,-2.7501053269062758,0.38194642157290981,11.458392647187294,-1.0503928885604494]
[null,null,null,null,null,13,{"$f":"EXP(MMULT(It0!G14:H14,B$2:B$3))","v":0.21555193744212744},0.17732844710503362,0.14588306895235092,-2.7501053269062758,0.38194642157290981,11.458392647187294,-1.0503928885604494]
[null,null,null,null,null,14,{"$f":"EXP(MMULT(It0!G15:H15,B$2:B$3))","v":0.21555193744212744},0.17732844710503362,0.14588306895235092,-2.7501053269062758,0.38194642157290981,11.458392647187294,-1.0503928885604494]
[null,null,null,null,null,15,{"$f":"EXP(MMULT(It0!G16:H16,B$2:B$3))","v":0.21555193744212744},0.17732844710503362,0.14588306895235092,-2.7501053269062758,0.38194642157290981,11.458392647187294,-1.0503928885604494]
[null,null,null,null,null,16,{"$f":"EXP(MMULT(It0!G17:H17,B$2:B$3))","v":0.21555193744212744},0.17732844710503362,0.14588306895235092,4.1046997384205657,0.38194642157290981,11.458392647187294,1.5677753767209941]
[null,null,null,null,null,17,{"$f":"EXP(MMULT(It0!G18:H18,B$2:B$3))","v":0.25664344737520461},0.20422932846326841,0.16251970985871084,-2.6167109690418364,0.40313733374460725,12.900394679827432,-1.0548938832397934]
[null,null,null,null,null,18,{"$f":"EXP(MMULT(It0!G19:H19,B$2:B$3))","v":0.25664344737520461},0.20422932846326841,0.16251970985871084,-2.6167109690418364,0.40313733374460725,12.900394679827432,-1.0548938832397934]
[null,null,null,null,null,19,{"$f":"EXP(MMULT(It0!G20:H20,B$2:B$3))","v":0.28003950743955219},0.21877411268321859,0.17091200030288897,-2.5528640952074251,0.41341504605286072,13.642696519744405,-1.0553924274868722]
[null,null,null,null,null,20,{"$f":"EXP(MMULT(It0!G21:H21,B$2:B$3))","v":0.28003950743955219},0.21877411268321859,0.17091200030288897,-2.5528640952074251,0.41341504605286072,13.642696519744405,-1.0553924274868722]
[null,null,null,null,null,21,{"$f":"EXP(MMULT(It0!G22:H22,B$2:B$3))","v":0.30556839276062386},0.23405008458767879,0.17927064249217919,-2.4911500466297385,0.42340364014989196,14.395723765096326,-1.0547619979026044]
[null,null,null,null,null,22,{"$f":"EXP(MMULT(It0!G23:H23,B$2:B$3))","v":0.30556839276062386},0.23405008458767879,0.17927064249217919,-2.4911500466297385,0.42340364014989196,14.395723765096326,-1.0547619979026044]
[null,null,null,null,null,23,{"$f":"EXP(MMULT(It0!G24:H24,B$2:B$3))","v":0.30556839276062386},0.23405008458767879,0.17927064249217919,3.0870081286198747,0.42340364014989196,14.395723765096326,1.3070504788299608]
[null,null,null,null,null,24,{"$f":"EXP(MMULT(It0!G25:H25,B$2:B$3))","v":0.30556839276062386},0.23405008458767879,0.17927064249217919,-2.4911500466297385,0.42340364014989196,14.395723765096326,-1.0547619979026044]
[null,null,null,null,null,25,{"$f":"EXP(MMULT(It0!G26:H26,B$2:B$3))","v":0.30556839276062386},0.23405008458767879,0.17927064249217919,-2.4911500466297385,0.42340364014989196,14.395723765096326,-1.0547619979026044]
[null,null,null,null,null,26,{"$f":"EXP(MMULT(It0!G27:H27,B$2:B$3))","v":0.33342453537369421},0.25005129763886602,0.18752564618798526,-2.43176325534405,0.43304231454672565,15.156481009135398,-1.0530563885238677]
[null,null,null,null,null,27,{"$f":"EXP(MMULT(It0!G28:H28,B$2:B$3))","v":0.33342453537369421},0.25005129763886602,0.18752564618798526,-2.43176325534405,0.43304231454672565,15.156481009135398,-1.0530563885238677]
[null,null,null,null,null,28,{"$f":"EXP(MMULT(It0!G29:H29,B$2:B$3))","v":0.36382009207429289},0.26676545842710325,0.19560164861728069,-2.3749158781458899,0.44226875157225465,15.921675056601167,-1.0503510805167076]
[null,null,null,null,null,29,{"$f":"EXP(MMULT(It0!G30:H30,B$2:B$3))","v":0.36382009207429289},0.26676545842710325,0.19560164861728069,2.7375154692842441,0.44226875157225465,15.921675056601167,1.2107175490100774]
[null,null,null,null,null,30,{"$f":"EXP(MMULT(It0!G31:H31,B$2:B$3))","v":0.36382009207429289},0.26676545842710325,0.19560164861728069,-2.3749158781458899,0.44226875157225465,15.921675056601167,-1.0503510805167076]
[null,null,null,null,null,31,{"$f":"EXP(MMULT(It0!G32:H32,B$2:B$3))","v":0.39698656023797219},0.28417349997293234,0.20341892188606614,-2.3208394124108112,0.45101986861563664,16.687735138778557,-1.0467446868635153]
[null,null,null,null,null,32,{"$f":"EXP(MMULT(It0!G33:H33,B$2:B$3))","v":0.39698656023797219},0.28417349997293234,0.20341892188606614,2.5951241111796572,0.45101986861563664,16.687735138778557,1.1704525356655198]
[null,null,null,null,null,33,{"$f":"EXP(MMULT(It0!G34:H34,B$2:B$3))","v":0.39698656023797219},0.28417349997293234,0.20341892188606614,-2.3208394124108112,0.45101986861563664,16.687735138778557,-1.0467446868635153]
[null,null,null,null,null,34,{"$f":"EXP(MMULT(It0!G35:H35,B$2:B$3))","v":0.43317654094099672},0.30224925441256606,0.21089464261961396,-2.2697864592150769,0.45923266719563183,17.450841353434008,-1.042360089629869]
[null,null,null,null,null,35,{"$f":"EXP(MMULT(It0!G36:H36,B$2:B$3))","v":0.43317654094099672},0.30224925441256606,0.21089464261961396,-2.2697864592150769,0.45923266719563183,17.450841353434008,-1.042360089629869]
[null,null,null,null,null,36,{"$f":"EXP(MMULT(It0!G37:H37,B$2:B$3))","v":0.47266566281016092},0.32095924740189419,0.21794440890910385,-2.2220326471854825,0.46684516588383335,18.206961469469501,-1.0373451997745999]
[null,null,null,null,null,37,{"$f":"EXP(MMULT(It0!G38:H38,B$2:B$3))","v":0.47266566281016092},0.32095924740189419,0.21794440890910385,2.3662933622101572,0.46684516588383335,18.206961469469501,1.1046926172108145]
[null,null,null,null,null,38,{"$f":"EXP(MMULT(It0!G39:H39,B$2:B$3))","v":0.51575468125408019},0.34026263460216638,0.22448397409575896,-2.1778787317306434,0.47379739773004131,18.951895909201653,-1.0318732756655815]
[null,null,null,null,null,39,{"$f":"EXP(MMULT(It0!G40:H40,B$2:B$3))","v":0.51575468125408019},0.34026263460216638,0.22448397409575896,2.2767822480924695,0.47379739773004131,18.951895909201653,1.0787335043441655]
[null,null,null,null,null,40,{"$f":"EXP(MMULT(It0!G41:H41,B$2:B$3))","v":0.56277176906403292},0.3601112972504521,0.23043115084304863,-2.1376528856418364,0.48003244769812031,19.681330355622933,-1.0261427470236009]
[null,null,null,null,null,41,{"$f":"EXP(MMULT(It0!G42:H42,B$2:B$3))","v":0.56277176906403292},0.3601112972504521,0.23043115084304863,-2.1376528856418364,0.48003244769812031,19.681330355622933,-1.0261427470236009]
[null,null,null,null,null,42,{"$f":"EXP(MMULT(It0!G43:H43,B$2:B$3))","v":0.6140750158299324},0.3804501090763644,0.23570782358014686,-2.1017131985089774,0.48549750110597567,20.390895046450979,-1.020376505917556]
[null,null,null,null,null,43,{"$f":"EXP(MMULT(It0!G44:H44,B$2:B$3))","v":0.6140750158299324},0.3804501090763644,0.23570782358014686,-2.1017131985089774,0.48549750110597567,20.390895046450979,-1.020376505917556]
[null,null,null,null,null,44,{"$f":"EXP(MMULT(It0!G45:H45,B$2:B$3))","v":0.6140750158299324},0.3804501090763644,0.23570782358014686,-2.1017131985089774,0.48549750110597567,20.390895046450979,-1.020376505917556]
[null,null,null,null,null,45,{"$f":"EXP(MMULT(It0!G46:H46,B$2:B$3))","v":0.6140750158299324},0.3804501090763644,0.23570782358014686,2.1408273536503946,0.48549750110597567,20.390895046450979,1.0393663304965854]
[null,null,null,null,null,46,{"$f":"EXP(MMULT(It0!G47:H47,B$2:B$3))","v":0.67005515520737891},0.40121738082606911,0.24024199414913816,-2.0704504039876657,0.49014487057311756,21.076229434644056,-1.0148206452905935]
[null,null,null,null,null,47,{"$f":"EXP(MMULT(It0!G48:H48,B$2:B$3))","v":0.67005515520737891},0.40121738082606911,0.24024199414913816,-2.0704504039876657,0.49014487057311756,21.076229434644056,-1.0148206452905935]
[null,null,null,null,null,48,{"$f":"EXP(MMULT(It0!G49:H49,B$2:B$3))","v":0.67005515520737891},0.40121738082606911,0.24024199414913816,2.0920192072961012,0.49014487057311756,21.076229434644056,1.0253924835966235]
[null,null,null,null,null,49,{"$f":"EXP(MMULT(It0!G50:H50,B$2:B$3))","v":0.73113854080708529},0.42234548164251279,0.24396977577866671,-2.044290855688613,0.49393296688788318,21.733050543066859,-1.0097426475320461]
[null,null,null,null,null,50,{"$f":"EXP(MMULT(It0!G51:H51,B$2:B$3))","v":0.73113854080708529},0.42234548164251279,0.24396977577866671,-2.044290855688613,0.49393296688788318,21.733050543066859,-1.0097426475320461]
[null,null,null,null,null,51,{"$f":"EXP(MMULT(It0!G52:H52,B$2:B$3))","v":0.73113854080708529},0.42234548164251279,0.24396977577866671,2.0545775258899974,0.49393296688788318,21.733050543066859,1.0148235730640132]
[null,null,null,null,null,52,{"$f":"EXP(MMULT(It0!G53:H53,B$2:B$3))","v":0.73113854080708529},0.42234548164251279,0.24396977577866671,2.0545775258899974,0.49393296688788318,21.733050543066859,1.0148235730640132]
[null,null,null,null,null,53,{"$f":"EXP(MMULT(It0!G54:H54,B$2:B$3))","v":0.79779039337152646},0.44376162889343979,0.24683724561528078,-2.0236997743542959,0.49682717882104716,22.357223046947123,-1.0054290496732345]
[null,null,null,null,null,54,{"$f":"EXP(MMULT(It0!G55:H55,B$2:B$3))","v":0.79779039337152646},0.44376162889343979,0.24683724561528078,2.0275526916475108,0.49682717882104716,22.357223046947123,1.0073432837022533]
[null,null,null,null,null,55,{"$f":"EXP(MMULT(It0!G56:H56,B$2:B$3))","v":0.87051834396981997},0.46538883020110361,0.248802066925152,-2.0091847910538312,0.49880062843299627,22.944828907917827,-1.0021826364156694]
[null,null,null,null,null,56,{"$f":"EXP(MMULT(It0!G57:H57,B$2:B$3))","v":0.87051834396981997},0.46538883020110361,0.248802066925152,2.0100744231424623,0.49880062843299627,22.944828907917827,1.0026263854605526]
[null,null,null,null,null,57,{"$f":"EXP(MMULT(It0!G58:H58,B$2:B$3))","v":0.94987630019637803},0.48714695393790519,0.24983479920692567,-2.00129981338163,0.4998347719066028,23.492234279610333,-1.0003192357383337]
[null,null,null,null,null,58,{"$f":"EXP(MMULT(It0!G59:H59,B$2:B$3))","v":0.94987630019637803},0.48714695393790519,0.24983479920692567,-2.00129981338163,0.4998347719066028,23.492234279610333,-1.0003192357383337]
[null,null,null,null,null,59,{"$f":"EXP(MMULT(It0!G60:H60,B$2:B$3))","v":0.94987630019637803},0.48714695393790519,0.24983479920692567,2.0013451471058397,0.4998347719066028,23.492234279610333,1.0003418951100338]
[null,null,null,null,null,60,{"$f":"EXP(MMULT(It0!G61:H61,B$2:B$3))","v":1.0364686648189003},0.50895389785487888,0.2499198277132044,-2.0006492441053934,0.49991982128457801,23.996151421659746,-1.0001642125662944]
[null,null,null,null,null,61,{"$f":"EXP(MMULT(It0!G62:H62,B$2:B$3))","v":1.0364686648189003},0.50895389785487888,0.2499198277132044,2.0006339239814159,0.49991982128457801,23.996151421659746,1.0001565537326536]
[null,null,null,null,null,62,{"$f":"EXP(MMULT(It0!G63:H63,B$2:B$3))","v":1.0364686648189003},0.50895389785487888,0.2499198277132044,2.0006339239814159,0.49991982128457801,23.996151421659746,1.0001565537326536]
[null,null,null,null,null,63,{"$f":"EXP(MMULT(It0!G64:H64,B$2:B$3))","v":1.1309549390056142},0.53072682031153662,0.24905586251354253,-2.0078925843933493,0.49905496943076577,24.453693502107523,-1.0020487723246843]
[null,null,null,null,null,64,{"$f":"EXP(MMULT(It0!G65:H65,B$2:B$3))","v":1.1309549390056142},0.53072682031153662,0.24905586251354253,-2.0078925843933493,0.49905496943076577,24.453693502107523,-1.0020487723246843]
[null,null,null,null,null,65,{"$f":"EXP(MMULT(It0!G66:H66,B$2:B$3))","v":1.1309549390056142},0.53072682031153662,0.24905586251354253,2.007270880974283,0.49905496943076577,24.453693502107523,1.001738508143887]
[null,null,null,null,null,66,{"$f":"EXP(MMULT(It0!G67:H67,B$2:B$3))","v":1.2340547451906618},0.55238339519085666,{"$f":"H67*(1-H67)","v":0.24725597990827852},-2.0237494566796381,0.49724840865333952,24.862420432666976,-1.0063061968470106]
[null,null,null,null,null,67,{"$f":"EXP(MMULT(It0!G68:H68,B$2:B$3))","v":1.2340547451906618},{"$f":"G68/(1+G68)","v":0.55238339519085666},0.24725597990827852,2.020642110193517,0.49724840865333952,24.862420432666976,1.0047610737516524]
[null,null,null,null,null,68,{"$f":"EXP(MMULT(It0!G69:H69,B$2:B$3))","v":1.3465533078325662},0.57384305028907823,0.24454720392400467,-2.0490050854227841,0.494517142194287,25.220374251908638,-1.0132681391848362]
[null,null,null,null,null,69,{"$f":"EXP(MMULT(It0!G70:H70,B$2:B$3))","v":1.4693074338081222},0.59502814987366004,0.24096965073158921,-2.0845162774995809,0.49088659661024481,25.52610302373273,-1.023261101040426]
[null,null,null,null,null,70,{"$f":"EXP(MMULT(It0!G71:H71,B$2:B$3))","v":1.4693074338081222},0.59502814987366004,0.24096965073158921,2.0653839151760431,0.49088659661024481,25.52610302373273,1.0138692808143104]
[null,null,null,null,null,71,{"$f":"EXP(MMULT(It0!G72:H72,B$2:B$3))","v":1.6032520379893092},0.61586508512929983,0.23657528204798012,2.0957663396009334,0.48639005134560487,25.778672721317058,1.0193598975268883]
[null,null,null,null,null,72,{"$f":"EXP(MMULT(It0!G73:H73,B$2:B$3))","v":1.6032520379893092},0.61586508512929983,0.23657528204798012,2.0957663396009334,0.48639005134560487,25.778672721317058,1.0193598975268883]
[null,null,null,null,null,73,{"$f":"EXP(MMULT(It0!G74:H74,B$2:B$3))","v":1.7494072637030897},0.63628524111297657,0.23142633305477783,2.1308992076582358,0.48106790898456098,25.977667085166292,1.0251072260850054]
[null,null,null,null,null,74,{"$f":"EXP(MMULT(It0!G75:H75,B$2:B$3))","v":1.9088862523046028},0.65622581522129408,0.22559349465844208,-2.2623662942997864,0.47496683532478567,26.123175942863213,-1.0745489591490323]
[null,null,null,null,null,75,{"$f":"EXP(MMULT(It0!G76:H76,B$2:B$3))","v":1.9088862523046028},0.65622581522129408,0.22559349465844208,2.1703856408304416,0.47496683532478567,26.123175942863213,1.0308611992595917]
[null,null,null,null,null,76,{"$f":"EXP(MMULT(It0!G77:H77,B$2:B$3))","v":1.9088862523046028},0.65622581522129408,0.22559349465844208,2.1703856408304416,0.47496683532478567,26.123175942863213,1.0308611992595917]
[null,null,null,null,null,77,{"$f":"EXP(MMULT(It0!G78:H78,B$2:B$3))","v":2.0829036210380969},0.67563046954310135,0.21915393816806975,2.2138619180417178,0.46813880224573323,26.215772925761062,1.0363946666494914]
[null,null,null,null,null,78,{"$f":"EXP(MMULT(It0!G79:H79,B$2:B$3))","v":2.0829036210380969},0.67563046954310135,0.21915393816806975,2.2138619180417178,0.46813880224573323,26.215772925761062,1.0363946666494914]
[null,null,null,null,null,79,{"$f":"EXP(MMULT(It0!G80:H80,B$2:B$3))","v":2.0829036210380969},0.67563046954310135,0.21915393816806975,2.2138619180417178,0.46813880224573323,26.215772925761062,1.0363946666494914]
[null,null,null,null,null,80,{"$f":"EXP(MMULT(It0!G81:H81,B$2:B$3))","v":2.2727847137542883},0.6944498072857116,0.21218927244654961,-2.4517788879519546,0.46064006821655196,26.25648388834346,-1.1293875941980902]
[null,null,null,null,null,81,{"$f":"EXP(MMULT(It0!G82:H82,B$2:B$3))","v":2.2727847137542883},0.6944498072857116,0.21218927244654961,-2.4517788879519546,0.46064006821655196,26.25648388834346,-1.1293875941980902]
[null,null,null,null,null,82,{"$f":"EXP(MMULT(It0!G83:H83,B$2:B$3))","v":2.2727847137542883},0.6944498072857116,0.21218927244654961,2.2609947055005586,0.46064006821655196,26.25648388834346,1.0415047553790402]
[null,null,null,null,null,83,{"$f":"EXP(MMULT(It0!G84:H84,B$2:B$3))","v":2.2727847137542883},0.6944498072857116,0.21218927244654961,2.2609947055005586,0.46064006821655196,26.25648388834346,1.0415047553790402]
[null,null,null,null,null,84,{"$f":"EXP(MMULT(It0!G85:H85,B$2:B$3))","v":2.2727847137542883},0.6944498072857116,0.21218927244654961,2.2609947055005586,0.46064006821655196,26.25648388834346,1.0415047553790402]
[null,null,null,null,null,85,{"$f":"EXP(MMULT(It0!G86:H86,B$2:B$3))","v":2.2727847137542883},0.6944498072857116,0.21218927244654961,2.2609947055005586,0.46064006821655196,26.25648388834346,1.0415047553790402]
[null,null,null,null,null,86,{"$f":"EXP(MMULT(It0!G87:H87,B$2:B$3))","v":2.4799756949391214},0.71264167118917365,0.20478351967387534,-2.5717269352380292,0.45253013123313163,26.246747611521634,-1.1637839274990447]
[null,null,null,null,null,87,{"$f":"EXP(MMULT(It0!G88:H88,B$2:B$3))","v":2.4799756949391214},0.71264167118917365,0.20478351967387534,2.3114785179768278,0.45253013123313163,26.246747611521634,1.0460136770826185]
[null,null,null,null,null,88,{"$f":"EXP(MMULT(It0!G89:H89,B$2:B$3))","v":2.4799756949391214},0.71264167118917365,0.20478351967387534,2.3114785179768278,0.45253013123313163,26.246747611521634,1.0460136770826185]
[null,null,null,null,null,89,{"$f":"EXP(MMULT(It0!G90:H90,B$2:B$3))","v":2.7060545639316023},0.73017126900065366,0.19702118692662873,2.3650333921778386,0.44387068716759021,26.188370542887821,1.0497689969602741]
[null,null,null,null,null,90,{"$f":"EXP(MMULT(It0!G91:H91,B$2:B$3))","v":2.7060545639316023},0.73017126900065366,0.19702118692662873,2.3650333921778386,0.44387068716759021,26.188370542887821,1.0497689969602741]
[null,null,null,null,null,91,{"$f":"EXP(MMULT(It0!G92:H92,B$2:B$3))","v":2.9527431732167924},0.74701113728413893,0.18898549805759626,-2.8700085457181821,0.43472462324740274,26.083477394844163,-1.2476633837541629]
[null,null,null,null,null,92,{"$f":"EXP(MMULT(It0!G93:H93,B$2:B$3))","v":2.9527431732167924},0.74701113728413893,0.18898549805759626,2.4214027545035655,0.43472462324740274,26.083477394844163,1.0526434001817857]
[null,null,null,null,null,93,{"$f":"EXP(MMULT(It0!G94:H94,B$2:B$3))","v":3.2219203423271168},0.76314095982000429,0.18075683526500688,2.4803514669414524,0.42515507202079439,25.934459393268458,1.0545340065643762]
[null,null,null,null,null,94,{"$f":"EXP(MMULT(It0!G95:H95,B$2:B$3))","v":3.5156361672296144},0.77854726045975731,0.17241142369036414,2.5416640362180587,0.41522454610772247,25.743921858678792,1.0553612957969654]
[null,null,null,null,null,95,{"$f":"EXP(MMULT(It0!G96:H96,B$2:B$3))","v":3.5156361672296144},0.77854726045975731,0.17241142369036414,2.5416640362180587,0.41522454610772247,25.743921858678792,1.0553612957969654]
[null,null,null,null,null,96,{"$f":"EXP(MMULT(It0!G97:H97,B$2:B$3))","v":3.8361276341816093},0.79322299251739559,0.16402027665914337,2.6051429725681441,0.40499416867301113,25.514632626399703,1.0550677124495726]
[null,null,null,null,null,97,{"$f":"EXP(MMULT(It0!G98:H98,B$2:B$3))","v":4.1858356569724853},0.80716704767620717,0.15564840482188266,-3.7541292938788411,0.39452300924265832,25.249472591530132,-1.4810903861070963]
[null,null,null,null,null,98,{"$f":"EXP(MMULT(It0!G99:H99,B$2:B$3))","v":4.1858356569724853},0.80716704767620717,0.15564840482188266,2.6706072856213279,0.39452300924265832,25.249472591530132,1.0536160228286937]
[null,null,null,null,null,99,{"$f":"EXP(MMULT(It0!G100:H100,B$2:B$3))","v":4.5674236673098125},0.82038370712261577,0.14735428021036998,2.7378911059507551,0.38386752950773262,24.95138941800262,1.0509874949025102]
[null,null,null,null,null,100,{"$f":"EXP(MMULT(It0!G101:H101,B$2:B$3))","v":6.4748214543485982},0.86621754029746978,0.1158847131784711,3.0223654457732843,0.34041843836442098,23.488872247145046,1.0288689252167285]

{"sheet":"It3","index":4,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,10,0,11],[5,0,6,0]]}
["Beta iteration (i-1)",null,null,null,"Beta (iteration i)",null,"exp(X*beta)","Calcolo del vettore p =probabilità stimate dato beta","Calcolo diagonale principale matrice W","Calcolo di z","Calcolo di Xw",null,"Calcolo di zw"]
["beta0",{"$f":"'It2'!E2:E3","v":-5.1811059744453987},null,null,{"$f":"Q4","v":-5.3076729996143142},1,{"$f":"EXP(MMULT(It0!G2:H2,B$2:B$3))","v":4.9065592521326321E-2},{"$f":"G2/(1+G2)","v":4.6770757587618499E-2},{"$f":"H2*(1-H2)","v":4.4583253822298725E-2},{"$f":"MMULT(X,B2:B3)+(y-H2:H101)/I2:I101","v":-4.0636628456654762},{"$f":"SQRT(I2:I101)*X","v":0.21114746937223455},4.2229493874446913,{"$f":"SQRT(I2:I101)*J2:J101","v":-0.85803212624423864},null,null,"Calcolo del nuovo beta"]
["beta1",0.10832543606506241,null,null,{"$f":"P4","v":0.110885411193153},2,{"$f":"EXP(MMULT(It0!G3:H3,B$2:B$3))","v":6.7906674861975061E-2},{"$f":"G3/(1+G3)","v":6.3588585463942221E-2},{"$f":"H3*(1-H3)","v":5.9545077262637136E-2},-3.7575276198109382,0.24401860023907426,5.612427805498708,-0.91690663014592555]
[null,null,null,null,null,3,{"$f":"EXP(MMULT(It0!G4:H4,B$2:B$3))","v":7.567590168740948E-2},{"$f":"G4/(1+G4)","v":7.0351954123632335E-2},6.5402556674618667E-2,-3.6569714105713103,0.25573923569647788,6.1377416567154697,-0.93523107350337753,null,null,{"$f":"LINEST(M2:M101,K2:L101,0,1)","v":0.110885411193153},-5.3076729996143142]
["Iterazione",3,null,null,null,4,{"$f":"EXP(MMULT(It0!G5:H5,B$2:B$3))","v":8.4334008517464046E-2},7.7774936371098599E-2,7.172599564357017E-2,-3.5573040813363024,0.26781709363588085,6.6954273408970213,-0.95270684024254559,null,null,2.400596282161108E-2,1.1299472803262161]
["Criterio di convergenza",null,null,null,null,5,{"$f":"EXP(MMULT(It0!G6:H6,B$2:B$3))","v":8.4334008517464046E-2},7.7774936371098599E-2,7.172599564357017E-2,10.384642503404407,0.26781709363588085,6.6954273408970213,2.7811847737094064,null,null,0.18387969796840067,1.010600824946946]
[null,{"$f":"SUMSQ(E2:E3-B2:B3)/SUMSQ(E2:E3)","v":5.6861845736127538E-4},null,null,null,6,{"$f":"EXP(MMULT(It0!G7:H7,B$2:B$3))","v":9.3982692429642828E-2},8.5908756217079857E-2,7.8528441822314207E-2,-3.4586273291834191,0.28022926653423302,7.2859609298900585,-0.96920859967232287,null,null,11.040167948306683,98]
[null,null,null,null,null,7,{"$f":"EXP(MMULT(It0!G8:H8,B$2:B$3))","v":9.3982692429642828E-2},8.5908756217079857E-2,7.8528441822314207E-2,-3.4586273291834191,0.28022926653423302,7.2859609298900585,-0.96920859967232287,null,null,22.550956780549512,100.0887746835779]
[null,null,null,null,null,8,{"$f":"EXP(MMULT(It0!G9:H9,B$2:B$3))","v":0.11671808699167953},0.10451884710321628,9.3594657703430784E-2,-3.2647118516153304,0.3059324397696831,8.5661083135511262,-0.99878126190967764]
[null,null,null,null,null,9,{"$f":"EXP(MMULT(It0!G10:H10,B$2:B$3))","v":0.11671808699167953},0.10451884710321628,9.3594657703430784E-2,-3.2647118516153304,0.3059324397696831,8.5661083135511262,-0.99878126190967764,null,null,"Regressione di zw su Xw"]
[null,null,null,null,null,10,{"$f":"EXP(MMULT(It0!G11:H11,B$2:B$3))","v":0.1300718448411442},0.11510050925959366,0.10185238202777584,-3.1697401733997328,0.31914319987707063,9.2551527964350484,-1.0116010217176914]
[null,null,null,null,null,11,{"$f":"EXP(MMULT(It0!G12:H12,B$2:B$3))","v":0.14495341087611183},0.12660201672764509,0.11057394608813816,-3.0762963033696384,0.3325266095940867,9.9757982878226006,-1.0229503798663278]
[null,null,null,null,null,12,{"$f":"EXP(MMULT(It0!G13:H13,B$2:B$3))","v":0.14495341087611183},0.12660201672764509,0.11057394608813816,-3.0762963033696384,0.3325266095940867,9.9757982878226006,-1.0229503798663278]
[null,null,null,null,null,13,{"$f":"EXP(MMULT(It0!G14:H14,B$2:B$3))","v":0.14495341087611183},0.12660201672764509,0.11057394608813816,-3.0762963033696384,0.3325266095940867,9.9757982878226006,-1.0229503798663278]
[null,null,null,null,null,14,{"$f":"EXP(MMULT(It0!G15:H15,B$2:B$3))","v":0.14495341087611183},0.12660201672764509,0.11057394608813816,-3.0762963033696384,0.3325266095940867,9.9757982878226006,-1.0229503798663278]
[null,null,null,null,null,15,{"$f":"EXP(MMULT(It0!G16:H16,B$2:B$3))","v":0.14495341087611183},0.12660201672764509,0.11057394608813816,-3.0762963033696384,0.3325266095940867,9.9757982878226006,-1.0229503798663278]
[null,null,null,null,null,16,{"$f":"EXP(MMULT(It0!G17:H17,B$2:B$3))","v":0.14495341087611183},0.12660201672764509,0.11057394608813816,5.9674254355913909,0.3325266095940867,9.9757982878226006,1.9843277481027213]
[null,null,null,null,null,17,{"$f":"EXP(MMULT(It0!G18:H18,B$2:B$3))","v":0.18001915441020511},0.15255612905722865,0.12928275654430285,-2.8947111747736063,0.35955911411658426,11.505891651730696,-1.0408197856249748]
[null,null,null,null,null,18,{"$f":"EXP(MMULT(It0!G19:H19,B$2:B$3))","v":0.18001915441020511},0.15255612905722865,0.12928275654430285,-2.8947111747736063,0.35955911411658426,11.505891651730696,-1.0408197856249748]
[null,null,null,null,null,19,{"$f":"EXP(MMULT(It0!G20:H20,B$2:B$3))","v":0.20061520989927972},0.16709367684598087,0.13917338000407178,-2.8069817941976187,0.37305948587868903,12.310963033996739,-1.0471711850142038]
[null,null,null,null,null,20,{"$f":"EXP(MMULT(It0!G21:H21,B$2:B$3))","v":0.20061520989927972},0.16709367684598087,0.13917338000407178,-2.8069817941976187,0.37305948587868903,12.310963033996739,-1.0471711850142038]
[null,null,null,null,null,21,{"$f":"EXP(MMULT(It0!G22:H22,B$2:B$3))","v":0.22356766742289805},0.18271786136175092,0.14933204450113888,-2.7216088156561744,0.3864350456430406,13.138791551863381,-1.0517250269005953]
[null,null,null,null,null,22,{"$f":"EXP(MMULT(It0!G23:H23,B$2:B$3))","v":0.22356766742289805},0.18271786136175092,0.14933204450113888,-2.7216088156561744,0.3864350456430406,13.138791551863381,-1.0517250269005953]
[null,null,null,null,null,23,{"$f":"EXP(MMULT(It0!G24:H24,B$2:B$3))","v":0.22356766742289805},0.18271786136175092,0.14933204450113888,3.9748775502850182,0.3864350456430406,13.138791551863381,1.5360319875698885]
[null,null,null,null,null,24,{"$f":"EXP(MMULT(It0!G25:H25,B$2:B$3))","v":0.22356766742289805},0.18271786136175092,0.14933204450113888,-2.7216088156561744,0.3864350456430406,13.138791551863381,-1.0517250269005953]
[null,null,null,null,null,25,{"$f":"EXP(MMULT(It0!G26:H26,B$2:B$3))","v":0.22356766742289805},0.18271786136175092,0.14933204450113888,-2.7216088156561744,0.3864350456430406,13.138791551863381,-1.0517250269005953]
[null,null,null,null,null,26,{"$f":"EXP(MMULT(It0!G27:H27,B$2:B$3))","v":0.24914612377600678},0.19945314565990913,0.15967158834627621,-2.6388618359442209,0.39958927456361515,13.98562460972653,-1.0544608866985608]
[null,null,null,null,null,27,{"$f":"EXP(MMULT(It0!G28:H28,B$2:B$3))","v":0.24914612377600678},0.19945314565990913,0.15967158834627621,-2.6388618359442209,0.39958927456361515,13.98562460972653,-1.0544608866985608]
[null,null,null,null,null,28,{"$f":"EXP(MMULT(It0!G29:H29,B$2:B$3))","v":0.27765102041875872},0.21731366075828493,0.17008843360611797,-2.5590412965219107,0.41241779011836766,14.847040444261236,-1.0553941563332088]
[null,null,null,null,null,29,{"$f":"EXP(MMULT(It0!G30:H30,B$2:B$3))","v":0.27765102041875872},0.21731366075828493,0.17008843360611797,3.3202532492538968,0.41241779011836766,14.847040444261236,1.3693315076906218]
[null,null,null,null,null,30,{"$f":"EXP(MMULT(It0!G31:H31,B$2:B$3))","v":0.27765102041875872},0.21731366075828493,0.17008843360611797,-2.5590412965219107,0.41241779011836766,14.847040444261236,-1.0553941563332088]
[null,null,null,null,null,31,{"$f":"EXP(MMULT(It0!G32:H32,B$2:B$3))","v":0.30941717242562949},0.23630144688911459,0.18046307308722553,-2.4824820124637195,0.42480945503510809,15.717949836298999,-1.054581830849171]
[null,null,null,null,null,32,{"$f":"EXP(MMULT(It0!G33:H33,B$2:B$3))","v":0.30941717242562949},0.23630144688911459,0.18046307308722553,3.0588178384850515,0.42480945503510809,15.717949836298999,1.299414739018502]
[null,null,null,null,null,33,{"$f":"EXP(MMULT(It0!G34:H34,B$2:B$3))","v":0.30941717242562949},0.23630144688911459,0.18046307308722553,-2.4824820124637195,0.42480945503510809,15.717949836298999,-1.054581830849171]
[null,null,null,null,null,34,{"$f":"EXP(MMULT(It0!G35:H35,B$2:B$3))","v":0.34481770118286048},0.2564047906861795,0.19066137399935598,-2.4095571051558871,0.43664788331028925,16.59261956579099,-1.0521280096815862]
[null,null,null,null,null,35,{"$f":"EXP(MMULT(It0!G36:H36,B$2:B$3))","v":0.34481770118286048},0.2564047906861795,0.19066137399935598,-2.4095571051558871,0.43664788331028925,16.59261956579099,-1.0521280096815862]
[null,null,null,null,null,36,{"$f":"EXP(MMULT(It0!G37:H37,B$2:B$3))","v":0.38426841702721132},0.27759675240763482,0.20053679546036912,-2.3406823849351763,0.44781334890819091,17.464720607419444,-1.0481888175282326]
[null,null,null,null,null,37,{"$f":"EXP(MMULT(It0!G38:H38,B$2:B$3))","v":0.38426841702721132},0.27759675240763482,0.20053679546036912,2.6459336508118594,0.44781334890819091,17.464720607419444,1.1848844091589346]
[null,null,null,null,null,38,{"$f":"EXP(MMULT(It0!G39:H39,B$2:B$3))","v":0.42823270330397595},0.29983398525557614,0.2099335665413351,-2.2763212351468778,0.45818507891608068,18.327403156643228,-1.0429764247641224]
[null,null,null,null,null,39,{"$f":"EXP(MMULT(It0!G40:H40,B$2:B$3))","v":0.42823270330397595},0.29983398525557614,0.2099335665413351,2.487090431100901,0.45818507891608068,18.327403156643228,1.1395477254453954]
[null,null,null,null,null,40,{"$f":"EXP(MMULT(It0!G41:H41,B$2:B$3))","v":0.4772269592118078},0.32305595036421353,0.21869080329848833,-2.2169900549896475,0.46764388512893906,19.1733992902865,-1.0367618426075791]
[null,null,null,null,null,41,{"$f":"EXP(MMULT(It0!G42:H42,B$2:B$3))","v":0.4772269592118078},0.32305595036421353,0.21869080329848833,-2.2169900549896475,0.46764388512893906,19.1733992902865,-1.0367618426075791]
[null,null,null,null,null,42,{"$f":"EXP(MMULT(It0!G43:H43,B$2:B$3))","v":0.53182666536536316},0.34718462433771169,0.2266474609611937,-2.1632643250781411,0.47607505811709322,19.995152440917916,-1.0298761892842105]
[null,null,null,null,null,43,{"$f":"EXP(MMULT(It0!G44:H44,B$2:B$3))","v":0.53182666536536316},0.34718462433771169,0.2266474609611937,-2.1632643250781411,0.47607505811709322,19.995152440917916,-1.0298761892842105]
[null,null,null,null,null,44,{"$f":"EXP(MMULT(It0!G45:H45,B$2:B$3))","v":0.53182666536536316},0.34718462433771169,0.2266474609611937,-2.1632643250781411,0.47607505811709322,19.995152440917916,-1.0298761892842105]
[null,null,null,null,null,45,{"$f":"EXP(MMULT(It0!G46:H46,B$2:B$3))","v":0.53182666536536316},0.34718462433771169,0.2266474609611937,2.2488742259520809,0.47607505811709322,19.995152440917916,1.0706329278181699]
[null,null,null,null,null,46,{"$f":"EXP(MMULT(It0!G47:H47,B$2:B$3))","v":0.59267314332112042},0.37212478015749628,0.23364792815023133,-2.1157853669688356,0.48337141842503611,20.784970992276552,-1.0227101739146616]
[null,null,null,null,null,47,{"$f":"EXP(MMULT(It0!G48:H48,B$2:B$3))","v":0.59267314332112042},0.37212478015749628,0.23364792815023133,-2.1157853669688356,0.48337141842503611,20.784970992276552,-1.0227101739146616]
[null,null,null,null,null,48,{"$f":"EXP(MMULT(It0!G49:H49,B$2:B$3))","v":0.59267314332112042},0.37212478015749628,0.23364792815023133,2.164158426742095,0.48337141842503611,20.784970992276552,1.046092328430821]
[null,null,null,null,null,49,{"$f":"EXP(MMULT(It0!G50:H50,B$2:B$3))","v":0.66048108846295162},0.3977648966025476,0.23954798363331223,-2.0752678760456043,0.48943639385860166,21.535201329778474,-1.0157116255423602]
[null,null,null,null,null,50,{"$f":"EXP(MMULT(It0!G51:H51,B$2:B$3))","v":0.66048108846295162},0.3977648966025476,0.23954798363331223,-2.0752678760456043,0.48943639385860166,21.535201329778474,-1.0157116255423602]
[null,null,null,null,null,51,{"$f":"EXP(MMULT(It0!G52:H52,B$2:B$3))","v":0.66048108846295162},0.3977648966025476,0.23954798363331223,2.0992611048818612,0.48943639385860166,21.535201329778474,1.0274547849410018]
[null,null,null,null,null,52,{"$f":"EXP(MMULT(It0!G53:H53,B$2:B$3))","v":0.66048108846295162},0.3977648966025476,0.23954798363331223,2.0992611048818612,0.48943639385860166,21.535201329778474,1.0274547849410018]
[null,null,null,null,null,53,{"$f":"EXP(MMULT(It0!G54:H54,B$2:B$3))","v":0.73604696472781783},0.42397871698316486,0.24422076452847427,-2.0425083162454074,0.49418697324846017,22.238413796180708,-1.0093810026401266]
[null,null,null,null,null,54,{"$f":"EXP(MMULT(It0!G55:H55,B$2:B$3))","v":0.73604696472781783},0.42397871698316486,0.24422076452847427,2.0521476067705393,0.49418697324846017,22.238413796180708,1.0141446144490041]
[null,null,null,null,null,55,{"$f":"EXP(MMULT(It0!G56:H56,B$2:B$3))","v":0.82025835977500872},0.450627437237204,0.24756235004623378,-2.0183942752275361,0.4975563787614764,22.887593423027916,-1.0042649464951077]
[null,null,null,null,null,56,{"$f":"EXP(MMULT(It0!G57:H57,B$2:B$3))","v":0.82025835977500872},0.450627437237204,0.24756235004623378,2.0209921654539484,0.4975563787614764,22.887593423027916,1.0055575433485811]
[null,null,null,null,null,57,{"$f":"EXP(MMULT(It0!G58:H58,B$2:B$3))","v":0.91410441048363067},0.47756245974725425,0.2494965567874064,-2.0039148898710968,0.49949630307681597,23.476326244610352,-1.0009480791711978]
[null,null,null,null,null,58,{"$f":"EXP(MMULT(It0!G59:H59,B$2:B$3))","v":0.91410441048363067},0.47756245974725425,0.2494965567874064,-2.0039148898710968,0.49949630307681597,23.476326244610352,-1.0009480791711978]
[null,null,null,null,null,59,{"$f":"EXP(MMULT(It0!G60:H60,B$2:B$3))","v":0.91410441048363067},0.47756245974725425,0.2494965567874064,2.0041564553863465,0.49949630307681597,23.476326244610352,1.0010687402530156]
[null,null,null,null,null,60,{"$f":"EXP(MMULT(It0!G61:H61,B$2:B$3))","v":1.0186874212349661},0.50462860694488654,0.24997857599774975,-2.0001724645573691,0.4999785755387422,23.998971625859625,-1.0000433796612087]
[null,null,null,null,null,61,{"$f":"EXP(MMULT(It0!G62:H62,B$2:B$3))","v":1.0186874212349661},0.50462860694488654,0.24997857599774975,2.0001703488563765,0.4999785755387422,23.998971625859625,1.0000423218560401]
[null,null,null,null,null,62,{"$f":"EXP(MMULT(It0!G63:H63,B$2:B$3))","v":1.0186874212349661},0.50462860694488654,0.24997857599774975,2.0001703488563765,0.4999785755387422,23.998971625859625,1.0000423218560401]
[null,null,null,null,null,63,{"$f":"EXP(MMULT(It0!G64:H64,B$2:B$3))","v":1.1352358114466481},0.5316676525191435,0.24899715978392678,-2.0083954187039885,0.49899615207326675,24.45081145159007,-1.0021815857748677]
[null,null,null,null,null,64,{"$f":"EXP(MMULT(It0!G65:H65,B$2:B$3))","v":1.1352358114466481},0.5316676525191435,0.24899715978392678,-2.0083954187039885,0.49899615207326675,24.45081145159007,-1.0021815857748677]
[null,null,null,null,null,65,{"$f":"EXP(MMULT(It0!G66:H66,B$2:B$3))","v":1.1352358114466481},0.5316676525191435,0.24899715978392678,2.007714648044459,0.49899615207326675,24.45081145159007,1.001841883835318]
[null,null,null,null,null,66,{"$f":"EXP(MMULT(It0!G67:H67,B$2:B$3))","v":1.2651185444388351},0.55852200210221581,{"$f":"H67*(1-H67)","v":0.24657517526994824},-2.0299527156311128,0.49656336480850882,24.828168240425441,-1.0080001508759555]
[null,null,null,null,null,67,{"$f":"EXP(MMULT(It0!G68:H68,B$2:B$3))","v":1.2651185444388351},{"$f":"G68/(1+G68)","v":0.55852200210221581},0.24657517526994824,2.0256055898844734,0.49656336480850882,24.828168240425441,1.0058415274879584]
[null,null,null,null,null,68,{"$f":"EXP(MMULT(It0!G69:H69,B$2:B$3))","v":1.409861207112082},0.58503834285196232,0.24276848024499212,-2.0663699422392976,0.49271541506735117,25.128486168434911,-1.0181323237731339]
[null,null,null,null,null,69,{"$f":"EXP(MMULT(It0!G70:H70,B$2:B$3))","v":1.5711639293068929},0.61107108395474052,0.23766321430911899,-2.1193472283690462,0.48750714282881946,25.350371427098612,-1.0331969119643714]
[null,null,null,null,null,70,{"$f":"EXP(MMULT(It0!G71:H71,B$2:B$3))","v":1.5711639293068929},0.61107108395474052,0.23766321430911899,2.0882875244763821,0.48750714282881946,25.350371427098612,1.0180550844625493]
[null,null,null,null,null,71,{"$f":"EXP(MMULT(It0!G72:H72,B$2:B$3))","v":1.7509213533235619},0.6364854274035,0.23137172810648393,2.1312700166771283,0.48101115174856801,25.493591042674105,1.0251646454090553]
[null,null,null,null,null,72,{"$f":"EXP(MMULT(It0!G73:H73,B$2:B$3))","v":1.7509213533235619},0.6364854274035,0.23137172810648393,2.1312700166771283,0.48101115174856801,25.493591042674105,1.0251646454090553]
[null,null,null,null,null,73,{"$f":"EXP(MMULT(It0!G74:H74,B$2:B$3))","v":1.9512448881618816},0.66115993829884168,0.22402747428751354,2.1809609079983829,0.47331540677175676,25.559031965674865,1.0322823993225545]
[null,null,null,null,null,74,{"$f":"EXP(MMULT(It0!G75:H75,B$2:B$3))","v":2.1744875098763461},0.68498852274931388,0.21577924645102659,-2.397694500743313,0.46452044782875446,25.548624630581497,-1.1137781232418256]
[null,null,null,null,null,75,{"$f":"EXP(MMULT(It0!G76:H76,B$2:B$3))","v":2.1744875098763461},0.68498852274931388,0.21577924645102659,2.2366714841567257,0.46452044782875446,25.548624630581497,1.0389796394662871]
[null,null,null,null,null,76,{"$f":"EXP(MMULT(It0!G77:H77,B$2:B$3))","v":2.1744875098763461},0.68498852274931388,0.21577924645102659,2.2366714841567257,0.46452044782875446,25.548624630581497,1.0389796394662871]
[null,null,null,null,null,77,{"$f":"EXP(MMULT(It0!G78:H78,B$2:B$3))","v":2.4232713993488004},0.70788176473818953,0.20678517188933601,2.2977837373600591,0.45473637625478786,25.46523707026812,1.0448858501442966]
[null,null,null,null,null,78,{"$f":"EXP(MMULT(It0!G79:H79,B$2:B$3))","v":2.4232713993488004},0.70788176473818953,0.20678517188933601,2.2977837373600591,0.45473637625478786,25.46523707026812,1.0448858501442966]
[null,null,null,null,null,79,{"$f":"EXP(MMULT(It0!G80:H80,B$2:B$3))","v":2.4232713993488004},0.70788176473818953,0.20678517188933601,2.2977837373600591,0.45473637625478786,25.46523707026812,1.0448858501442966]
[null,null,null,null,null,80,{"$f":"EXP(MMULT(It0!G81:H81,B$2:B$3))","v":2.7005187421084877},0.72976761646389654,0.19720684242449973,-2.7070748608453292,0.444079770339181,25.312546909333317,-1.2021571824951642]
[null,null,null,null,null,81,{"$f":"EXP(MMULT(It0!G82:H82,B$2:B$3))","v":2.7005187421084877},0.72976761646389654,0.19720684242449973,-2.7070748608453292,0.444079770339181,25.312546909333317,-1.2021571824951642]
[null,null,null,null,null,82,{"$f":"EXP(MMULT(It0!G83:H83,B$2:B$3))","v":2.7005187421084877},0.72976761646389654,0.19720684242449973,2.3637431072626898,0.444079770339181,25.312546909333317,1.0496904962140374]
[null,null,null,null,null,83,{"$f":"EXP(MMULT(It0!G84:H84,B$2:B$3))","v":2.7005187421084877},0.72976761646389654,0.19720684242449973,2.3637431072626898,0.444079770339181,25.312546909333317,1.0496904962140374]
[null,null,null,null,null,84,{"$f":"EXP(MMULT(It0!G85:H85,B$2:B$3))","v":2.7005187421084877},0.72976761646389654,0.19720684242449973,2.3637431072626898,0.444079770339181,25.312546909333317,1.0496904962140374]
[null,null,null,null,null,85,{"$f":"EXP(MMULT(It0!G86:H86,B$2:B$3))","v":2.7005187421084877},0.72976761646389654,0.19720684242449973,2.3637431072626898,0.444079770339181,25.312546909333317,1.0496904962140374]
[null,null,null,null,null,86,{"$f":"EXP(MMULT(It0!G87:H87,B$2:B$3))","v":3.0094860519704856},0.75059147555618899,0.18720391237857192,-2.9077167346422641,0.43267067427614264,25.094899108016275,-1.2580837601816921]
[null,null,null,null,null,87,{"$f":"EXP(MMULT(It0!G88:H88,B$2:B$3))","v":3.0094860519704856},0.75059147555618899,0.18720391237857192,2.4340519671664698,0.43267067427614264,25.094899108016275,1.0531429058570878]
[null,null,null,null,null,88,{"$f":"EXP(MMULT(It0!G89:H89,B$2:B$3))","v":3.0094860519704856},0.75059147555618899,0.18720391237857192,2.4340519671664698,0.43267067427614264,25.094899108016275,1.0531429058570878]
[null,null,null,null,null,89,{"$f":"EXP(MMULT(It0!G90:H90,B$2:B$3))","v":3.3538024216537896},0.77031571413841282,0.17692941468983989,2.5082637789576729,0.42062978340797491,24.81715722107052,1.0550504500730347]
[null,null,null,null,null,90,{"$f":"EXP(MMULT(It0!G91:H91,B$2:B$3))","v":3.3538024216537896},0.77031571413841282,0.17692941468983989,2.5082637789576729,0.42062978340797491,24.81715722107052,1.0550504500730347]
[null,null,null,null,null,91,{"$f":"EXP(MMULT(It0!G92:H92,B$2:B$3))","v":3.7375121496662564},0.7889187471381055,0.16652595755214744,-3.4190919602079095,0.40807592130894887,24.484555278536931,-1.3952491017018627]
[null,null,null,null,null,92,{"$f":"EXP(MMULT(It0!G93:H93,B$2:B$3))","v":3.7375121496662564},0.7889187471381055,0.16652595755214744,2.5859778481242301,0.40807592130894887,24.484555278536931,1.0552752928578284]
[null,null,null,null,null,93,{"$f":"EXP(MMULT(It0!G94:H94,B$2:B$3))","v":4.1651222441465876},0.80639374002556141,0.15612287607314868,2.6668346172463622,0.39512387433961604,24.102556334716578,1.0537300261893896]
[null,null,null,null,null,94,{"$f":"EXP(MMULT(It0!G95:H95,B$2:B$3))","v":4.6416553616377714},0.82274705987894658,0.14583433533949566,2.7505114426785386,0.38188261984475763,23.676722430374973,1.0503725156430643]
[null,null,null,null,null,95,{"$f":"EXP(MMULT(It0!G96:H96,B$2:B$3))","v":4.6416553616377714},0.82274705987894658,0.14583433533949566,2.7505114426785386,0.38188261984475763,23.676722430374973,1.0503725156430643]
[null,null,null,null,null,96,{"$f":"EXP(MMULT(It0!G97:H97,B$2:B$3))","v":5.1727088026044585},0.83799656974291925,0.13575831884201991,2.8367188048161753,0.36845395756053417,23.212599326313654,1.0452002701209082]
[null,null,null,null,null,97,{"$f":"EXP(MMULT(It0!G98:H98,B$2:B$3))","v":5.7645202566484084},0.85216985653680843,0.12597639214684375,-5.0127983229298163,0.35493153163229069,22.715618024466604,-1.7792001865212579]
[null,null,null,null,null,98,{"$f":"EXP(MMULT(It0!G99:H99,B$2:B$3))","v":5.7645202566484084},0.85216985653680843,0.12597639214684375,2.9251969074333064,0.35493153163229069,22.715618024466604,1.0382446186813434]
[null,null,null,null,null,99,{"$f":"EXP(MMULT(It0!G100:H100,B$2:B$3))","v":6.4240410696574841},0.86530246928629451,0.11655410593333586,3.0157126261474869,0.34140021372772433,22.191013892302081,1.0295649351081488]
[null,null,null,null,null,100,{"$f":"EXP(MMULT(It0!G101:H101,B$2:B$3))","v":9.9080654169615556},0.90832471554075533,8.3270926678561244E-2,3.3942769902656478,0.28856702285355001,19.911124576894952,0.97947640582126616]

{"sheet":"It4","index":5,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,10,0,11],[5,0,6,0]]}
["Beta iteration (i-1)",null,null,null,"Beta (iteration i)",null,"exp(X*beta)","Calcolo del vettore p =probabilità stimate dato beta","Calcolo diagonale principale matrice W","Calcolo di z","Calcolo di Xw",null,"Calcolo di zw"]
["beta0",{"$f":"'It3'!E2:E3","v":-5.3076729996143142},null,null,{"$f":"Q4","v":-5.3094530241517184},1,{"$f":"EXP(MMULT(It0!G2:H2,B$2:B$3))","v":4.5503557205010495E-2},{"$f":"G2/(1+G2)","v":4.3523101276342964E-2},{"$f":"H2*(1-H2)","v":4.1628840931632161E-2},{"$f":"MMULT(X,B2:B3)+(y-H2:H101)/I2:I101","v":-4.1354683329562647},{"$f":"SQRT(I2:I101)*X","v":0.20403147044422379},4.0806294088844757,{"$f":"SQRT(I2:I101)*J2:J101","v":-0.8437656849485895},null,null,"Calcolo del nuovo beta"]
["beta1",0.110885411193153,null,null,{"$f":"P4","v":0.11092113522336045},2,{"$f":"EXP(MMULT(It0!G3:H3,B$2:B$3))","v":6.3462344931907971E-2},{"$f":"G3/(1+G3)","v":5.9675215802747934E-2},{"$f":"H3*(1-H3)","v":5.6114084421643395E-2},-3.8207708871037029,0.23688411601802978,5.4483346684146845,-0.90507993409898413]
[null,null,null,null,null,3,{"$f":"EXP(MMULT(It0!G4:H4,B$2:B$3))","v":7.090437569061811E-2},{"$f":"G4/(1+G4)","v":6.620981041831342E-2},6.1826071422684419E-2,-3.7173275066692604,0.24864848968510631,5.9675637524425511,-0.92430787019821348,null,null,{"$f":"LINEST(M2:M101,K2:L101,0,1)","v":0.11092113522336045},-5.3094530241517184]
["Iterazione",4,null,null,null,4,{"$f":"EXP(MMULT(It0!G5:H5,B$2:B$3))","v":7.9219110126965919E-2},7.3404102451119585E-2,6.8015940194465122E-2,-3.6147568299124551,0.26079865834483335,6.5199664586208339,-0.94272373148399125,null,null,2.4531547598127555E-2,1.1558630301926947]
["Criterio di convergenza",null,null,null,null,5,{"$f":"EXP(MMULT(It0!G6:H6,B$2:B$3))","v":7.9219110126965919E-2},7.3404102451119585E-2,6.8015940194465122E-2,11.087679057041235,0.26079865834483335,6.5199664586208339,2.8916518222344609,null,null,0.1772963514584423,1.0197865498785963]
[null,{"$f":"SUMSQ(E2:E3-B2:B3)/SUMSQ(E2:E3)","v":1.1239262095459367E-7},null,null,null,6,{"$f":"EXP(MMULT(It0!G7:H7,B$2:B$3))","v":8.8508887472493969E-2},8.131204851988913E-2,7.4700399285388325E-2,-3.5131611960648303,0.27331373782777241,7.1061571835220825,-0.96019521808796637,null,null,10.559721276141678,98]
[null,null,null,null,null,7,{"$f":"EXP(MMULT(It0!G8:H8,B$2:B$3))","v":8.8508887472493969E-2},8.131204851988913E-2,7.4700399285388325E-2,-3.5131611960648303,0.27331373782777241,7.1061571835220825,-0.96019521808796637,null,null,21.963472780560963,101.91653151670249]
[null,null,null,null,null,8,{"$f":"EXP(MMULT(It0!G9:H9,B$2:B$3))","v":0.11048434014566963},9.9492028974651425E-2,8.9593365145158546E-2,-3.3133658263517001,0.2993215079895839,8.3810022237083501,-0.99176165566474461]
[null,null,null,null,null,9,{"$f":"EXP(MMULT(It0!G10:H10,B$2:B$3))","v":0.11048434014566963},9.9492028974651425E-2,8.9593365145158546E-2,-3.3133658263517001,0.2993215079895839,8.3810022237083501,-0.99176165566474461,null,null,"Regressione di zw su Xw"]
[null,null,null,null,null,10,{"$f":"EXP(MMULT(It0!G11:H11,B$2:B$3))","v":0.12344049325665342},0.10987719776667605,9.7804199177618817E-2,-3.2154365682695305,0.31273662909486444,9.069362243751069,-1.0055847934289719]
[null,null,null,null,null,11,{"$f":"EXP(MMULT(It0!G12:H12,B$2:B$3))","v":0.13791597393219462},0.12120049027487566,0.10651093143200542,-3.1190266377519187,0.32636012537074044,9.7908037611222127,-1.0179259245313952]
[null,null,null,null,null,12,{"$f":"EXP(MMULT(It0!G13:H13,B$2:B$3))","v":0.13791597393219462},0.12120049027487566,0.10651093143200542,-3.1190266377519187,0.32636012537074044,9.7908037611222127,-1.0179259245313952]
[null,null,null,null,null,13,{"$f":"EXP(MMULT(It0!G14:H14,B$2:B$3))","v":0.13791597393219462},0.12120049027487566,0.10651093143200542,-3.1190266377519187,0.32636012537074044,9.7908037611222127,-1.0179259245313952]
[null,null,null,null,null,14,{"$f":"EXP(MMULT(It0!G15:H15,B$2:B$3))","v":0.13791597393219462},0.12120049027487566,0.10651093143200542,-3.1190266377519187,0.32636012537074044,9.7908037611222127,-1.0179259245313952]
[null,null,null,null,null,15,{"$f":"EXP(MMULT(It0!G16:H16,B$2:B$3))","v":0.13791597393219462},0.12120049027487566,0.10651093143200542,-3.1190266377519187,0.32636012537074044,9.7908037611222127,-1.0179259245313952]
[null,null,null,null,null,16,{"$f":"EXP(MMULT(It0!G17:H17,B$2:B$3))","v":0.13791597393219462},0.12120049027487566,0.10651093143200542,6.2696810428149465,0.32636012537074044,9.7908037611222127,2.0461738911676406]
[null,null,null,null,null,17,{"$f":"EXP(MMULT(It0!G18:H18,B$2:B$3))","v":0.1721584782113694},0.14687303927884479,0.12530134961183972,-2.9314983196447875,0.35397930675653871,11.327337816209239,-1.0376897429458201]
[null,null,null,null,null,18,{"$f":"EXP(MMULT(It0!G19:H19,B$2:B$3))","v":0.1721584782113694},0.14687303927884479,0.12530134961183972,-2.9314983196447875,0.35397930675653871,11.327337816209239,-1.0376897429458201]
[null,null,null,null,null,19,{"$f":"EXP(MMULT(It0!G20:H20,B$2:B$3))","v":0.19234696465315487},0.16131794717077777,0.13529446709138393,-2.8408013948934201,0.36782396209516305,12.13819074914038,-1.0449148245951636]
[null,null,null,null,null,20,{"$f":"EXP(MMULT(It0!G21:H21,B$2:B$3))","v":0.19234696465315487},0.16131794717077777,0.13529446709138393,-2.8408013948934201,0.36782396209516305,12.13819074914038,-1.0449148245951636]
[null,null,null,null,null,21,{"$f":"EXP(MMULT(It0!G22:H22,B$2:B$3))","v":0.21490289177543798},0.17688894579992534,0.14559924665371643,-2.7524719108225502,0.38157469341364403,12.973539576063898,-1.0502736255017815]
[null,null,null,null,null,22,{"$f":"EXP(MMULT(It0!G23:H23,B$2:B$3))","v":0.21490289177543798},0.17688894579992534,0.14559924665371643,-2.7524719108225502,0.38157469341364403,12.973539576063898,-1.0502736255017815]
[null,null,null,null,null,23,{"$f":"EXP(MMULT(It0!G24:H24,B$2:B$3))","v":0.21490289177543798},0.17688894579992534,0.14559924665371643,4.115695493768035,0.38157469341364403,12.973539576063898,1.5704452462184542]
[null,null,null,null,null,24,{"$f":"EXP(MMULT(It0!G25:H25,B$2:B$3))","v":0.21490289177543798},0.17688894579992534,0.14559924665371643,-2.7524719108225502,0.38157469341364403,12.973539576063898,-1.0502736255017815]
[null,null,null,null,null,25,{"$f":"EXP(MMULT(It0!G26:H26,B$2:B$3))","v":0.21490289177543798},0.17688894579992534,0.14559924665371643,-2.7524719108225502,0.38157469341364403,12.973539576063898,-1.0502736255017815]
[null,null,null,null,null,26,{"$f":"EXP(MMULT(It0!G27:H27,B$2:B$3))","v":0.2401038819444043},0.19361594253534359,0.15612880933149412,-2.6667874897983639,0.39513138236730089,13.829598382855531,-1.0537314273238518]
[null,null,null,null,null,27,{"$f":"EXP(MMULT(It0!G28:H28,B$2:B$3))","v":0.2401038819444043},0.19361594253534359,0.15612880933149412,-2.6667874897983639,0.39513138236730089,13.829598382855531,-1.0537314273238518]
[null,null,null,null,null,28,{"$f":"EXP(MMULT(It0!G29:H29,B$2:B$3))","v":0.26826011343306388},0.21151821348927258,0.1667782588515791,-2.5840583100938703,0.40838493955039418,14.701857823814191,-1.0552904967623791]
[null,null,null,null,null,29,{"$f":"EXP(MMULT(It0!G30:H30,B$2:B$3))","v":0.26826011343306388},0.21151821348927258,0.1667782588515791,3.411927059257716,0.40838493955039418,14.701857823814191,1.3933796258453166]
[null,null,null,null,null,30,{"$f":"EXP(MMULT(It0!G31:H31,B$2:B$3))","v":0.26826011343306388},0.21151821348927258,0.1667782588515791,-2.5840583100938703,0.40838493955039418,14.701857823814191,-1.0552904967623791]
[null,null,null,null,null,31,{"$f":"EXP(MMULT(It0!G32:H32,B$2:B$3))","v":0.29971813815065002},0.23060241244083474,0.17742493981730187,-2.5046309236183033,0.42121839919132437,15.585080770079001,-1.0549966282115899]
[null,null,null,null,null,32,{"$f":"EXP(MMULT(It0!G33:H33,B$2:B$3))","v":0.29971813815065002},0.23060241244083474,0.17742493981730187,3.1315552914071638,0.42121839919132437,15.585080770079001,1.3190687068256468]
[null,null,null,null,null,33,{"$f":"EXP(MMULT(It0!G34:H34,B$2:B$3))","v":0.29971813815065002},0.23060241244083474,0.17742493981730187,-2.5046309236183033,0.42121839919132437,15.585080770079001,-1.0549966282115899]
[null,null,null,null,null,34,{"$f":"EXP(MMULT(It0!G35:H35,B$2:B$3))","v":0.33486514706520715},0.25086065645015243,0.18792958749555103,-2.4288925213397068,0.43350846300337786,16.473321594128358,-1.0529454637263755]
[null,null,null,null,null,35,{"$f":"EXP(MMULT(It0!G36:H36,B$2:B$3))","v":0.33486514706520715},0.25086065645015243,0.18792958749555103,-2.4288925213397068,0.43350846300337786,16.473321594128358,-1.0529454637263755]
[null,null,null,null,null,36,{"$f":"EXP(MMULT(It0!G37:H37,B$2:B$3))","v":0.37413373581894982},0.27226879456239778,0.19813849806993661,-2.3572756989002968,0.44512750765363468,17.359972798491754,-1.049288256703969]
[null,null,null,null,null,37,{"$f":"EXP(MMULT(It0!G38:H38,B$2:B$3))","v":0.37413373581894982},0.27226879456239778,0.19813849806993661,2.6896990674423433,0.44512750765363468,17.359972798491754,1.1972590422289158]
[null,null,null,null,null,38,{"$f":"EXP(MMULT(It0!G39:H39,B$2:B$3))","v":0.41800722919243277},0.29478497752828203,0.20788679455193229,-2.2902637810806268,0.45594604346559725,18.237841738623889,-1.0442367094762706]
[null,null,null,null,null,39,{"$f":"EXP(MMULT(It0!G40:H40,B$2:B$3))","v":0.41800722919243277},0.29478497752828203,0.20788679455193229,2.5200465715098046,0.45594604346559725,18.237841738623889,1.1490052636289387]
[null,null,null,null,null,40,{"$f":"EXP(MMULT(It0!G41:H41,B$2:B$3))","v":0.46702562995198621},0.31834865077801766,0.21700278732583342,-2.2283967706470271,0.46583557971223433,19.099258768201608,-1.0380665014832287]
[null,null,null,null,null,41,{"$f":"EXP(MMULT(It0!G42:H42,B$2:B$3))","v":0.46702562995198621},0.31834865077801766,0.21700278732583342,-2.2283967706470271,0.46583557971223433,19.099258768201608,-1.0380665014832287]
[null,null,null,null,null,42,{"$f":"EXP(MMULT(It0!G43:H43,B$2:B$3))","v":0.52179226529988942},0.3428800876426214,0.22531333314080965,-2.1722779948017776,0.47467181624866844,19.936216282444075,-1.0311191411895753]
[null,null,null,null,null,43,{"$f":"EXP(MMULT(It0!G44:H44,B$2:B$3))","v":0.52179226529988942},0.3428800876426214,0.22531333314080965,-2.1722779948017776,0.47467181624866844,19.936216282444075,-1.0311191411895753]
[null,null,null,null,null,44,{"$f":"EXP(MMULT(It0!G45:H45,B$2:B$3))","v":0.52179226529988942},0.3428800876426214,0.22531333314080965,-2.1722779948017776,0.47467181624866844,19.936216282444075,-1.0311191411895753]
[null,null,null,null,null,45,{"$f":"EXP(MMULT(It0!G46:H46,B$2:B$3))","v":0.52179226529988942},0.3428800876426214,0.22531333314080965,2.265985760211112,0.47467181624866844,19.936216282444075,1.0755995763930282]
[null,null,null,null,null,46,{"$f":"EXP(MMULT(It0!G47:H47,B$2:B$3))","v":0.58298121273297421},0.36828056330906983,0.23264998999782405,-2.1225815310417095,0.48233804535597652,20.740535950306992,-1.0238018267913542]
[null,null,null,null,null,47,{"$f":"EXP(MMULT(It0!G48:H48,B$2:B$3))","v":0.58298121273297421},0.36828056330906983,0.23264998999782405,-2.1225815310417095,0.48233804535597652,20.740535950306992,-1.0238018267913542]
[null,null,null,null,null,48,{"$f":"EXP(MMULT(It0!G49:H49,B$2:B$3))","v":0.58298121273297421},0.36828056330906983,0.23264998999782405,2.1757208243951123,0.48233804535597652,20.740535950306992,1.0494329296790323]
[null,null,null,null,null,49,{"$f":"EXP(MMULT(It0!G50:H50,B$2:B$3))","v":0.65134559670844805},0.39443324159809162,0.23885565952051313,-2.0800605038240301,0.48872861540993601,21.504059078037184,-1.0165850900028122]
[null,null,null,null,null,50,{"$f":"EXP(MMULT(It0!G51:H51,B$2:B$3))","v":0.65134559670844805},0.39443324159809162,0.23885565952051313,-2.0800605038240301,0.48872861540993601,21.504059078037184,-1.0165850900028122]
[null,null,null,null,null,51,{"$f":"EXP(MMULT(It0!G52:H52,B$2:B$3))","v":0.65134559670844805},0.39443324159809162,0.23885565952051313,2.1065683665466097,0.48872861540993601,21.504059078037184,1.0295402410486951]
[null,null,null,null,null,52,{"$f":"EXP(MMULT(It0!G53:H53,B$2:B$3))","v":0.65134559670844805},0.39443324159809162,0.23885565952051313,2.1065683665466097,0.48872861540993601,21.504059078037184,1.0295402410486951]
[null,null,null,null,null,53,{"$f":"EXP(MMULT(It0!G54:H54,B$2:B$3))","v":0.72772685823377659},0.42120480720993037,0.24379131759317577,-2.0455563541562056,0.49375228363337803,22.21885276350201,-1.0099981211653934]
[null,null,null,null,null,54,{"$f":"EXP(MMULT(It0!G55:H55,B$2:B$3))","v":0.72772685823377659},0.42120480720993037,0.24379131759317577,2.056312448525027,0.49375228363337803,22.21885276350201,1.0153089673229752]
[null,null,null,null,null,55,{"$f":"EXP(MMULT(It0!G56:H56,B$2:B$3))","v":0.81306511147238769},0.44844782811583561,0.24734237357402558,-2.0200091962016637,0.49733527280299111,22.877422548937592,-1.0046218246575052]
[null,null,null,null,null,56,{"$f":"EXP(MMULT(It0!G57:H57,B$2:B$3))","v":0.81306511147238769},0.44844782811583561,0.24734237357402558,2.0229697141657352,0.49733527280299111,22.877422548937592,1.0060941946668049]
[null,null,null,null,null,57,{"$f":"EXP(MMULT(It0!G58:H58,B$2:B$3))","v":0.908410714836144},0.47600378040957503,0.2494241814453681,-2.0044693883722671,0.4994238494959648,23.472920926310344,-1.0010798181376996]
[null,null,null,null,null,58,{"$f":"EXP(MMULT(It0!G59:H59,B$2:B$3))","v":0.908410714836144},0.47600378040957503,0.2494241814453681,-2.0044693883722671,0.4994238494959648,23.472920926310344,-1.0010798181376996]
[null,null,null,null,null,59,{"$f":"EXP(MMULT(It0!G60:H60,B$2:B$3))","v":0.908410714836144},0.47600378040957503,0.2494241814453681,2.0047649777793248,0.4994238494959648,23.472920926310344,1.0012274425372427]
[null,null,null,null,null,60,{"$f":"EXP(MMULT(It0!G61:H61,B$2:B$3))","v":1.0149371989836498},0.50370661651171666,0.24998626099403506,-2.0001104613266198,0.49998626080526959,23.999340518652939,-1.0000277507561994]
[null,null,null,null,null,61,{"$f":"EXP(MMULT(It0!G62:H62,B$2:B$3))","v":1.0149371989836498},0.50370661651171666,0.24998626099403506,2.0001093748501413,0.49998626080526959,23.999340518652939,1.0000272075328875]
[null,null,null,null,null,62,{"$f":"EXP(MMULT(It0!G63:H63,B$2:B$3))","v":1.0149371989836498},0.50370661651171666,0.24998626099403506,2.0001093748501413,0.49998626080526959,23.999340518652939,1.0000272075328875]
[null,null,null,null,null,63,{"$f":"EXP(MMULT(It0!G64:H64,B$2:B$3))","v":1.1339557108444964},0.53138671298653251,0.24901487424790103,-2.0082435619943135,0.49901390185835609,24.45168119105945,-1.0021414557527057]
[null,null,null,null,null,64,{"$f":"EXP(MMULT(It0!G65:H65,B$2:B$3))","v":1.1339557108444964},0.53138671298653251,0.24901487424790103,-2.0082435619943135,0.49901390185835609,24.45168119105945,-1.0021414557527057]
[null,null,null,null,null,65,{"$f":"EXP(MMULT(It0!G66:H66,B$2:B$3))","v":1.1339557108444964},0.53138671298653251,0.24901487424790103,2.0075808060089928,0.49901390185835609,24.45168119105945,1.0018107313024909]
[null,null,null,null,null,66,{"$f":"EXP(MMULT(It0!G67:H67,B$2:B$3))","v":1.2669311514490678},0.55887500184521255,{"$f":"H67*(1-H67)","v":0.24653373415772623},-2.0303335914057312,0.49652163513559633,24.826081756779818,-1.0081045546755014]
[null,null,null,null,null,67,{"$f":"EXP(MMULT(It0!G68:H68,B$2:B$3))","v":1.2669311514490678},{"$f":"G68/(1+G68)","v":0.55887500184521255},0.24653373415772623,2.0259064335809693,0.49652163513559633,24.826081756779818,1.0059063750333472]
[null,null,null,null,null,68,{"$f":"EXP(MMULT(It0!G69:H69,B$2:B$3))","v":1.4155002061911888},0.58600707321949652,0.24260278335621616,-2.0680172349547004,0.49254723972043146,25.119909225742006,-1.0185961807712167]
[null,null,null,null,null,69,{"$f":"EXP(MMULT(It0!G70:H70,B$2:B$3))","v":1.5814914894432972},0.61262703979874378,0.2373151499061722,-2.1231231070136554,0.48715002812908897,25.331801462712626,-1.034279481303221]
[null,null,null,null,null,70,{"$f":"EXP(MMULT(It0!G71:H71,B$2:B$3))","v":1.5814914894432972},0.61262703979874378,0.2373151499061722,2.0906828821757082,0.48715002812908897,25.331801462712626,1.0184762248609009]
[null,null,null,null,null,71,{"$f":"EXP(MMULT(It0!G72:H72,B$2:B$3))","v":1.7669480514676508},0.63859097409885313,0.23079254189833101,2.1352013884993886,0.48040872379499,25.461662361134469,1.0257693740942819]
[null,null,null,null,null,72,{"$f":"EXP(MMULT(It0!G73:H73,B$2:B$3))","v":1.7669480514676508},0.63859097409885313,0.23079254189833101,2.1352013884993886,0.48040872379499,25.461662361134469,1.0257693740942819]
[null,null,null,null,null,73,{"$f":"EXP(MMULT(It0!G74:H74,B$2:B$3))","v":1.9741525246426361},0.66376976576876923,0.22317946382004247,2.1866856785647384,0.47241873779523447,25.510611840942662,1.0330312882224695]
[null,null,null,null,null,74,{"$f":"EXP(MMULT(It0!G75:H75,B$2:B$3))","v":2.2056552185084115},0.68805129315644276,0.21463671114218963,-2.4146306024993112,0.46328901470053185,25.480895808529251,-1.1186718326976575]
[null,null,null,null,null,75,{"$f":"EXP(MMULT(It0!G76:H76,B$2:B$3))","v":2.2056552185084115},0.68805129315644276,0.21463671114218963,2.2444046327989673,0.46328901470053185,25.480895808529251,1.0398080109187426]
[null,null,null,null,null,76,{"$f":"EXP(MMULT(It0!G77:H77,B$2:B$3))","v":2.2056552185084115},0.68805129315644276,0.21463671114218963,2.2444046327989673,0.46328901470053185,25.480895808529251,1.0398080109187426]
[null,null,null,null,null,77,{"$f":"EXP(MMULT(It0!G78:H78,B$2:B$3))","v":2.4643055094307078},0.7113418555962373,0.20533462007313918,2.3077038689857003,0.45313863228943435,25.375763408208325,1.0457097749212163]
[null,null,null,null,null,78,{"$f":"EXP(MMULT(It0!G79:H79,B$2:B$3))","v":2.4643055094307078},0.7113418555962373,0.20533462007313918,2.3077038689857003,0.45313863228943435,25.375763408208325,1.0457097749212163]
[null,null,null,null,null,79,{"$f":"EXP(MMULT(It0!G80:H80,B$2:B$3))","v":2.4643055094307078},0.7113418555962373,0.20533462007313918,2.3077038689857003,0.45313863228943435,25.375763408208325,1.0457097749212163]
[null,null,null,null,null,80,{"$f":"EXP(MMULT(It0!G81:H81,B$2:B$3))","v":2.753286911232351},0.73356686455082087,0.19544651978389849,-2.7404914728369438,0.44209333831658049,25.199320284045086,-1.2115530238546071]
[null,null,null,null,null,81,{"$f":"EXP(MMULT(It0!G82:H82,B$2:B$3))","v":2.753286911232351},0.73356686455082087,0.19544651978389849,-2.7404914728369438,0.44209333831658049,25.199320284045086,-1.2115530238546071]
[null,null,null,null,null,82,{"$f":"EXP(MMULT(It0!G83:H83,B$2:B$3))","v":2.753286911232351},0.73356686455082087,0.19544651978389849,2.3759976880121778,0.44209333831658049,25.199320284045086,1.0504127497257807]
[null,null,null,null,null,83,{"$f":"EXP(MMULT(It0!G84:H84,B$2:B$3))","v":2.753286911232351},0.73356686455082087,0.19544651978389849,2.3759976880121778,0.44209333831658049,25.199320284045086,1.0504127497257807]
[null,null,null,null,null,84,{"$f":"EXP(MMULT(It0!G85:H85,B$2:B$3))","v":2.753286911232351},0.73356686455082087,0.19544651978389849,2.3759976880121778,0.44209333831658049,25.199320284045086,1.0504127497257807]
[null,null,null,null,null,85,{"$f":"EXP(MMULT(It0!G86:H86,B$2:B$3))","v":2.753286911232351},0.73356686455082087,0.19544651978389849,2.3759976880121778,0.44209333831658049,25.199320284045086,1.0504127497257807]
[null,null,null,null,null,86,{"$f":"EXP(MMULT(It0!G87:H87,B$2:B$3))","v":3.0761562584480893},0.75467083777089339,0.18514276438907129,-2.9524754088595317,0.43028219157788916,24.956367111517572,-1.2703975895039037]
[null,null,null,null,null,87,{"$f":"EXP(MMULT(It0!G88:H88,B$2:B$3))","v":3.0761562584480893},0.75467083777089339,0.18514276438907129,2.4487618649803125,0.43028219157788916,24.956367111517572,1.0536586219160879]
[null,null,null,null,null,88,{"$f":"EXP(MMULT(It0!G89:H89,B$2:B$3))","v":3.0761562584480893},0.75467083777089339,0.18514276438907129,2.4487618649803125,0.43028219157788916,24.956367111517572,1.0536586219160879]
[null,null,null,null,null,89,{"$f":"EXP(MMULT(It0!G90:H90,B$2:B$3))","v":3.4368874844771979},0.77461677730197587,0.17458562562427699,2.5255271969533304,0.4178344476276184,24.652232410029484,1.0552522613075221]
[null,null,null,null,null,90,{"$f":"EXP(MMULT(It0!G91:H91,B$2:B$3))","v":3.4368874844771979},0.77461677730197587,0.17458562562427699,2.5255271969533304,0.4178344476276184,24.652232410029484,1.0552522613075221]
[null,null,null,null,null,91,{"$f":"EXP(MMULT(It0!G92:H92,B$2:B$3))","v":3.8399205334631521},0.79338503740174826,0.16392521982877478,-3.4944688614882873,0.40487679586359943,24.292607751815964,-1.414829355884498]
[null,null,null,null,null,92,{"$f":"EXP(MMULT(It0!G93:H93,B$2:B$3))","v":3.8399205334631521},0.79338503740174826,0.16392521982877478,2.6058737279224973,0.40487679586359943,24.292607751815964,1.0550578053863937]
[null,null,null,null,null,93,{"$f":"EXP(MMULT(It0!G94:H94,B$2:B$3))","v":4.2902160079164977},0.81097180181233453,0.15329653847759014,2.6894255799138129,0.39153101853823807,23.883392130832522,1.0529935365864467]
[null,null,null,null,null,94,{"$f":"EXP(MMULT(It0!G95:H95,B$2:B$3))","v":4.7933162246935845},0.82738729231841801,0.14281756082841471,2.7758463266149942,0.37791210727947672,23.430550651327557,1.049025934775067]
[null,null,null,null,null,95,{"$f":"EXP(MMULT(It0!G96:H96,B$2:B$3))","v":4.7933162246935845},0.82738729231841801,0.14281756082841471,2.7758463266149942,0.37791210727947672,23.430550651327557,1.049025934775067]
[null,null,null,null,null,96,{"$f":"EXP(MMULT(It0!G97:H97,B$2:B$3))","v":5.3554134308190164},0.84265382403751332,0.13258835687246887,2.8648348525805352,0.36412684173577325,22.939991029353713,1.0431632669647197]
[null,null,null,null,null,97,{"$f":"EXP(MMULT(It0!G98:H98,B$2:B$3))","v":5.9834260187643107},0.85680380986166071,0.12269104126820386,-5.1944327020168339,0.35027280977575731,22.417459825648468,-1.8194685377265156]
[null,null,null,null,null,98,{"$f":"EXP(MMULT(It0!G99:H99,B$2:B$3))","v":5.9834260187643107},0.85680380986166071,0.12269104126820386,2.9561216470492067,0.35027280977575731,22.417459825648468,1.0354490353508652]
[null,null,null,null,null,99,{"$f":"EXP(MMULT(It0!G100:H100,B$2:B$3))","v":6.6850836792539727},0.86987779941817434,0.1131904134975688,3.0494654867576267,0.33643783006310213,21.868458954101637,1.0259555512170575]
[null,null,null,null,null,100,{"$f":"EXP(MMULT(It0!G101:H101,B$2:B$3))","v":10.416805055074899},0.91240982085828914,7.9918139659633861E-2,3.4394190973426157,0.28269796543242731,19.506159614837486,0.97231678108819308]

{"sheet":"It5","index":6,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,10,0,11],[5,0,6,0]]}
["Beta iteration (i-1)",null,null,null,"Beta (iteration i)",null,"exp(X*beta)","Calcolo del vettore p =probabilità stimate dato beta","Calcolo diagonale principale matrice W","Calcolo di z","Calcolo di Xw",null,"Calcolo di zw"]
["beta0",{"$f":"'It4'!E2:E3","v":-5.3094530241517184},null,null,{"$f":"Q4","v":-5.3094533739190437},1,{"$f":"EXP(MMULT(It0!G2:H2,B$2:B$3))","v":4.5455096988519079E-2},{"$f":"G2/(1+G2)","v":4.3478765486393969E-2},{"$f":"H2*(1-H2)","v":4.1588362438173127E-2},{"$f":"MMULT(X,B2:B3)+(y-H2:H101)/I2:I101","v":-4.1364854166730289},{"$f":"SQRT(I2:I101)*X","v":0.20393224962759846},4.0786449925519692,{"$f":"SQRT(I2:I101)*J2:J101","v":-0.84356277657388479},null,null,"Calcolo del nuovo beta"]
["beta1",0.11092113522336045,null,null,{"$f":"P4","v":0.11092114220689984},2,{"$f":"EXP(MMULT(It0!G3:H3,B$2:B$3))","v":6.3401553542488678E-2},{"$f":"G3/(1+G3)","v":5.9621460332910298E-2},{"$f":"H3*(1-H3)","v":5.6066741800681504E-2},-3.8216684675569166,0.23678416712415867,5.4460358438556495,-0.90491058511512434]
[null,null,null,null,null,3,{"$f":"EXP(MMULT(It0!G4:H4,B$2:B$3))","v":7.0838986093918657E-2},{"$f":"G4/(1+G4)","v":6.615278955458731E-2},6.1776597988733799E-2,-3.7181847648849864,0.24854898508892326,5.9651756421341577,-0.92415104968526007,null,null,{"$f":"LINEST(M2:M101,K2:L101,0,1)","v":0.11092114220689984},-5.3094533739190437]
["Iterazione",5,null,null,null,4,{"$f":"EXP(MMULT(It0!G5:H5,B$2:B$3))","v":7.9148879963193169E-2},7.3343800315942245E-2,6.7964487271157434E-2,-3.6155735235309008,0.26069999476631645,6.5174998691579109,-0.94257999866173814,null,null,2.4539072277191192E-2,1.1562353594810411]
["Criterio di convergenza",null,null,null,null,5,{"$f":"EXP(MMULT(It0!G6:H6,B$2:B$3))","v":7.9148879963193169E-2},7.3343800315942245E-2,6.7964487271157434E-2,11.097992930819105,0.26069999476631645,6.5174998691579109,2.8932466989811574,null,null,0.1772028987570374,1.0199185587636599]
[null,{"$f":"SUMSQ(E2:E3-B2:B3)/SUMSQ(E2:E3)","v":4.3395274774096216E-15},null,null,null,6,{"$f":"EXP(MMULT(It0!G7:H7,B$2:B$3))","v":8.8433580784490595E-2},8.1248486215164298E-2,7.464716970290855E-2,-3.513937089128838,0.27321634230570568,7.1036248999483478,-0.96006503858413961,null,null,10.552956525950204,98]
[null,null,null,null,null,7,{"$f":"EXP(MMULT(It0!G8:H8,B$2:B$3))","v":8.8433580784490595E-2},8.1248486215164298E-2,7.464716970290855E-2,-3.513937089128838,0.27321634230570568,7.1036248999483478,-0.96006503858413961,null,null,21.955085540213659,101.94291891803304]
[null,null,null,null,null,8,{"$f":"EXP(MMULT(It0!G9:H9,B$2:B$3))","v":0.11039822337375883},9.9422190210582601E-2,8.9537418304313332E-2,-3.314059461271385,0.29922803729649622,8.3783850443018935,-0.99165950808012016]
[null,null,null,null,null,9,{"$f":"EXP(MMULT(It0!G10:H10,B$2:B$3))","v":0.11039822337375883},9.9422190210582601E-2,8.9537418304313332E-2,-3.314059461271385,0.29922803729649622,8.3783850443018935,-0.99165950808012016,null,null,"Regressione di zw su Xw"]
[null,null,null,null,null,10,{"$f":"EXP(MMULT(It0!G11:H11,B$2:B$3))","v":0.12334868427358181},0.10980444985640925,9.774743264814055E-2,-3.2160887869478474,0.31264585819764279,9.0667298877316416,-1.0054968388351258]
[null,null,null,null,null,11,{"$f":"EXP(MMULT(It0!G12:H12,B$2:B$3))","v":0.13781832213470463},0.12112506843459717,0.10645378623131133,-3.1196372895856093,0.32627256432515334,9.7881769297546004,-1.0178520582374677]
[null,null,null,null,null,12,{"$f":"EXP(MMULT(It0!G13:H13,B$2:B$3))","v":0.13781832213470463},0.12112506843459717,0.10645378623131133,-3.1196372895856093,0.32627256432515334,9.7881769297546004,-1.0178520582374677]
[null,null,null,null,null,13,{"$f":"EXP(MMULT(It0!G14:H14,B$2:B$3))","v":0.13781832213470463},0.12112506843459717,0.10645378623131133,-3.1196372895856093,0.32627256432515334,9.7881769297546004,-1.0178520582374677]
[null,null,null,null,null,14,{"$f":"EXP(MMULT(It0!G15:H15,B$2:B$3))","v":0.13781832213470463},0.12112506843459717,0.10645378623131133,-3.1196372895856093,0.32627256432515334,9.7881769297546004,-1.0178520582374677]
[null,null,null,null,null,15,{"$f":"EXP(MMULT(It0!G16:H16,B$2:B$3))","v":0.13781832213470463},0.12112506843459717,0.10645378623131133,-3.1196372895856093,0.32627256432515334,9.7881769297546004,-1.0178520582374677]
[null,null,null,null,null,16,{"$f":"EXP(MMULT(It0!G17:H17,B$2:B$3))","v":0.13781832213470463},0.12112506843459717,0.10645378623131133,6.2741103205474849,0.32627256432515334,9.7881769297546004,2.0470700631439378]
[null,null,null,null,null,17,{"$f":"EXP(MMULT(It0!G18:H18,B$2:B$3))","v":0.17204887303050542},0.14679325836101667,0.12524499766077249,-2.9320255700346896,0.35389970000096427,11.324790400030857,-1.0376429696304328]
[null,null,null,null,null,18,{"$f":"EXP(MMULT(It0!G19:H19,B$2:B$3))","v":0.17204887303050542},0.14679325836101667,0.12524499766077249,-2.9320255700346896,0.35389970000096427,11.324790400030857,-1.0376429696304328]
[null,null,null,null,null,19,{"$f":"EXP(MMULT(It0!G20:H20,B$2:B$3))","v":0.19223137357217429},0.16123663395655236,0.13523938182691311,-2.8412869353529979,0.36774907454256511,12.135719459904649,-1.0448806409859459]
[null,null,null,null,null,20,{"$f":"EXP(MMULT(It0!G21:H21,B$2:B$3))","v":0.19223137357217429},0.16123663395655236,0.13523938182691311,-2.8412869353529979,0.36774907454256511,12.135719459904649,-1.0448806409859459]
[null,null,null,null,null,21,{"$f":"EXP(MMULT(It0!G22:H22,B$2:B$3))","v":0.21478141841064444},0.17680663793133505,0.14554605071475282,-2.7529158449681081,0.38150498124500659,12.971169362330224,-1.0502511078036396]
[null,null,null,null,null,22,{"$f":"EXP(MMULT(It0!G23:H23,B$2:B$3))","v":0.21478141841064444},0.17680663793133505,0.14554605071475282,-2.7529158449681081,0.38150498124500659,12.971169362330224,-1.0502511078036396]
[null,null,null,null,null,23,{"$f":"EXP(MMULT(It0!G24:H24,B$2:B$3))","v":0.21478141841064444},0.17680663793133505,0.14554605071475282,4.117761820892035,0.38150498124500659,12.971169362330224,1.5709466462508199]
[null,null,null,null,null,24,{"$f":"EXP(MMULT(It0!G25:H25,B$2:B$3))","v":0.21478141841064444},0.17680663793133505,0.14554605071475282,-2.7529158449681081,0.38150498124500659,12.971169362330224,-1.0502511078036396]
[null,null,null,null,null,25,{"$f":"EXP(MMULT(It0!G26:H26,B$2:B$3))","v":0.21478141841064444},0.17680663793133505,0.14554605071475282,-2.7529158449681081,0.38150498124500659,12.971169362330224,-1.0502511078036396]
[null,null,null,null,null,26,{"$f":"EXP(MMULT(It0!G27:H27,B$2:B$3))","v":0.23997673656099736},0.19353325710493469,0.15607813549928995,-2.6671900278951002,0.39506725440017165,13.827353904006008,-1.0537194412840345]
[null,null,null,null,null,27,{"$f":"EXP(MMULT(It0!G28:H28,B$2:B$3))","v":0.23997673656099736},0.19353325710493469,0.15607813549928995,-2.6671900278951002,0.39506725440017165,13.827353904006008,-1.0537194412840345]
[null,null,null,null,null,28,{"$f":"EXP(MMULT(It0!G29:H29,B$2:B$3))","v":0.26812763653679378},0.21143584353152314,0.1667307276016364,-2.5844197926475361,0.40832674122770407,14.699762684197346,-1.055287711896147]
[null,null,null,null,null,29,{"$f":"EXP(MMULT(It0!G30:H30,B$2:B$3))","v":0.26812763653679378},0.21143584353152314,0.1667307276016364,3.4132748997745064,0.40832674122770407,14.699762684197346,1.3937314167392425]
[null,null,null,null,null,30,{"$f":"EXP(MMULT(It0!G31:H31,B$2:B$3))","v":0.26812763653679378},0.21143584353152314,0.1667307276016364,-2.5844197926475361,0.40832674122770407,14.699762684197346,-1.055287711896147]
[null,null,null,null,null,31,{"$f":"EXP(MMULT(It0!G32:H32,B$2:B$3))","v":0.29958082814637055},0.23052112008582898,0.17738113328020377,-2.5049518490337528,0.42116639619063123,15.583156659053355,-1.0550015428886037]
[null,null,null,null,null,32,{"$f":"EXP(MMULT(It0!G33:H33,B$2:B$3))","v":0.29958082814637055},0.23052112008582898,0.17738113328020377,3.1326262941858491,0.42116639619063123,15.583156659053355,1.3193569269342662]
[null,null,null,null,null,33,{"$f":"EXP(MMULT(It0!G34:H34,B$2:B$3))","v":0.29958082814637055},0.23052112008582898,0.17738113328020377,-2.5049518490337528,0.42116639619063123,15.583156659053355,-1.0550015428886037]
[null,null,null,null,null,34,{"$f":"EXP(MMULT(It0!G35:H35,B$2:B$3))","v":0.33472369261178148},0.25078126241753873,0.18789002083780432,-2.4291735782758028,0.43346282520858037,16.471587357926055,-1.0529564421614661]
[null,null,null,null,null,35,{"$f":"EXP(MMULT(It0!G36:H36,B$2:B$3))","v":0.33472369261178148},0.25078126241753873,0.18789002083780432,-2.4291735782758028,0.43346282520858037,16.471587357926055,-1.0529564421614661]
[null,null,null,null,null,36,{"$f":"EXP(MMULT(It0!G37:H37,B$2:B$3))","v":0.37398905360167212},0.27219216384681172,0.19810358978720213,-2.3575178040423337,0.44508829437225389,17.358443480517902,-1.0493035783534237]
[null,null,null,null,null,37,{"$f":"EXP(MMULT(It0!G38:H38,B$2:B$3))","v":0.37398905360167212},0.27219216384681172,0.19810358978720213,2.6903463011673439,0.44508829437225389,17.358443480517902,1.1974416464572752]
[null,null,null,null,null,38,{"$f":"EXP(MMULT(It0!G39:H39,B$2:B$3))","v":0.41786050793869461},0.29471200135631542,0.20785683761287058,-2.2904681231559954,0.45591319087395415,18.236527634958165,-1.0442546306231268]
[null,null,null,null,null,39,{"$f":"EXP(MMULT(It0!G40:H40,B$2:B$3))","v":0.41786050793869461},0.29471200135631542,0.20785683761287058,2.5205355055169338,0.45591319087395415,18.236527634958165,1.1491453850313205]
[null,null,null,null,null,40,{"$f":"EXP(MMULT(It0!G41:H41,B$2:B$3))","v":0.46687838163508005},0.31828022519131161,0.21697792344347958,-2.2285648616290201,0.46580889154617861,19.098164553393321,-1.0380853279341768]
[null,null,null,null,null,41,{"$f":"EXP(MMULT(It0!G42:H42,B$2:B$3))","v":0.46687838163508005},0.31828022519131161,0.21697792344347958,-2.2285648616290201,0.46580889154617861,19.098164553393321,-1.0380853279341768]
[null,null,null,null,null,42,{"$f":"EXP(MMULT(It0!G43:H43,B$2:B$3))","v":0.52164638461161061},0.34281708936255723,0.22529353260354165,-2.1724117293821905,0.47465095870917784,19.93534026578547,-1.0311373100623198]
[null,null,null,null,null,43,{"$f":"EXP(MMULT(It0!G44:H44,B$2:B$3))","v":0.52164638461161061},0.34281708936255723,0.22529353260354165,-2.1724117293821905,0.47465095870917784,19.93534026578547,-1.0311373100623198]
[null,null,null,null,null,44,{"$f":"EXP(MMULT(It0!G45:H45,B$2:B$3))","v":0.52164638461161061},0.34281708936255723,0.22529353260354165,-2.1724117293821905,0.47465095870917784,19.93534026578547,-1.0311373100623198]
[null,null,null,null,null,45,{"$f":"EXP(MMULT(It0!G46:H46,B$2:B$3))","v":0.52164638461161061},0.34281708936255723,0.22529353260354165,2.2662420945593129,0.47465095870917784,19.93534026578547,1.0756739828496731]
[null,null,null,null,null,46,{"$f":"EXP(MMULT(It0!G47:H47,B$2:B$3))","v":0.58283904606029535},0.3682238238379249,0.23263503939610172,-2.1226832556075146,0.48232254705342331,20.739869523297202,-1.0238179944322692]
[null,null,null,null,null,47,{"$f":"EXP(MMULT(It0!G48:H48,B$2:B$3))","v":0.58283904606029535},0.3682238238379249,0.23263503939610172,-2.1226832556075146,0.48232254705342331,20.739869523297202,-1.0238179944322692]
[null,null,null,null,null,48,{"$f":"EXP(MMULT(It0!G49:H49,B$2:B$3))","v":0.58283904606029535},0.3682238238379249,0.23263503939610172,2.1758953359748374,0.48232254705342331,20.739869523297202,1.0494833805690478]
[null,null,null,null,null,49,{"$f":"EXP(MMULT(It0!G50:H50,B$2:B$3))","v":0.65121002202554934},0.39438352077508959,0.23884515931613404,-2.080133096349408,0.48871787292479291,21.503586408690889,-1.0165982222483461]
[null,null,null,null,null,50,{"$f":"EXP(MMULT(It0!G51:H51,B$2:B$3))","v":0.65121002202554934},0.39438352077508959,0.23884515931613404,-2.080133096349408,0.48871787292479291,21.503586408690889,-1.0165982222483461]
[null,null,null,null,null,51,{"$f":"EXP(MMULT(It0!G52:H52,B$2:B$3))","v":0.65121002202554934},0.39438352077508959,0.23884515931613404,2.106679828238299,0.48871787292479291,21.503586408690889,1.0295720845901897]
[null,null,null,null,null,52,{"$f":"EXP(MMULT(It0!G53:H53,B$2:B$3))","v":0.65121002202554934},0.39438352077508959,0.23884515931613404,2.106679828238299,0.48871787292479291,21.503586408690889,1.0295720845901897]
[null,null,null,null,null,53,{"$f":"EXP(MMULT(It0!G54:H54,B$2:B$3))","v":0.72760137752103371},0.42116276763166399,0.24378469079250098,-2.0456033166215324,0.49374557293458438,22.218550782056298,-1.0100075815621845]
[null,null,null,null,null,54,{"$f":"EXP(MMULT(It0!G55:H55,B$2:B$3))","v":0.72760137752103371},0.42116276763166399,0.24378469079250098,2.0563769871833397,0.49374557293458438,22.218550782056298,1.0153270337063325]
[null,null,null,null,null,55,{"$f":"EXP(MMULT(It0!G56:H56,B$2:B$3))","v":0.81295395750180244},0.44841401191568547,0.247338885833365,-2.0200347613789398,0.49733176636262133,22.877261252680583,-1.0046274559904844]
[null,null,null,null,null,56,{"$f":"EXP(MMULT(It0!G57:H57,B$2:B$3))","v":0.81295395750180244},0.44841401191568547,0.247338885833365,2.0230011592797768,0.49733176636262133,22.877261252680583,1.0061027398982421]
[null,null,null,null,null,57,{"$f":"EXP(MMULT(It0!G58:H58,B$2:B$3))","v":0.90831897442186527},0.47597858984609476,0.24942297185421786,-2.0044786430756432,0.49942263850792534,23.472864009872492,-1.0010820127576237]
[null,null,null,null,null,58,{"$f":"EXP(MMULT(It0!G59:H59,B$2:B$3))","v":0.90831897442186527},0.47597858984609476,0.24942297185421786,-2.0044786430756432,0.49942263850792534,23.472864009872492,-1.0010820127576237]
[null,null,null,null,null,59,{"$f":"EXP(MMULT(It0!G60:H60,B$2:B$3))","v":0.90831897442186527},0.47597858984609476,0.24942297185421786,2.0047751660902491,0.49942263850792534,23.472864009872492,1.0012301030639565]
[null,null,null,null,null,60,{"$f":"EXP(MMULT(It0!G61:H61,B$2:B$3))","v":1.0148709550909107},0.50369029963267298,0.24998638168862108,-2.000109488521328,0.49998638150315761,23.999346312151566,-1.00002750577591]
[null,null,null,null,null,61,{"$f":"EXP(MMULT(It0!G62:H62,B$2:B$3))","v":1.0148709550909107},0.50369029963267298,0.24998638168862108,2.0001084163307192,0.49998638150315761,23.999346312151566,1.0000269696952073]
[null,null,null,null,null,62,{"$f":"EXP(MMULT(It0!G63:H63,B$2:B$3))","v":1.0148709550909107},0.50369029963267298,0.24998638168862108,2.0001084163307192,0.49998638150315761,23.999346312151566,1.0000269696952073]
[null,null,null,null,null,63,{"$f":"EXP(MMULT(It0!G64:H64,B$2:B$3))","v":1.1339222062851844},0.53137935532296676,0.24901533605951501,-2.0082396044922399,0.49901436458233844,24.451703864534583,-1.0021404101647817]
[null,null,null,null,null,64,{"$f":"EXP(MMULT(It0!G65:H65,B$2:B$3))","v":1.1339222062851844},0.53137935532296676,0.24901533605951501,-2.0082396044922399,0.49901436458233844,24.451703864534583,-1.0021404101647817]
[null,null,null,null,null,65,{"$f":"EXP(MMULT(It0!G66:H66,B$2:B$3))","v":1.1339222062851844},0.53137935532296676,0.24901533605951501,2.0075773159603969,0.49901436458233844,24.451703864534583,1.001809918673894]
[null,null,null,null,null,66,{"$f":"EXP(MMULT(It0!G67:H67,B$2:B$3))","v":1.2669389772727122},0.55887652467687032,{"$f":"H67*(1-H67)","v":0.24653355484197387},-2.0303352402564085,0.4965214545636209,24.826072728181046,-1.0081050067438906]
[null,null,null,null,null,67,{"$f":"EXP(MMULT(It0!G68:H68,B$2:B$3))","v":1.2669389772727122},{"$f":"G68/(1+G68)","v":0.55887652467687032},0.24653355484197387,2.0259077350294197,0.4965214545636209,24.826072728181046,1.0059066554084981]
[null,null,null,null,null,68,{"$f":"EXP(MMULT(It0!G69:H69,B$2:B$3))","v":1.4155595183124334},0.58601723848285736,0.24260103468378325,-2.068034646072769,0.49254546458553777,25.119818693862427,-1.0186010855289003]
[null,null,null,null,null,69,{"$f":"EXP(MMULT(It0!G70:H70,B$2:B$3))","v":1.5816142575378365},0.61264546123411545,0.2373110000633534,-2.1231682500748117,0.48714576880370564,25.331579977792693,-1.0342924294823126]
[null,null,null,null,null,70,{"$f":"EXP(MMULT(It0!G71:H71,B$2:B$3))","v":1.5816142575378365},0.61264546123411545,0.2373110000633534,2.0907114256799422,0.48714576880370564,25.331579977792693,1.0184812248095469]
[null,null,null,null,null,71,{"$f":"EXP(MMULT(It0!G72:H72,B$2:B$3))","v":1.7671483447260097},0.63861713380638596,0.2307852902153025,2.1352505915685711,0.4804011763258938,25.46126234527237,1.0257768959401021]
[null,null,null,null,null,72,{"$f":"EXP(MMULT(It0!G73:H73,B$2:B$3))","v":1.7671483447260097},0.63861713380638596,0.2307852902153025,2.1352505915685711,0.4804011763258938,25.46126234527237,1.0257768959401021]
[null,null,null,null,null,73,{"$f":"EXP(MMULT(It0!G74:H74,B$2:B$3))","v":1.9744468396037897},0.66380303500962734,0.22316856572163479,2.1867592448366997,0.4724072032914346,25.509988977737468,1.0330408191249949]
[null,null,null,null,null,74,{"$f":"EXP(MMULT(It0!G75:H75,B$2:B$3))","v":2.2060628549131964},0.6880909560249171,0.21462179226163269,-2.4148534417800906,0.46327291336925008,25.480010235308754,-1.1187361893332233]
[null,null,null,null,null,75,{"$f":"EXP(MMULT(It0!G76:H76,B$2:B$3))","v":2.2060628549131964},0.6880909560249171,0.21462179226163269,2.2445056543407698,0.46327291336925008,25.480010235308754,1.0398186735602033]
[null,null,null,null,null,76,{"$f":"EXP(MMULT(It0!G77:H77,B$2:B$3))","v":2.2060628549131964},0.6880909560249171,0.21462179226163269,2.2445056543407698,0.46327291336925008,25.480010235308754,1.0398186735602033]
[null,null,null,null,null,77,{"$f":"EXP(MMULT(It0!G78:H78,B$2:B$3))","v":2.4648490008494557},0.71138713411325105,0.2053154795313864,2.307834913879617,0.45311751183482901,25.374580662750425,1.045720413902679]
[null,null,null,null,null,78,{"$f":"EXP(MMULT(It0!G79:H79,B$2:B$3))","v":2.4648490008494557},0.71138713411325105,0.2053154795313864,2.307834913879617,0.45311751183482901,25.374580662750425,1.045720413902679]
[null,null,null,null,null,79,{"$f":"EXP(MMULT(It0!G80:H80,B$2:B$3))","v":2.4648490008494557},0.71138713411325105,0.2053154795313864,2.307834913879617,0.45311751183482901,25.374580662750425,1.045720413902679]
[null,null,null,null,null,80,{"$f":"EXP(MMULT(It0!G81:H81,B$2:B$3))","v":2.753992518145008},0.73361694378279196,0.19542312357758782,-2.7409408345651807,0.44206687681570062,25.197811978494936,-1.2116791542728493]
[null,null,null,null,null,81,{"$f":"EXP(MMULT(It0!G82:H82,B$2:B$3))","v":2.753992518145008},0.73361694378279196,0.19542312357758782,-2.7409408345651807,0.44206687681570062,25.197811978494936,-1.2116791542728493]
[null,null,null,null,null,82,{"$f":"EXP(MMULT(It0!G83:H83,B$2:B$3))","v":2.753992518145008},0.73361694378279196,0.19542312357758782,2.3761608762923641,0.44206687681570062,25.197811978494936,1.0504220173942238]
[null,null,null,null,null,83,{"$f":"EXP(MMULT(It0!G84:H84,B$2:B$3))","v":2.753992518145008},0.73361694378279196,0.19542312357758782,2.3761608762923641,0.44206687681570062,25.197811978494936,1.0504220173942238]
[null,null,null,null,null,84,{"$f":"EXP(MMULT(It0!G85:H85,B$2:B$3))","v":2.753992518145008},0.73361694378279196,0.19542312357758782,2.3761608762923641,0.44206687681570062,25.197811978494936,1.0504220173942238]
[null,null,null,null,null,85,{"$f":"EXP(MMULT(It0!G86:H86,B$2:B$3))","v":2.753992518145008},0.73361694378279196,0.19542312357758782,2.3761608762923641,0.44206687681570062,25.197811978494936,1.0504220173942238]
[null,null,null,null,null,86,{"$f":"EXP(MMULT(It0!G87:H87,B$2:B$3))","v":3.0770545325027436},0.75472488973893137,0.18511523054748927,-2.9530817136995555,0.43025019529047198,24.954511326847374,-1.2705639840279555]
[null,null,null,null,null,87,{"$f":"EXP(MMULT(It0!G88:H88,B$2:B$3))","v":3.0770545325027436},0.75472488973893137,0.18511523054748927,2.4489589344007694,0.43025019529047198,24.954511326847374,1.0536650597842772]
[null,null,null,null,null,88,{"$f":"EXP(MMULT(It0!G89:H89,B$2:B$3))","v":3.0770545325027436},0.75472488973893137,0.18511523054748927,2.4489589344007694,0.43025019529047198,24.954511326847374,1.0536650597842772]
[null,null,null,null,null,89,{"$f":"EXP(MMULT(It0!G90:H90,B$2:B$3))","v":3.4380139138406864},0.77467398268371057,0.17455420323666868,2.5257595598852736,0.41779684445513549,24.650013822852994,1.0552543739724591]
[null,null,null,null,null,90,{"$f":"EXP(MMULT(It0!G91:H91,B$2:B$3))","v":3.4380139138406864},0.77467398268371057,0.17455420323666868,2.5257595598852736,0.41779684445513549,24.650013822852994,1.0552543739724591]
[null,null,null,null,null,91,{"$f":"EXP(MMULT(It0!G92:H92,B$2:B$3))","v":3.8413162805237402},0.79344460430669927,0.1638902642032847,-3.4955011912738305,0.40483362533673595,24.290017520204156,-1.4150964196322642]
[null,null,null,null,null,92,{"$f":"EXP(MMULT(It0!G93:H93,B$2:B$3))","v":3.8413162805237402},0.79344460430669927,0.1638902642032847,2.6061425205187696,0.40483362533673595,24.290017520204156,1.0550541247258323]
[null,null,null,null,null,93,{"$f":"EXP(MMULT(It0!G94:H94,B$2:B$3))","v":4.2919287521244422},0.8110329811982917,0.15325848460690311,2.6897317045368681,0.39148241928201977,23.880427576203207,1.052982674911644]
[null,null,null,null,null,94,{"$f":"EXP(MMULT(It0!G95:H95,B$2:B$3))","v":4.7954011250541821},0.8274493898831462,0.14277689706515531,2.7761904884009985,0.37785830289296979,23.427214779364128,1.0490066264548061]
[null,null,null,null,null,95,{"$f":"EXP(MMULT(It0!G96:H96,B$2:B$3))","v":4.7954011250541821},0.8274493898831462,0.14277689706515531,2.7761904884009985,0.37785830289296979,23.427214779364128,1.0490066264548061]
[null,null,null,null,null,96,{"$f":"EXP(MMULT(It0!G97:H97,B$2:B$3))","v":5.3579342245111299},0.84271620864764585,0.13254560033018328,2.8652175909031508,0.36406812594648175,22.93629193462835,1.0431343987490034]
[null,null,null,null,null,97,{"$f":"EXP(MMULT(It0!G98:H98,B$2:B$3))","v":5.9864562745756436},0.85686591875782692,0.12264671602913207,-5.1969566444322934,0.35020953160805329,22.413410022915411,-1.8200237522339939]
[null,null,null,null,null,98,{"$f":"EXP(MMULT(It0!G99:H99,B$2:B$3))","v":5.9864562745756436},0.85686591875782692,0.12264671602913207,2.9565433625509483,0.35020953160805329,22.413410022915411,1.0354096661778665]
[null,null,null,null,null,99,{"$f":"EXP(MMULT(It0!G100:H100,B$2:B$3))","v":6.6887082270361393},0.86993914055892296,0.11314503228252544,3.0499264645326489,0.33637037961527683,21.864074674992995,1.0259049226735262]
[null,null,null,null,null,100,{"$f":"EXP(MMULT(It0!G101:H101,B$2:B$3))","v":10.423942318305221},0.912464544013178,7.9872999932001143E-2,3.4400383006555573,0.28261811677951776,19.500650057786725,0.97221714618068611]

{"sheet":"It6","index":7,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,10,0,11],[5,0,6,0]]}
["Beta iteration (i-1)",null,null,null,"Beta (iteration i)",null,"exp(X*beta)","Calcolo del vettore p =probabilità stimate dato beta","Calcolo diagonale principale matrice W","Calcolo di z","Calcolo di Xw",null,"Calcolo di zw"]
["beta0",{"$f":"'It5'!E2:E3","v":-5.3094533739190437},null,null,{"$f":"Q4","v":-5.3094533739190535},1,{"$f":"EXP(MMULT(It0!G2:H2,B$2:B$3))","v":4.5455087438561588E-2},{"$f":"G2/(1+G2)","v":4.347875674882385E-2},{"$f":"H2*(1-H2)","v":4.1588354460400455E-2},{"$f":"MMULT(X,B2:B3)+(y-H2:H101)/I2:I101","v":-4.1364856172196083},{"$f":"SQRT(I2:I101)*X","v":0.20393223006773709},4.0786446013547417,{"$f":"SQRT(I2:I101)*J2:J101","v":-0.84356273656271463},null,null,"Calcolo del nuovo beta"]
["beta1",0.11092114220689984,null,null,{"$f":"P4","v":0.11092114220690016},2,{"$f":"EXP(MMULT(It0!G3:H3,B$2:B$3))","v":6.3401541550344678E-2},{"$f":"G3/(1+G3)","v":5.9621449728115762E-2},{"$f":"H3*(1-H3)","v":5.6066732460433526E-2},-3.8216686447106918,0.23678414740103174,5.44603539022373,-0.90491055168707768]
[null,null,null,null,null,3,{"$f":"EXP(MMULT(It0!G4:H4,B$2:B$3))","v":7.0838973189721544E-2},{"$f":"G4/(1+G4)","v":6.6152778301216103E-2},6.1776588224246254E-2,-3.718184934143169,0.24854896544593835,5.9651751707025209,-0.92415101871795913,null,null,{"$f":"LINEST(M2:M101,K2:L101,0,1)","v":0.11092114220690016},-5.3094533739190535]
["Iterazione",6,null,null,null,4,{"$f":"EXP(MMULT(It0!G5:H5,B$2:B$3))","v":7.9148866097985382E-2},7.334378841000308E-2,6.7964477111671778E-2,-3.615573684844533,0.26069997528130257,6.5174993820325637,-0.94257997026669782,null,null,2.4539073754395957E-2,1.15623543275001]
["Criterio di convergenza",null,null,null,null,5,{"$f":"EXP(MMULT(It0!G6:H6,B$2:B$3))","v":7.9148866097985382E-2},7.334378841000308E-2,6.7964477111671778E-2,11.097994968923075,0.26069997528130257,6.5174993820325637,2.893247014070266,null,null,0.17720288037592305,1.0199185847271495]
[null,{"$f":"SUMSQ(E2:E3-B2:B3)/SUMSQ(E2:E3)","v":3.3881293167602548E-30},null,null,null,6,{"$f":"EXP(MMULT(It0!G7:H7,B$2:B$3))","v":8.8433565910379125E-2},8.1248473659862014E-2,7.4647159187804721E-2,-3.513937242450027,0.27321632306252258,7.1036243996255868,-0.96006501285465629,null,null,10.552955195549698,98]
[null,null,null,null,null,7,{"$f":"EXP(MMULT(It0!G8:H8,B$2:B$3))","v":8.8433565910379125E-2},8.1248473659862014E-2,7.4647159187804721E-2,-3.513937242450027,0.27321632306252258,7.1036243996255868,-0.96006501285465629,null,null,21.955083890154583,101.9429241082395]
[null,null,null,null,null,8,{"$f":"EXP(MMULT(It0!G9:H9,B$2:B$3))","v":0.11039820634723843},9.9422176401386619E-2,8.9537407240998179E-2,-3.3140595984730865,0.29922801881006761,8.3783845266818933,-0.9916594878695898]
[null,null,null,null,null,9,{"$f":"EXP(MMULT(It0!G10:H10,B$2:B$3))","v":0.11039820634723843},9.9422176401386619E-2,8.9537407240998179E-2,-3.3140595984730865,0.29922801881006761,8.3783845266818933,-0.9916594878695898,null,null,"Regressione di zw su Xw"]
[null,null,null,null,null,10,{"$f":"EXP(MMULT(It0!G11:H11,B$2:B$3))","v":0.12334866611114527},0.10980443546362036,9.7747421416135988E-2,-3.2160889160300936,0.31264584023481901,9.0667293668097511,-1.0054968214221169]
[null,null,null,null,null,11,{"$f":"EXP(MMULT(It0!G12:H12,B$2:B$3))","v":0.13781830280415053},0.12112505350326819,0.10645377491709861,-3.1196374105161988,0.32627254698656244,9.7881764095968737,-1.0178520436036844]
[null,null,null,null,null,12,{"$f":"EXP(MMULT(It0!G13:H13,B$2:B$3))","v":0.13781830280415053},0.12112505350326819,0.10645377491709861,-3.1196374105161988,0.32627254698656244,9.7881764095968737,-1.0178520436036844]
[null,null,null,null,null,13,{"$f":"EXP(MMULT(It0!G14:H14,B$2:B$3))","v":0.13781830280415053},0.12112505350326819,0.10645377491709861,-3.1196374105161988,0.32627254698656244,9.7881764095968737,-1.0178520436036844]
[null,null,null,null,null,14,{"$f":"EXP(MMULT(It0!G15:H15,B$2:B$3))","v":0.13781830280415053},0.12112505350326819,0.10645377491709861,-3.1196374105161988,0.32627254698656244,9.7881764095968737,-1.0178520436036844]
[null,null,null,null,null,15,{"$f":"EXP(MMULT(It0!G16:H16,B$2:B$3))","v":0.13781830280415053},0.12112505350326819,0.10645377491709861,-3.1196374105161988,0.32627254698656244,9.7881764095968737,-1.0178520436036844]
[null,null,null,null,null,16,{"$f":"EXP(MMULT(It0!G17:H17,B$2:B$3))","v":0.13781830280415053},0.12112505350326819,0.10645377491709861,6.2741111980113509,0.32627254698656244,9.7881764095968737,2.0470702406520762]
[null,null,null,null,null,17,{"$f":"EXP(MMULT(It0!G18:H18,B$2:B$3))","v":0.17204885130175532},0.14679324254331758,0.1252449864869363,-2.9320256746000042,0.35389968421423645,11.324789894855567,-1.0376429603489752]
[null,null,null,null,null,18,{"$f":"EXP(MMULT(It0!G19:H19,B$2:B$3))","v":0.17204885130175532},0.14679324254331758,0.1252449864869363,-2.9320256746000042,0.35389968421423645,11.324789894855567,-1.0376429603489752]
[null,null,null,null,null,19,{"$f":"EXP(MMULT(It0!G20:H20,B$2:B$3))","v":0.19223135063694954},0.16123661782107135,0.13523937089469312,-2.8412870317282986,0.36774905967887006,12.135718969402712,-1.0448806341958496]
[null,null,null,null,null,20,{"$f":"EXP(MMULT(It0!G21:H21,B$2:B$3))","v":0.19223135063694954},0.16123661782107135,0.13523937089469312,-2.8412870317282986,0.36774905967887006,12.135718969402712,-1.0448806341958496]
[null,null,null,null,null,21,{"$f":"EXP(MMULT(It0!G22:H22,B$2:B$3))","v":0.21478139428489654},0.1768066215825865,0.14554604014713857,-2.7529159331693451,0.38150496739510298,12.971168891433502,-1.0502511033252304]
[null,null,null,null,null,22,{"$f":"EXP(MMULT(It0!G23:H23,B$2:B$3))","v":0.21478139428489654},0.1768066215825865,0.14554604014713857,-2.7529159331693451,0.38150496739510298,12.971168891433502,-1.0502511033252304]
[null,null,null,null,null,23,{"$f":"EXP(MMULT(It0!G24:H24,B$2:B$3))","v":0.21478139428489654},0.1768066215825865,0.14554604014713857,4.1177622315478679,0.38150496739510298,12.971168891433502,1.5709467458874558]
[null,null,null,null,null,24,{"$f":"EXP(MMULT(It0!G25:H25,B$2:B$3))","v":0.21478139428489654},0.1768066215825865,0.14554604014713857,-2.7529159331693451,0.38150496739510298,12.971168891433502,-1.0502511033252304]
[null,null,null,null,null,25,{"$f":"EXP(MMULT(It0!G26:H26,B$2:B$3))","v":0.21478139428489654},0.1768066215825865,0.14554604014713857,-2.7529159331693451,0.38150496739510298,12.971168891433502,-1.0502511033252304]
[null,null,null,null,null,26,{"$f":"EXP(MMULT(It0!G27:H27,B$2:B$3))","v":0.23997671128102219},0.19353324066312649,0.15607812542155486,-2.6671901079585711,0.39506724164571638,13.827353457600074,-1.0537194388959332]
[null,null,null,null,null,27,{"$f":"EXP(MMULT(It0!G28:H28,B$2:B$3))","v":0.23997671128102219},0.19353324066312649,0.15607812542155486,-2.6671901079585711,0.39506724164571638,13.827353457600074,-1.0537194388959332]
[null,null,null,null,null,28,{"$f":"EXP(MMULT(It0!G29:H29,B$2:B$3))","v":0.26812761016378567},0.21143582713190473,0.16673071813695201,-2.5844198646344352,0.40832672963810734,14.699762266971865,-1.0552877113379391]
[null,null,null,null,null,29,{"$f":"EXP(MMULT(It0!G30:H30,B$2:B$3))","v":0.26812761016378567},0.21143582713190473,0.16673071813695201,3.4132751682544868,0.40832672963810734,14.699762266971865,1.3937314868083153]
[null,null,null,null,null,30,{"$f":"EXP(MMULT(It0!G31:H31,B$2:B$3))","v":0.26812761016378567},0.21143582713190473,0.16673071813695201,-2.5844198646344352,0.40832672963810734,14.699762266971865,-1.0552877113379391]
[null,null,null,null,null,31,{"$f":"EXP(MMULT(It0!G32:H32,B$2:B$3))","v":0.29958080077176386},0.23052110387738572,0.17738112454453725,-2.504951913035514,0.42116638581982924,15.583156275333682,-1.0550015438656346]
[null,null,null,null,null,32,{"$f":"EXP(MMULT(It0!G33:H33,B$2:B$3))","v":0.29958080077176386},0.23052110387738572,0.17738112454453725,3.1326265078235656,0.42116638581982924,15.583156275333682,1.3193569844234441]
[null,null,null,null,null,33,{"$f":"EXP(MMULT(It0!G34:H34,B$2:B$3))","v":0.29958080077176386},0.23052110387738572,0.17738112454453725,-2.504951913035514,0.42116638581982924,15.583156275333682,-1.0550015438656346]
[null,null,null,null,null,34,{"$f":"EXP(MMULT(It0!G35:H35,B$2:B$3))","v":0.33472366436350343},0.25078124656096873,0.18789001293429536,-2.4291736344203532,0.43346281609187121,16.471587011491106,-1.0529564443519719]
[null,null,null,null,null,35,{"$f":"EXP(MMULT(It0!G36:H36,B$2:B$3))","v":0.33472366436350343},0.25078124656096873,0.18789001293429536,-2.4291736344203532,0.43346281609187121,16.471587011491106,-1.0529564443519719]
[null,null,null,null,null,36,{"$f":"EXP(MMULT(It0!G37:H37,B$2:B$3))","v":0.37398902465144662},0.27219214851175405,0.19810358280030929,-2.3575178525013967,0.44508828652336974,17.35844317441142,-1.0493035814181009]
[null,null,null,null,null,37,{"$f":"EXP(MMULT(It0!G38:H38,B$2:B$3))","v":0.37398902465144662},0.27219214851175405,0.19810358280030929,2.6903464307408282,0.44508828652336974,17.35844317441142,1.1974416830126988]
[null,null,null,null,null,38,{"$f":"EXP(MMULT(It0!G39:H39,B$2:B$3))","v":0.41786047851055613},0.29471198671784199,0.20785683160266449,-2.2904681641536064,0.45591318428256106,18.236527371302444,-1.0442546342171024]
[null,null,null,null,null,39,{"$f":"EXP(MMULT(It0!G40:H40,B$2:B$3))","v":0.41786047851055613},0.29471198671784199,0.20785683160266449,2.5205356036300888,0.45591318428256106,18.236527371302444,1.149145413148561]
[null,null,null,null,null,40,{"$f":"EXP(MMULT(It0!G41:H41,B$2:B$3))","v":0.46687835201528438},0.31828021142575269,0.21697791844053085,-2.2285648954514348,0.46580888617600552,19.098164333216225,-1.0380853317211791]
[null,null,null,null,null,41,{"$f":"EXP(MMULT(It0!G42:H42,B$2:B$3))","v":0.46687835201528438},0.31828021142575269,0.21697791844053085,-2.2285648954514348,0.46580888617600552,19.098164333216225,-1.0380853317211791]
[null,null,null,null,null,42,{"$f":"EXP(MMULT(It0!G43:H43,B$2:B$3))","v":0.52164635516015001},0.34281707664278394,0.22529352860487953,-2.1724117563894003,0.47465095449696459,19.935340088872515,-1.0311373137306561]
[null,null,null,null,null,43,{"$f":"EXP(MMULT(It0!G44:H44,B$2:B$3))","v":0.52164635516015001},0.34281707664278394,0.22529352860487953,-2.1724117563894003,0.47465095449696459,19.935340088872515,-1.0311373137306561]
[null,null,null,null,null,44,{"$f":"EXP(MMULT(It0!G45:H45,B$2:B$3))","v":0.52164635516015001},0.34281707664278394,0.22529352860487953,-2.1724117563894003,0.47465095449696459,19.935340088872515,-1.0311373137306561]
[null,null,null,null,null,45,{"$f":"EXP(MMULT(It0!G46:H46,B$2:B$3))","v":0.52164635516015001},0.34281707664278394,0.22529352860487953,2.2662421463323374,0.47465095449696459,19.935340088872515,1.0756739978778938]
[null,null,null,null,null,46,{"$f":"EXP(MMULT(It0!G47:H47,B$2:B$3))","v":0.58283901722425757},0.36822381232827583,0.23263503636270652,-2.1226832762466081,0.48232254390885204,20.739869388080638,-1.0238179977120405]
[null,null,null,null,null,47,{"$f":"EXP(MMULT(It0!G48:H48,B$2:B$3))","v":0.58283901722425757},0.36822381232827583,0.23263503636270652,-2.1226832762466081,0.48232254390885204,20.739869388080638,-1.0238179977120405]
[null,null,null,null,null,48,{"$f":"EXP(MMULT(It0!G49:H49,B$2:B$3))","v":0.58283901722425757},0.36822381232827583,0.23263503636270652,2.1758953713861477,0.48232254390885204,20.739869388080638,1.0494833908064631]
[null,null,null,null,null,49,{"$f":"EXP(MMULT(It0!G50:H50,B$2:B$3))","v":0.65120999435459914},0.39438351062617844,0.23884515717234947,-2.0801331111700496,0.48871787073151873,21.503586312186826,-1.0165982249291563]
[null,null,null,null,null,50,{"$f":"EXP(MMULT(It0!G51:H51,B$2:B$3))","v":0.65120999435459914},0.39438351062617844,0.23884515717234947,-2.0801331111700496,0.48871787073151873,21.503586312186826,-1.0165982249291563]
[null,null,null,null,null,51,{"$f":"EXP(MMULT(It0!G52:H52,B$2:B$3))","v":0.65120999435459914},0.39438351062617844,0.23884515717234947,2.1066798509969207,0.48871787073151873,21.503586312186826,1.0295720910922082]
[null,null,null,null,null,52,{"$f":"EXP(MMULT(It0!G53:H53,B$2:B$3))","v":0.65120999435459914},0.39438351062617844,0.23884515717234947,2.1066798509969207,0.48871787073151873,21.503586312186826,1.0295720910922082]
[null,null,null,null,null,53,{"$f":"EXP(MMULT(It0!G54:H54,B$2:B$3))","v":0.72760135168532625},0.42116275897534444,0.24378468942762038,-2.0456033262938771,0.49374557155241444,22.218550719858651,-1.0100075835104905]
[null,null,null,null,null,54,{"$f":"EXP(MMULT(It0!G55:H55,B$2:B$3))","v":0.72760135168532625},0.42116275897534444,0.24378468942762038,2.0563770004768069,0.49374557155241444,22.218550719858651,1.0153270374276606]
[null,null,null,null,null,55,{"$f":"EXP(MMULT(It0!G56:H56,B$2:B$3))","v":0.8129539343126867},0.44841400486046418,0.24733888510546381,-2.0200347667143377,0.49733176563081494,22.877261219017488,-1.0046274571656728]
[null,null,null,null,null,56,{"$f":"EXP(MMULT(It0!G57:H57,B$2:B$3))","v":0.8129539343126867},0.44841400486046418,0.24733888510546381,2.0230011658427531,0.49733176563081494,22.877261219017488,1.0061027416817734]
[null,null,null,null,null,57,{"$f":"EXP(MMULT(It0!G58:H58,B$2:B$3))","v":0.90831895485579062},0.47597858447328117,0.24942297159609275,-2.0044786450505416,0.49942263824950184,23.472863997726588,-1.0010820132259282]
[null,null,null,null,null,58,{"$f":"EXP(MMULT(It0!G59:H59,B$2:B$3))","v":0.90831895485579062},0.47597858447328117,0.24942297159609275,-2.0044786450505416,0.49942263824950184,23.472863997726588,-1.0010820132259282]
[null,null,null,null,null,59,{"$f":"EXP(MMULT(It0!G60:H60,B$2:B$3))","v":0.90831895485579062},0.47597858447328117,0.24942297159609275,2.0047751682644837,0.49942263824950184,23.472863997726588,1.0012301036317375]
[null,null,null,null,null,60,{"$f":"EXP(MMULT(It0!G61:H61,B$2:B$3))","v":1.0148709403169935},0.50369029599351267,0.24998638171548027,-2.0001094883048451,0.49998638153001757,23.999346313440842,-1.0000275057213945]
[null,null,null,null,null,61,{"$f":"EXP(MMULT(It0!G62:H62,B$2:B$3))","v":1.0148709403169935},0.50369029599351267,0.24998638171548027,2.0001084161174081,0.49998638153001757,23.999346313440842,1.0000269696422774]
[null,null,null,null,null,62,{"$f":"EXP(MMULT(It0!G63:H63,B$2:B$3))","v":1.0148709403169935},0.50369029599351267,0.24998638171548027,2.0001084161174081,0.49998638153001757,23.999346313440842,1.0000269696422774]
[null,null,null,null,null,63,{"$f":"EXP(MMULT(It0!G64:H64,B$2:B$3))","v":1.1339221976969764},0.53137935343695086,0.24901533617787891,-2.0082396034779282,0.49901436470093613,24.45170387034587,-1.0021404098967983]
[null,null,null,null,null,64,{"$f":"EXP(MMULT(It0!G65:H65,B$2:B$3))","v":1.1339221976969764},0.53137935343695086,0.24901533617787891,-2.0082396034779282,0.49901436470093613,24.45170387034587,-1.0021404098967983]
[null,null,null,null,null,65,{"$f":"EXP(MMULT(It0!G66:H66,B$2:B$3))","v":1.1339221976969764},0.53137935343695086,0.24901533617787891,2.0075773150658791,0.49901436470093613,24.45170387034587,1.0018099184656108]
[null,null,null,null,null,66,{"$f":"EXP(MMULT(It0!G67:H67,B$2:B$3))","v":1.2669389765247681},0.55887652453132797,{"$f":"H67*(1-H67)","v":0.24653355485911194},-2.0303352400988195,0.49652145458087904,24.82607272904395,-1.008105006700684]
[null,null,null,null,null,67,{"$f":"EXP(MMULT(It0!G68:H68,B$2:B$3))","v":1.2669389765247681},{"$f":"G68/(1+G68)","v":0.55887652453132797},0.24653355485911194,2.0259077349050338,0.49652145458087904,24.82607272904395,1.0059066553817013]
[null,null,null,null,null,68,{"$f":"EXP(MMULT(It0!G69:H69,B$2:B$3))","v":1.4155595273623656},0.58601724003385047,0.24260103441695896,-2.0680346487295176,0.49254546431467516,25.119818680048432,-1.0186010862773165]
[null,null,null,null,null,69,{"$f":"EXP(MMULT(It0!G70:H70,B$2:B$3))","v":1.5816142786946537},0.61264546440855916,0.23731099934818004,-2.1231682578549051,0.48714576806966109,25.331579939622376,-1.034292431713852]
[null,null,null,null,null,70,{"$f":"EXP(MMULT(It0!G71:H71,B$2:B$3))","v":1.5816142786946537},0.61264546440855916,0.23731099934818004,2.090711430599026,0.48714576806966109,25.331579939622376,1.0184812256711824]
[null,null,null,null,null,71,{"$f":"EXP(MMULT(It0!G72:H72,B$2:B$3))","v":1.7671483807056148},0.63861713850523516,0.23078528891262046,2.1352506004072982,0.48040117497006651,25.461262273413524,1.025776897291206]
[null,null,null,null,null,72,{"$f":"EXP(MMULT(It0!G73:H73,B$2:B$3))","v":1.7671483807056148},0.63861713850523516,0.23078528891262046,2.1352506004072982,0.48040117497006651,25.461262273413524,1.025776897291206]
[null,null,null,null,null,73,{"$f":"EXP(MMULT(It0!G74:H74,B$2:B$3))","v":1.9744468935926736},0.66380304111190436,0.22316856372249178,2.1867592583316604,0.47240720117552376,25.509988863478284,1.0330408208731239]
[null,null,null,null,null,74,{"$f":"EXP(MMULT(It0!G75:H75,B$2:B$3))","v":2.2060629306414712},0.68809096339231268,0.2146217894901517,-2.4148534831810236,0.46327291037805318,25.480010070792925,-1.1187362012898519]
[null,null,null,null,null,75,{"$f":"EXP(MMULT(It0!G76:H76,B$2:B$3))","v":2.2060629306414712},0.68809096339231268,0.2146217894901517,2.2445056731076569,0.46327291037805318,25.480010070792925,1.0398186755406356]
[null,null,null,null,null,76,{"$f":"EXP(MMULT(It0!G77:H77,B$2:B$3))","v":2.2060629306414712},0.68809096339231268,0.2146217894901517,2.2445056731076569,0.46327291037805318,25.480010070792925,1.0398186755406356]
[null,null,null,null,null,77,{"$f":"EXP(MMULT(It0!G78:H78,B$2:B$3))","v":2.4648491026745414},0.71138714259501434,0.20531547594551508,2.3078349384304935,0.45311750787794008,25.374580441164646,1.0457204158952644]
[null,null,null,null,null,78,{"$f":"EXP(MMULT(It0!G79:H79,B$2:B$3))","v":2.4648491026745414},0.71138714259501434,0.20531547594551508,2.3078349384304935,0.45311750787794008,25.374580441164646,1.0457204158952644]
[null,null,null,null,null,79,{"$f":"EXP(MMULT(It0!G80:H80,B$2:B$3))","v":2.4648491026745414},0.71138714259501434,0.20531547594551508,2.3078349384304935,0.45311750787794008,25.374580441164646,1.0457204158952644]
[null,null,null,null,null,80,{"$f":"EXP(MMULT(It0!G81:H81,B$2:B$3))","v":2.7539926511474828},0.73361695322063825,0.19542311916790611,-2.740940919273235,0.44206687182812748,25.197811694203267,-1.2116791780488312]
[null,null,null,null,null,81,{"$f":"EXP(MMULT(It0!G82:H82,B$2:B$3))","v":2.7539926511474828},0.73361695322063825,0.19542311916790611,-2.740940919273235,0.44206687182812748,25.197811694203267,-1.2116791780488312]
[null,null,null,null,null,82,{"$f":"EXP(MMULT(It0!G83:H83,B$2:B$3))","v":2.7539926511474828},0.73361695322063825,0.19542311916790611,2.3761609070506369,0.44206687182812748,25.197811694203267,1.050422019140161]
[null,null,null,null,null,83,{"$f":"EXP(MMULT(It0!G84:H84,B$2:B$3))","v":2.7539926511474828},0.73361695322063825,0.19542311916790611,2.3761609070506369,0.44206687182812748,25.197811694203267,1.050422019140161]
[null,null,null,null,null,84,{"$f":"EXP(MMULT(It0!G85:H85,B$2:B$3))","v":2.7539926511474828},0.73361695322063825,0.19542311916790611,2.3761609070506369,0.44206687182812748,25.197811694203267,1.050422019140161]
[null,null,null,null,null,85,{"$f":"EXP(MMULT(It0!G86:H86,B$2:B$3))","v":2.7539926511474828},0.73361695322063825,0.19542311916790611,2.3761609070506369,0.44206687182812748,25.197811694203267,1.050422019140161]
[null,null,null,null,null,86,{"$f":"EXP(MMULT(It0!G87:H87,B$2:B$3))","v":3.0770547025960457},0.75472489997172354,0.18511522533439545,-2.9530818285148976,0.43025018923225988,24.954510975471074,-1.2705640155368827]
[null,null,null,null,null,87,{"$f":"EXP(MMULT(It0!G88:H88,B$2:B$3))","v":3.0770547025960457},0.75472489997172354,0.18511522533439545,2.44895897171416,0.43025018923225988,24.954510975471074,1.0536650610020579]
[null,null,null,null,null,88,{"$f":"EXP(MMULT(It0!G89:H89,B$2:B$3))","v":3.0770547025960457},0.75472489997172354,0.18511522533439545,2.44895897171416,0.43025018923225988,24.954510975471074,1.0536650610020579]
[null,null,null,null,null,89,{"$f":"EXP(MMULT(It0!G90:H90,B$2:B$3))","v":3.4380141278965932},0.77467399355171662,0.17455419726635155,2.5257596040370447,0.41779683731013517,24.650013401297976,1.0552543743723766]
[null,null,null,null,null,90,{"$f":"EXP(MMULT(It0!G91:H91,B$2:B$3))","v":3.4380141278965932},0.77467399355171662,0.17455419726635155,2.5257596040370447,0.41779683731013517,24.650013401297976,1.0552543743723766]
[null,null,null,null,null,91,{"$f":"EXP(MMULT(It0!G92:H92,B$2:B$3))","v":3.8413165465158419},0.79344461565528668,0.16389025754292108,-3.4955013880208954,0.40483361711068544,24.290017026641127,-1.4150964705279208]
[null,null,null,null,null,92,{"$f":"EXP(MMULT(It0!G93:H93,B$2:B$3))","v":3.8413165465158419},0.79344461565528668,0.16389025754292108,2.6061425717374256,0.40483361711068544,24.290017026641127,1.0550541240226059]
[null,null,null,null,null,93,{"$f":"EXP(MMULT(It0!G94:H94,B$2:B$3))","v":4.291929079292081},0.81103299288096786,0.15325847733950779,2.6897317630045325,0.39148241000012735,23.880427010007768,1.0529826728349059]
[null,null,null,null,null,94,{"$f":"EXP(MMULT(It0!G95:H95,B$2:B$3))","v":4.7954015240896792},0.82744940176391379,0.14277688928445498,2.7761905542606331,0.37785829259717851,23.427214141025068,1.0490066227573376]
[null,null,null,null,null,95,{"$f":"EXP(MMULT(It0!G96:H96,B$2:B$3))","v":4.7954015240896792},0.82744940176391379,0.14277688928445498,2.7761905542606331,0.37785829259717851,23.427214141025068,1.0490066227573376]
[null,null,null,null,null,96,{"$f":"EXP(MMULT(It0!G97:H97,B$2:B$3))","v":5.3579347077735502},0.84271622060268303,0.1325455921358131,2.8652176642647733,0.36406811469258482,22.936291225632843,1.0431343932127675]
[null,null,null,null,null,97,{"$f":"EXP(MMULT(It0!G98:H98,B$2:B$3))","v":5.9864568563346809},0.85686593067653583,0.12264670752236993,-5.1969571290121355,0.35020951946280665,22.413409245619626,-1.8200238588201472]
[null,null,null,null,null,98,{"$f":"EXP(MMULT(It0!G99:H99,B$2:B$3))","v":5.9864568563346809},0.85686593067653583,0.12264670752236993,2.9565434434969697,0.35020951946280665,22.413409245619626,1.0354096586179855]
[null,null,null,null,null,99,{"$f":"EXP(MMULT(It0!G100:H100,B$2:B$3))","v":6.6887089237503208},0.86993915234441854,0.11314502356269308,3.0499265531224626,0.33637036665362346,21.864073832485523,1.0259049129404247]
[null,null,null,null,null,100,{"$f":"EXP(MMULT(It0!G101:H101,B$2:B$3))","v":10.42394369527571},0.91246455456415254,7.9872991228195231E-2,3.4400384200800009,0.28261810138098947,19.500648995288273,0.97221712696066853]