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

{"sheet":"Histograma1","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,2],[2,0,2,2]]}
["Altura de 100 personas (cm)"]
[]
["Tabla de frecuencias"]
["Intervalos","Frecuencia ","Frecuencia acumulada"]
["[150-160]",16,{"$f":"+B5","v":16}]
["[160-170]",54,{"$f":"+B6+C5","v":70}]
["[170-180]",18,{"$f":"+B7+C6","v":88}]
["[180-190]",10,98]
["[190-200]",2,100]

{"sheet":"Histograma2","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,1,2],[2,0,2,2]]}
["Altura de 88 personas (cm)"]
[]
["Tabla de frecuencias"]
["Intervalos","Frecuencia ","Frecuencia acumulada"]
["[150-157]",12,12]
["[157-164]",11,23]
["[164-171]",15,38]
["[171-178]",12,50]
["[178-185]",12,62]
["[185-192]",15,77]
["[192-199]",8,85]
["[199-206]",3,88]

{"sheet":"Construir Tabla de Frecuencias ","index":2,"n_rows":89,"n_cols":10,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,6,0,7]]}
["Datos(Altura en cm)",null,"Regla de Sturges",null,null,null,"Intervalos",null,"Frecuencia","Frec. Abs."]
[155,null,null,null,null,null,{"$f":"+MIN(A2:A89)","v":150},{"$f":"+G2+$E$9","v":157},{"$f":"+FREQUENCY(A2:A89,H2:H9)","v":12},{"$f":"+I2","v":12}]
[192,null,"Número de elementos",null,{"$f":"COUNT(A2:A89)","v":88},null,{"$f":"+H2","v":157},{"$f":"+G3+$E$9","v":164},11,{"$f":"+J2+I3","v":23}]
[192,null,null,null,null,null,{"$f":"+H3","v":164},{"$f":"+G4+$E$9","v":171},15,{"$f":"+J3+I4","v":38}]
[188,null,"Número de clases: K=",null,{"$f":"ROUNDUP(1+3.322*LOG(E3),0)","v":8},null,{"$f":"+H4","v":171},{"$f":"+G5+$E$9","v":178},12,{"$f":"+J4+I5","v":50}]
[189,null,null,null,null,null,178,185,12,62]
[173,null,null,"Rango: R=",{"$f":"+MAX(A2:A89)-MIN(A2:A89)","v":50},null,185,192,15,77]
[182,null,null,null,null,null,192,199,8,85]
[164,null,"Amplitud intervalo: A=",null,{"$f":"+ROUNDUP(E7/E5,0)","v":7},null,{"$f":"+H8","v":199},206,3,88]
[161,null,null,null,null,null,null,null,0]
[198]
[173,null,null,"Intervalo","Frecuencia","Frec. Abs."]
[156,null,null,"[150-157]",12,12]
[183,null,null,"[157-164]",11,23]
[168,null,null,"[164-171]",15,38]
[184,null,null,"[171-178]",12,50]
[154,null,null,"[178-185]",12,62]
[178,null,null,"[185-192]",15,77]
[182,null,null,"[192-199]",8,85]
[168,null,null,"[199-206]",3,88]
[182]
[193]
[180]
[187]
[168]
[178]
[161]
[186]
[185]
[170]
[164]
[164]
[185]
[189]
[169]
[153]
[169]
[158]
[183]
[200]
[152]
[188]
[189]
[174]
[176]
[191]
[190]
[165]
[157]
[185]
[152]
[156]
[170]
[200]
[195]
[154]
[180]
[187]
[165]
[170]
[190]
[175]
[164]
[165]
[173]
[199]
[150]
[161]
[153]
[184]
[170]
[193]
[168]
[152]
[186]
[171]
[175]
[160]
[170]
[193]
[174]
[177]
[159]
[164]
[172]
[200]
[190]
[197]
[193]