{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Aislados","Discretos con frecuencias","Instrucciones"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Aislados","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,7],[6,7,6,8],[8,7,8,8],[9,7,10,8],[12,7,12,8]]}
[]
[null,"Cálculo de los cuantiles de una distribución estadística"]
[]
[null,null,null,null,null,null,null,null,"A. Roldán 2016"]
["Datos aislados"]
[]
["Si lo deseas, borra la zona de datos con este botón",null,null,null,null,null,null,"Instrucciones en la hoja 3"]
["Escribe los datos aislados en el rectángulo inferior y obtendrás los cuantiles"]
[null,null,null,null,null,null,null,"Cálculo de un cuantil concreto"]
[null,null,null,null,null,null,null,"Escribe el porcentaje del cuantil"]
[]
[null,2]
[null,4,null,null,null,null,null,60]
[null,4,null,null,null,null,null,"Cuantil:",{"$f":"PERCENTILE(datos,H13/100)","v":4.2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,5]
[null," "]
["Estadísticos"]
[]
["Cuartil 1",{"$f":"QUARTILE(datos,1)","v":3.75}]
["Mediana",{"$f":"QUARTILE(datos,2)","v":4}]
["Cuartil 3",{"$f":"QUARTILE(datos,3)","v":5}]
["Máximo",{"$f":"MAX(datos)","v":6}]
["Mínimo",{"$f":"MIN(datos)","v":2}]
["Rango",{"$f":"B26-B27","v":4}]
["Moda",{"$f":"MODE($A$11:$F$20)","v":4}]
["Semiintervalo"," "]
["Intercuartílico",{"$f":"(B25-B23)/2","v":0.625}]
["Asimetría de "]
["Bowley",{"$f":"(B25+B23-B24*2)/(B25-B23)","v":0.6}]
["Curtosis",{"$f":"(B25-B23)/2/(PERCENTILE(datos,0.9)-PERCENTILE(datos,0.1))","v":0.24038461538461542}]

{"sheet":"Discretos con frecuencias","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,6,13,7],[2,6,2,7],[6,6,6,7],[7,6,8,7],[10,6,10,7],[12,6,12,7]]}
[null,null,null,null,null,null,null,"A. Roldán 2016"]
[]
["Datos discretos con frecuencias",null,null,null,null,null,"Instrucciones en la hoja 3"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Zona de cálculos auxiliares NO TOCAR"]
["  DATOS","  FREC."," F.ACUM.","   %","  ZONAS",null,"Cálculo de un cuantil concreto",null,null,10,25,50,75,90]
[2,2,{"$f":"IF(B8<>0,B8,\" \")","v":2},{"$f":"IF(C8<>0,C8*100/$B$21,\" \")","v":9.5238095238095237},{"$f":"IF(D8<>0,IF(D8<=100,IF(D8<=$G$11,0,1),\" \"),\" \")","v":0},null,"Escribe el porcentaje del cuantil",null,null,{"$f":"IF($D8<>0,IF($D8<=100,IF($D8<=J$7,0,1),\" \"),\" \")","v":0},0,0,0,0]
[3,3,{"$f":"IF(B9<>0,B9+C8,\" \")","v":5},23.80952380952381,0,null,null,null,null,1,0,0,0,0]
[4,5,10,47.61904761904762,0,null,null,null,null,1,1,0,0,0]
[5,6,16,76.19047619047619,0,null,80,null,null,1,1,1,1,0]
[6,4,20,95.238095238095241,1,null,null,null,null,1,1,1,1,1]
[7,1,21,100,1,null,"Escribe la amplitud",null,null,1,1,1,1,1]
[null,null," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,1,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Datos del cuantil",null,{"$f":"MATCH(1,$E$8:$E$20,0)","v":5},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Num. Intervalo",{"$f":"I16","v":5},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Límite inferior",{"$f":"INDEX(A8:A20,I16)-ABS(G14/2)","v":5.5},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Amplitud",{"$f":"G14","v":1},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Total:",{"$f":"SUM(B8:B20)","v":21},null,null,null,null,"Frec. anterior",{"$f":"IF(H18>1,INDEX(C8:C20,I16-1),0)","v":16},null,{"$f":"MATCH(1,J8:J20,0)","v":2},{"$f":"MATCH(1,K8:K20,0)","v":3},{"$f":"MATCH(1,L8:L20,0)","v":4},{"$f":"MATCH(1,M8:M20,0)","v":4},{"$f":"MATCH(1,N8:N20,0)","v":5}]
[null,null,null,null,null,null,"Frec. Intervalo",{"$f":"INDEX(B8:B20,I16)","v":4},null,{"$f":"INDEX($A8:$A20,J21)-ABS($G$14/2)","v":2.5},{"$f":"INDEX($A8:$A20,K21)-ABS($G$14/2)","v":3.5},{"$f":"INDEX($A8:$A20,L21)-ABS($G$14/2)","v":4.5},{"$f":"INDEX($A8:$A20,M21)-ABS($G$14/2)","v":4.5},{"$f":"INDEX($A8:$A20,N21)-ABS($G$14/2)","v":5.5}]
[null,null,null,null,null,null,null,null,null,{"$f":"$G$14","v":1},{"$f":"$G$14","v":1},{"$f":"$G$14","v":1},{"$f":"$G$14","v":1},{"$f":"$G$14","v":1}]
[null,null,null,null,null,null,"Cuantil:",{"$f":"H19+(B21*G11/100-H21)/H22*H20","v":5.7},null,{"$f":"IF(J22>1,INDEX($C$8:$C$20,J21-1),0)","v":2},{"$f":"IF(K22>1,INDEX($C$8:$C$20,K21-1),0)","v":5},{"$f":"IF(L22>1,INDEX($C$8:$C$20,L21-1),0)","v":10},{"$f":"IF(M22>1,INDEX($C$8:$C$20,M21-1),0)","v":10},{"$f":"IF(N22>1,INDEX($C$8:$C$20,N21-1),0)","v":16}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX($B$8:$B$20,J21)","v":3},{"$f":"INDEX($B$8:$B$20,K21)","v":5},{"$f":"INDEX($B$8:$B$20,L21)","v":6},{"$f":"INDEX($B$8:$B$20,M21)","v":6},{"$f":"INDEX($B$8:$B$20,N21)","v":4}]
[{"$f":"K26","v":3.55},null,null,null,null,null,null,null,null,{"$f":"J22+($B$21*J7/100-J24)/J25*$G$14","v":2.5333333333333332},{"$f":"K22+($B$21*K7/100-K24)/K25*$G$14","v":3.55},{"$f":"L22+($B$21*L7/100-L24)/L25*$G$14","v":4.583333333333333},{"$f":"M22+($B$21*M7/100-M24)/M25*$G$14","v":5.458333333333333},{"$f":"N22+($B$21*N7/100-N24)/N25*$G$14","v":6.2249999999999996}]
[{"$f":"L26","v":4.583333333333333}]
[{"$f":"M26","v":5.458333333333333}]
[" "]
[{"$f":"(M26-K26)/2","v":0.95416666666666661}]
[]
[{"$f":"(K26+M26-L26*2)/(M26-K26)","v":-8.2969432314410424E-2}]
[{"$f":"(M26-K26)/2/(N26-J26)","v":0.2584650112866817}]

{"sheet":"Instrucciones","index":2,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,2,3,5]]}
[]
[]
[null,null,"Instrucciones"]
[]
[]
[]
[null,"Datos aislados"]
[]
[null,"Entrada de datos"]
[null,"En la hoja 1 están explicadas las operaciones:"]
[null,"Se borran los datos con el botón correspondiente"]
[null,"Se escriben los datos en cualquier orden y posición dentro del rectángulo de color azul."]
[null,"Se ignorarán los datos que no sean numéricos."]
[]
[null,"Cálculo de cualquier cuantil"]
[null,"En la celda H13 se escribe el porcentaje deseado, por ejemplo 50 para la mediana, 25 para Q1, 90 para D9..."]
[null,"En la celda amarilla inferior obtendrás el cuantil correspondiente."]
[]
[null,"Estadísticos"]
[null,"La tabla de estadísticos de orden se calcula de forma automática. En el apartado de Teoría"]
[null,"puedes consultar el significado de cada uno."]
[]
[null,"Datos discretos"]
[]
[null,"Entrada de datos"]
[null,"Se borran los datos con el botón correspondiente"]
[null,"Los valores de los datos se escriben en la columna “Datos”, dentro de la zona de color salmón."]
[null,"Los valores de las frecuencias se escriben en la siguiente columna de color verde pastel"]
[null,"No se debe escribir en las siguientes columnas de datos"]
[null,"Es imprecindible escribir la diferencia entre dos datos consecutivos (amplitud) en la celda H14"]
[]
[null,"Cálculo de cualquier cuantil"]
[null,"En la celda H11 se escribe el porcentaje deseado, por ejemplo 50 para la mediana, 25 para Q1, 90 para D9..."]
[null,"En la celda amarilla I24 obtendrás el cuantil correspondiente."]