{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cálculo de s²","Cálculo de g","IC Media 1","IC Media 2","IC Proporción","Datos pareados"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":0,"defined_names":5,"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":"Cálculo de s²","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"A) Cuando las varianzas poblacionales SON CONOCIDAS:"]
[null,null,null,null,null,null,"Población 1","Población 2"]
[null,null,null,null,null,"Varianza = "]
[null,null,null,null,null,"Desv estandar = "]
[null,null,null,null,null,"n = "]
[]
[null,null,null,null,null,null,{"$f":"IF(AND(G7>0,H7>0),IF(G5>0,G5,G6^2)/G7+IF(H5>0,H5,H6^2)/H7,\"\")","v":""},null,{"$f":"IF(ISNUMBER(G9),SQRT(G9),\"\")","v":""}]
[]
[]
[null,"B) Cuando las varianzas poblacionales SON DESCONOCIDAS:"]
[null,null,null,null,null,null,"Muestra 1","Muestra 2"]
[null,null,0,null,null,"Varianza = "]
[null,null,null,null,null,"Desv estandar = "]
[null,null,null,null,null,"n = "]
[null,null,null,null,null,null,{"$f":"IF(C14=1,IF(AND(G16>0,H16>0),IF(G14>0,(G16-1)*G14+(H16-1)*H14,(G16-1)*G15^2+(H16-1)*H15^2)/(G16+H16-2)*(1/G16+1/H16),\"\"),\"\")","v":""},null,{"$f":"IF(ISNUMBER(G17),SQRT(G17),\"\")","v":""}]
[]
[]
[null,null,"Suponiendo que son diferentes:",null,null,null,{"$f":"IF(C14=2,IF(AND(G16>0,H16>0),IF(G14>0,G14/G16+H14/H16,G15^2/G16+H15^2/H16),\"\"),\"\")","v":""},null,{"$f":"IF(ISNUMBER(G20),SQRT(G20),\"\")","v":""}]

{"sheet":"Cálculo de g","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Muestra 1","Muestra 2"]
[null,null,"Varianza = "]
[null,null,"Desv estandar = "]
[null,null,"n = "]
[]
[null,null,"g = ",{"$f":"IF(AND(D6>0,E6>0),IF(AND(D4>0,E4>0),(D4/D6+E4/E6)^2/((D4/D6)^2/(D6+1)+(E4/E6)^2/(E6+1))-2,(D5^2/D6+E5^2/E6)^2/((D5^2/D6)^2/(D6+1)+(E5^2/E6)^2/(E6+1))-2),\"\")","v":""}]

{"sheet":"IC Media 1","index":2,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[]
[]
["Por el Teorema del Límite Central, usarmos la distribución Normal",null,null,null,null,null,null,null,null,"Usaremos la distribución t de Student, suponiendo población normal"]
[]
[null,null,"Población"]
[null,"Varianza = "]
[null,"O desv. Estándar = ",10,null,null,null,null,null,null,null,null,"Muestra"]
[null,null,"Muestra",null,null,null,null,null,null,null,"Media = ",790]
[null,"Media = ",70,null,null,null,null,null,null,null,"Varianza = ",125]
[null,"n  = ",100,null,null,null,null,null,null,null,"O la desv. Estándar = "]
[null,"Nivel de confianza = ",95,"(en porcentaje)",null,null,null,null,null,null,"n = ",9]
[null,null,null,null,null,null,null,null,null,null,"Nivel de confianza = ",95,"(en porcentaje)"]
[]
[null,null,{"$f":"IF(C10>0,IF(C6>0,SQRT(C6/C10),C7/SQRT(C10)),\"\")","v":1},null,null,null,null,null,null,null,null,{"$f":"IF(L11>0,IF(L9>0,SQRT(L9/L11),L10/SQRT(L11)),\"\")","v":3.7267799624996494}]
[]
[null,null,{"$f":"IF(C11<>0,NORMSINV(1-(1-C11/100)/2),\"\")","v":1.959963984540054},null,null,null,null,null,null,null,null,{"$f":"IF(L12<>0,TINV(1-L12/100,(L11-1)),\"\")","v":2.3060041332991164}]
[null,"El intervalo de confianza del ",{"$f":"C11/100","v":0.95},{"$f":"TEXT(C17*100,\"#####.##\")","v":"95."},{"$f":"LEFT(D17,FIND(\".\",D17)-1)","v":"95"},null,null,null,null,null,"El intervalo de confianza del ",{"$f":"L12/100","v":0.95},{"$f":"TEXT(L17*100,\"#####.##\")","v":"95."},{"$f":"LEFT(M17,FIND(\".\",M17)-1)","v":"95"}]
[null,{"$f":"CONCATENATE(B17,E17,\"% para μ es: \")","v":"El intervalo de confianza del 95% para μ es: "},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(K17,N17,\"% para μ es: \")","v":"El intervalo de confianza del 95% para μ es: "}]
[]
[null,{"$f":"IF(C14>0,C9-C16*C14,\"\")","v":68.040036015459947},"      ≤  μ  ≤      ",{"$f":"IF(C14>0,C9+C16*C14,\"\")","v":71.959963984540053},null,null,null,null,null,null,{"$f":"IF(L14>0,L8-L14*L16,\"\")","v":781.40603000257943},"      ≤  μ  ≤      ",{"$f":"IF(L14>0,L8+L16*L14,\"\")","v":798.59396999742057}]

{"sheet":"IC Media 2","index":3,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,2,5],[5,14,5,17]]}
[]
[]
["Por el Teorema del Límite Central, usarmos la distribución Normal"]
[]
[null,null,"Población 1","Población 2"]
[null,"Varianzas = ",null,null,null,null,null,null,null,null,null,null,null,null,"Intervalo de confianza para el cociente de varianzas"]
[null,"Desv. Est. = ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L11>0,M11>0),FINV(1-(1-L12/100)/2,M11-1,L11-1),\"\")","v":0.28787755797347059}]
[null,null,null,null,null,null,null,null,null,null,null,"Muestra 1","Muestra 2",null,null,null,{"$f":"IF(AND(L11>0,M11>0),FINV((1-L12/100)/2,M11-1,L11-1),\"\")","v":3.4736990512200876}]
[null,null,"Muestra 1","Muestra 2",null,null,null,null,null,null,"Medias = ",36300,38100,null,"  "]
[null,"Medias = ",null,null,null,null,null,null,null,null,"Varianzas, s² = ",{"$f":"100^2","v":10000},{"$f":"150^2","v":22500},null,{"$f":"CONCATENATE($K$17,$N$17,\"% para σ²1 / σ²2 es: \")","v":"El intervalo de confianza del 95% para σ²1 / σ²2 es: "}]
[null,"n = ",null,null,null,null,null,null,null,null,"n = ",12,12]
[null,"Nivel de confianza = ",null,null,null,null,null,null,null,null,"Nivel de confianza = ",95,null,null,null,{"$f":"IF(Q7>0,L10/M10*Q7,\"\")","v":0.12794558132154249},"≤  σ²1 / σ²2  ≤ ",{"$f":"IF(Q8>0,L10/M10*Q8,\"\")","v":1.5438662449867055}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L11>0,M11>0),((L10/L11+M10/M11)^2/((L10/L11)^2/(L11+1)+(M10/M11)^2/(M11+1)))-2,\"\")","v":20.649484536082475},null,null,null,null,{"$f":"IF(R12<>\"\",IF(AND(R12>=1,P12<1),1,0),\"\")","v":1}]
[null,null,{"$f":"IF(AND(C6>0,D6>0,C11>0,D11>0),SQRT(C6/C11+D6/D11),IF(AND(C7>0,D7>0,C11>0,D11>0),SQRT(C7^2/C11+D7^2/D11),\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Q13=1,SQRT(((L11-1)*L10+(M11-1)*M10)/(L11+M11-2)*(1/L11+1/M11)),SQRT(L10/L11+M10/M11))","v":52.041649986653319}]
[null,null,{"$f":"IF(C12<>0,NORMSINV(1-(1-C12/100)/2),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Q13=1,TINV((1-L12/100),L11+M11-2),TINV((1-L12/100),INT(GLib2)))","v":2.0738730583156064}]
[]
[null,"El intervalo de confianza del ",{"$f":"C12/100","v":0},{"$f":"TEXT(C17*100,\"#####.##\")","v":"."},{"$f":"LEFT(D17,FIND(\".\",D17)-1)","v":""},null,null,null,null,null,"El intervalo de confianza del ",{"$f":"L12/100","v":0.95},{"$f":"TEXT(L17*100,\"#####.##\")","v":"95."},{"$f":"LEFT(M17,FIND(\".\",M17)-1)","v":"95"}]
[null,{"$f":"CONCATENATE(B17,E17,\"% para  μ1 – μ2  es: \")","v":"El intervalo de confianza del % para  μ1 – μ2  es: "},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($K$17,$N$17,\"% para  μ1 – μ2  es: \")","v":"El intervalo de confianza del 95% para  μ1 – μ2  es: "}]
[]
[null,{"$f":"IF(ISERROR((C10-D10)-C15*C14),\"\",(C10-D10)-C15*C14)","v":""}," ≤  μ1 – μ2  ≤  ",{"$f":"IF(ISERROR((C10-D10)+C15*C14),\"\",(C10-D10)+C15*C14)","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR((L9-M9)-L15*L14),\"\",(L9-M9)-L15*L14)","v":-1907.9277758176111}," ≤  μ1 – μ2  ≤  ",{"$f":"IF(ISERROR((L9-M9)+L15*L14),\"\",(L9-M9)+L15*L14)","v":-1692.0722241823889}]

{"sheet":"IC Proporción","index":4,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,6,15,9],[0,2,0,4],[13,2,13,5],[13,8,13,11],[9,7,9,8]]}
[null,null,"Datos de la muestra:"]
[]
[null,null,null,"Muestra 1","Muestra 2"]
[null,null,"Tamaño = ",40,50]
[null,null,"Nro. casos o eventos = ",10,15]
[null,null,"Proporción muestral = ",{"$f":"IF(ISERROR(D5/D4),\"\",D5/D4)","v":0.25},{"$f":"IF(ISERROR(E5/E4),\"\",E5/E4)","v":0.3}]
[null,null,"Nivel de confianza(en %) = ",95,2]
[null,null,null,{"$f":"NORMSINV(1-(1-D7/100)/2)","v":1.959963984540054}]
[null,null,"El Intervalo de confianza del ",{"$f":"D7","v":95}]
[]
[]
[]
[null,null,null,{"$f":"IF(ISERROR(SQRT(D6*(1-D6)/D4)),\"\",SQRT(D6*(1-D6)/D4))","v":6.8465319688145759E-2},null,null,null,null,{"$f":"IF(ISERROR(SQRT(D6*(1-D6)/D4+E6*(1-E6)/E4)),\"\",SQRT(D6*(1-D6)/D4+E6*(1-E6)/E4))","v":9.4273538174824006E-2}]
[null,null,{"$f":"CONCATENATE(C9,D9,\"%  para π es:\")","v":"El Intervalo de confianza del 95%  para π es:"},null,null,null,null,null,{"$f":"CONCATENATE(C9,D7,\"% para π1 - π2 es: \")","v":"El Intervalo de confianza del 95% para π1 - π2 es: "}]
[]
[null,null,null,null,null,null,{"$f":"CHOOSE(E7,C14,I14)","v":"El Intervalo de confianza del 95% para π1 - π2 es: "}]
[]
[null,null,null,null,null,null,null,"Lím. Inferior",null,"Lím. Superior"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(CHOOSE($E$7,D6-D8*D13,(D6-E6)-D8*I13)),\"\",CHOOSE($E$7,D6-D8*D13,(D6-E6)-D8*I13))","v":-0.23477273951781694},null,{"$f":"IF(ISERROR(CHOOSE($E$7,D6+D8*D13,(D6-E6)+D8*I13)),\"\",CHOOSE($E$7,D6+D8*D13,(D6-E6)+D8*I13))","v":0.13477273951781696}]

{"sheet":"Datos pareados","index":5,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[18,6,18,9]]}
["Antes (X)","Depués (Y)",null,"D"]
[null,null,null,{"$f":"IF(AND(A2<>\"\",B2<>\"\"),A2-B2,\"\")","v":""}]
[null,null,null,"",null,"Nivel de confianza: "]
[null,null,null,"",null,null,{"$f":"IF(G3<>\"\",TINV((1-G3/100),COUNT(Difer)-1),\"\")","v":""}]
[null,null,null,""]
[null,null,null,"",null,"Estadísticas muestrales de D:"]
[null,null,null,""]
[null,null,null,"",null,null,null,{"$f":"IF(D2<>\"\",AVERAGE(Difer),\"\")","v":""}]
[null,null,null,""]
[null,null,null,"",null,null,null,{"$f":"IF(D2<>\"\",VAR(Difer),\"\")","v":""}]
[null,null,null,""]
[null,null,null,"",null,null,null,{"$f":"IF(H10<>\"\",SQRT(H10),\"\")","v":""}]
[null,null,null,""]
[null,null,null,"",null,null,null,{"$f":"IF(H8<>\"\",H10/COUNT(Difer),\"\")","v":""}]
[null,null,null,""]
[null,null,null,"",null,null,null,{"$f":"IF(H14<>\"\",SQRT(H14),\"\")","v":""}]
[null,null,null,""]
[null,null,null,"",null,null,"El intervalo de confianza del ",{"$f":"TEXT(G3,\"##.##\")","v":"."},"% para la media es:"]
[null,null,null,"",null,null,{"$f":"CONCATENATE(G18,H18,I18)","v":"El intervalo de confianza del .% para la media es:"}]
[null,null,null,""]
[null,null,null,"",null,null,{"$f":"IF(H16<>\"\",H8-G4*H16,\"\")","v":""},null,{"$f":"IF(H16<>\"\",H8+G4*H16,\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]