{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["RECOLECTARDATOS","EDAD","ESTATURAS","GENEROS MUSICALES","Hoja6","RESUMEN."],"not_rendered":{"charts":3,"images":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"RECOLECTARDATOS","index":0,"n_rows":35,"n_cols":6,"rows_kept":35}
[]
[null,"No.","ESTUDIANTE","EDAD","ESTATURA","GENERO MÚSICAL"]
[null,1,"ALCALA RAMIREZ GABRIELA HAYDEE",19,1.53,"POP"]
[null,2,"ANGUIANO CALDERON FATIMA LIZBETH",18,1.63,"POP"]
[null,3,"CEPEDA GARCIA PERLA ABIGAIL",23,1.55,"POP"]
[null,4,"CUADROS CALVILLO IMELDA PATRICIA",18,1.64,"REGUETON"]
[null,5,"DE LA GARZA SANCHEZ REGINA",17,{"v":1.6,"d":"1.60"},"REGUETON"]
[null,6,"DOMINGUEZ FLORES JOSELYN ANDREA",19,1.6,"REGUETON"]
[null,7,"ESCOLASTICO RUIZ ALESSANDRA",19,1.57,"HIP HOP"]
[null,8,"GARCIA ESCOBEDO JENIFER JANETH",19,1.58,"REGUETON"]
[null,9,"GAYTAN BERMEA ANDREA",18,1.63,"REGUETON"]
[null,10,"GONZALEZ LOMAS LORENA ALEJANDRA",20,1.73,"ALTERNATIVO"]
[null,11,"GONZALEZ PALOMO DEVANI MONSERRATH",20,1.56,"POP"]
[null,12,"GUTIERREZ CISNEROS GABRIELA BERENICE",18,1.53,"POP"]
[null,13,"GUTIERREZ FONSECA TANIA MELISA",19,1.6,"POP"]
[null,14,"HERNANDEZ SERRANO ARELY",22,1.6,"ROCK"]
[null,15,"HERRERA IBARRA CLAUDIA FERNANDA",17,1.59,"ALTERNATIVO"]
[null,16,"HUERTA JIMENEZ MARIA FERNANDA",19,1.64,"REGUETON"]
[null,17,"MARTINEZ PONCE ANA PAOLA",18,1.68,"R&B"]
[null,18,"MONTOYA SILVA JULIA YESSENIA",23,1.6,"ALTERNATIVO"]
[null,19,"ONTIVEROS RODRIGUEZ MAYRA RUBY",19,1.65,"ALTERNATIVO"]
[null,20,"PEÑA FARIAS ANA PAOLA",18,1.63,"POP"]
[null,21,"RAMIREZ MEDINA YUMIKO",20,1.67,"POP"]
[null,22,"REALPOZO HARO RANIA ROMINA",20,1.65,"POP"]
[null,23,"ROCHA VICUÑA XIMENA GUADALUPE",20,1.6,"REGUETON"]
[null,24,"SALAS CASTILLO JOHANA VANESSA",27,1.65,"REGAE"]
[null,25,"SANCHEZ MONCADA ESTRELLA JANETH",18,1.73,"RAP"]
[null,26,"SEGOVIA LUCIO BRITANIA SCARLETT",18,1.67,"CORRIDOS"]
[null,27,"SERRATO MONTENEGRO ANA PAULINA",20,1.61,"POP"]
[null,28,"VALDEZ RIOS MONSERRATH",18,1.68,"ALTERNATIVO"]
[]
[]
[null,null,"MODA",{"$f":"_xlfn.MODE.SNGL(D3:D30)","v":{"v":18,"d":"18.00"}},{"$f":"_xlfn.MODE.SNGL(E3:E30)","v":{"v":1.6,"d":"1.60"}},"POP"]
[null,null,"MEDIANA",{"$f":"MEDIAN(Tabla7[EDAD])","v":{"v":19,"d":"19.00"}},{"$f":"MEDIAN(Tabla7[ESTATURA])","v":1.62}]
[null,null,"MEDIA ARITMETICA",{"$f":"AVERAGE(D3:D30)","v":{"v":19.428571428571427,"d":"19.43"}},{"$f":"AVERAGE(E3:E30)","v":{"v":1.6214285714285714,"d":"1.62"}}]

{"sheet":"EDAD","index":1,"n_rows":31,"n_cols":8,"rows_kept":31}
[]
["EDAD","FRECUENCIA","FR","%","Columna1"]
[17,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,17)","v":2},{"$f":"B3/28","v":0.07142857142857142},{"$f":"(C3*100)","v":{"v":7.142857142857142,"d":"7.14285714"}},{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":2,"d":"200%"}}]
[18,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,18)","v":9},0.32142857142857145,32.142857142857146,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":9,"d":"900%"}}]
[19,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,19)","v":7},0.25,25,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":7,"d":"700%"}}]
[20,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,20)","v":6},0.21428571428571427,21.428571428571427,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":6,"d":"600%"}}]
[21,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,21)","v":0},0,0,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":0,"d":"0%"}}]
[22,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,22)","v":1},0.03571428571428571,3.571428571428571,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":1,"d":"100%"}}]
[23,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,23)","v":2},0.07142857142857142,7.142857142857142,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":2,"d":"200%"}}]
[24,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,24)","v":0},0,0,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":0,"d":"0%"}}]
[25,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,25)","v":0},0,0,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":0,"d":"0%"}}]
[26,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,26)","v":0},0,0,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":0,"d":"0%"}}]
[27,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,27)","v":1},0.03571428571428571,3.571428571428571,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":{"v":1,"d":"100%"}}]
["Total",{"$f":"SUM(B3:B13)","v":28},1,100,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":28}]
[]
["EDADES","f","fr","%","F2","marca de clase","MC*F","LI"]
["17-19",18,{"$f":"B17/28","v":0.6428571428571429},{"$f":"(C17*100)","v":64.28571428571429},{"$f":"(C17)","v":{"v":0.6428571428571429,"d":"64%"}},{"$f":"(17+19)/2","v":{"v":18,"d":"18.00"}},{"$f":"Tabla2[[#This Row],[marca de clase]]*(Tabla2[[#This Row],[f]])","v":324}]
["20-22",7,{"$f":"B18/28","v":0.25},{"$f":"(C18*100)","v":25},{"$f":"(C18)","v":{"v":0.25,"d":"25%"}},{"$f":"(20+22)/2","v":{"v":21,"d":"21.00"}},{"$f":"Tabla2[[#This Row],[marca de clase]]*(Tabla2[[#This Row],[f]])","v":147}]
["23-25",2,{"$f":"B19/28","v":0.07142857142857142},7.142857142857142,{"$f":"(C19)","v":{"v":0.07142857142857142,"d":"7%"}},{"$f":"(23+25)/2","v":{"v":24,"d":"24.00"}},{"$f":"Tabla2[[#This Row],[marca de clase]]*(Tabla2[[#This Row],[f]])","v":48}]
["26-28",1,{"$f":"B20/28","v":0.03571428571428571},3.571428571428571,{"$f":"(C20)","v":{"v":0.03571428571428571,"d":"4%"}},{"$f":"(26+28)/2","v":{"v":27,"d":"27.00"}},{"$f":"Tabla2[[#This Row],[marca de clase]]*(Tabla2[[#This Row],[f]])","v":27}]
["TOTAL",28,{"$f":"SUM(C17:C20)","v":1},{"$f":"SUM(D17:D20)","v":100},{"$f":"SUM(E17:E20)","v":{"v":1,"d":"100%"}},{"$f":"SUM(F17:F20)","v":{"v":90,"d":"90.00"}},{"$f":"SUM(G17:G20)","v":546}]
[]
[]
[null,"datos"]
[null,"Li",17,null,"MEDIANA=",{"$f":"17+((28/2-0)/18)*2","v":18.555555555555557}]
[null,"f",18,null,"MED. A="]
[null,"f-1",0]
[null,"n",28,null,"MODA=",{"$f":"17+((18-0)/((18-0)+(18-7)))*2","v":18.24137931034483}]
[null,"ti",2]
[null,"fi-1",0]
[null,"fi+1",7]

{"sheet":"ESTATURAS","index":2,"n_rows":36,"n_cols":10,"rows_kept":36}
[]
["ESTATURA","FRECUENCIA","FR","%"]
["1.5-1.55",3,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":{"v":0.10714285714285714,"d":"0.107143"}},{"$f":"(C3*100)","v":{"v":10.714285714285714,"d":"1071.43%"}}]
["1.56-1.60",10,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":{"v":0.35714285714285715,"d":"0.357143"}},{"v":35.714285714285715,"d":"3571.43%"}]
["1.61-1.65",9,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":{"v":0.32142857142857145,"d":"0.321429"}},{"v":32.142857142857146,"d":"3214.29%"}]
["1.66-1.70",4,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":{"v":0.14285714285714285,"d":"0.142857"}},{"v":14.285714285714285,"d":"1428.57%"}]
["1.71-1.75",2,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":{"v":0.07142857142857142,"d":"0.071429"}},{"v":7.142857142857142,"d":"714.29%"}]
[null,null,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":0},{"v":0,"d":"0.00%"}]
["TOTAL ",28,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":1},{"v":100,"d":"10000.00%"}]
{"$rows_empty":9}
["ESTATURA","FRECUENCIA","FR","%","Columna1","MARCA DE CLASE","MC*F","FRECUENCIA ACUMULADA","LI"]
["1.53-1.56",{"$f":"COUNTIFS(RECOLECTARDATOS!E3:E30,\">=1.53\",RECOLECTARDATOS!E3:E30,\"<=1.56\")","v":4},{"$f":"B20/28","v":0.14285714285714285},{"$f":"(C20*100)","v":14.285714285714285},{"$f":"C20","v":{"v":0.14285714285714285,"d":"14.29%"}},{"$f":"(1.53+1.56)/2","v":1.545},{"$f":"Tabla1[[#This Row],[MARCA DE CLASE]]*Tabla1[[#This Row],[FRECUENCIA]]","v":6.18},{"$f":"Tabla1[[#This Row],[FRECUENCIA]]","v":4},{"$f":"1.53+((28/2-4)/4)*0.034","v":1.615}]
["1.57-1.60",{"$f":"COUNTIFS(RECOLECTARDATOS!E3:E30,\">=1.57\",RECOLECTARDATOS!E3:E30,\"<=1.60\")","v":9},{"$f":"(B21/28)","v":0.32142857142857145},{"$f":"(C21*100)","v":32.142857142857146},{"$f":"C21","v":{"v":0.32142857142857145,"d":"32.14%"}},{"$f":"(1.57+1.6)/2","v":1.585},{"$f":"Tabla1[[#This Row],[MARCA DE CLASE]]*Tabla1[[#This Row],[FRECUENCIA]]","v":14.265},{"$f":"H20+B21","v":13},{"$f":"1.57+((28/2-9)/9)*0.034","v":1.588888888888889}]
["1.61-1.64",{"$f":"COUNTIFS(RECOLECTARDATOS!E3:E30,\">=1.61\",RECOLECTARDATOS!E3:E30,\"<=1.64\")","v":6},{"$f":"(B22/28)","v":0.21428571428571427},21.428571428571427,{"v":0.21428571428571427,"d":"21.43%"},{"$f":"(1.61+1.64)/2","v":1.625},{"$f":"Tabla1[[#This Row],[MARCA DE CLASE]]*Tabla1[[#This Row],[FRECUENCIA]]","v":9.75},{"$f":"H21+Tabla1[[#This Row],[FRECUENCIA]]","v":19},{"$f":"1.61+((28/2-6)/6)*0.034","v":1.6553333333333335}]
["1.65-1.68",{"$f":"COUNTIFS(RECOLECTARDATOS!E3:E30,\">=1.65\",RECOLECTARDATOS!E3:E30,\"<=1.68\")","v":7},{"$f":"(B23/28)","v":0.25},25,{"v":0.25,"d":"25.00%"},{"$f":"(1.65+1.68)/2","v":1.665},{"$f":"Tabla1[[#This Row],[MARCA DE CLASE]]*Tabla1[[#This Row],[FRECUENCIA]]","v":11.655000000000001},{"$f":"H22+Tabla1[[#This Row],[FRECUENCIA]]","v":26},{"$f":"1.65+((28/2-7)/7)*0.034","v":1.684}]
["1.69-1.72",{"$f":"COUNTIFS(RECOLECTARDATOS!E3:E30,\">=1.69\",RECOLECTARDATOS!E3:E30,\"<=1.72\")","v":0},{"$f":"(B24/28)","v":0},0,{"v":0,"d":"0.00%"},{"$f":"(1.69+1.72)/2","v":1.705},{"$f":"Tabla1[[#This Row],[MARCA DE CLASE]]*Tabla1[[#This Row],[FRECUENCIA]]","v":0},{"$f":"H23+Tabla1[[#This Row],[FRECUENCIA]]","v":26},0]
["1.73-1.76",{"$f":"COUNTIFS(RECOLECTARDATOS!E3:E30,\">=1.73\",RECOLECTARDATOS!E3:E30,\"<=1.76\")","v":2},{"$f":"(B25/28)","v":0.07142857142857142},7.142857142857142,{"v":0.07142857142857142,"d":"7.14%"},{"$f":"(1.73+1.76)/2","v":1.745},{"$f":"Tabla1[[#This Row],[MARCA DE CLASE]]*Tabla1[[#This Row],[FRECUENCIA]]","v":3.49},{"$f":"H24+Tabla1[[#This Row],[FRECUENCIA]]","v":28},{"$f":"1.73+((28/2-2)/2)*0.034","v":1.934}]
["TOTAL",28,{"$f":"SUM(C20:C25)","v":1},{"$f":"SUM(D20:D25)","v":100},{"v":1,"d":"100.00%"},{"$f":"SUM(F20:F25)","v":9.870000000000001},{"$f":"SUM(G20:G25)","v":45.34},{"$f":"Tabla1[[#This Row],[FRECUENCIA]]","v":28}]
[]
["Columna1","Columna2",{"$nulls":3},"DATOS","."]
["LIM SUP",1.73,{"$nulls":3},"MEDIA A",{"$f":"G26/28","v":1.6192857142857144},null,"MODA:",{"$f":"1.53+((4-0)/((4-0)+(4-0)))*2","v":2.5300000000000002}]
["LIM INF",1.53,{"$nulls":3},"LI",1.53,null,"MEDIANA:",{"$f":"1.53+((28/2-0)/4)*2","v":8.53}]
["RANGO",{"$f":"B29-B30","v":0.19999999999999996},{"$nulls":3},"F-1"]
["INTERVALOS",{"$f":"1+(3.322*LOG(28))","v":5.807458980118852},{"$nulls":3},"fi"]
["TI",{"$f":"B31/B32","v":0.0344384696791964},{"$nulls":3},"ti",0.0344384696791964]
[{"$nulls":5},"fi-1"]
[{"$nulls":5},"fi-2"]
[{"$nulls":5},"n"]

{"sheet":"GENEROS MUSICALES","index":3,"n_rows":12,"n_cols":2,"rows_kept":12}
[]
["GENERO MÚSICAL","FRECUENCIA"]
["ROCK",{"$f":"COUNTIF(RECOLECTARDATOS!F3:F30, \"ROCK\")","v":1}]
["REGUETON",{"$f":"COUNTIF(RECOLECTARDATOS!F4:F31, \"REGUETON\")","v":7}]
["POP",{"$f":"COUNTIF(RECOLECTARDATOS!F3:F30, \"POP\")","v":10}]
["HIP HOP",{"$f":"COUNTIF(RECOLECTARDATOS!F3:F30, \"HIP HOP\")","v":1}]
["ALTERNATIVO",{"$f":"COUNTIF(RECOLECTARDATOS!F3:F30, \"ALTERNATIVO\")","v":5}]
["REGAE",{"$f":"COUNTIF(RECOLECTARDATOS!F3:F30, \"REGAE\")","v":1}]
["R&B",{"$f":"COUNTIF(RECOLECTARDATOS!F3:F30, \"R&B\")","v":1}]
["CORRIDOS",{"$f":"COUNTIF(RECOLECTARDATOS!F3:F30, \"CORRIDOS\")","v":1}]
["RAP",{"$f":"COUNTIF(RECOLECTARDATOS!F3:F30, \"RAP\")","v":1}]
["TOTAL",{"$f":"SUM(B3:B11)","v":28}]

{"sheet":"Hoja6","index":4,"n_rows":29,"n_cols":2,"rows_kept":29}
[]
[1,"ALCALA RAMIREZ GABRIELA HAYDEE"]
[2,"ANGUIANO CALDERON FATIMA LIZBETH"]
[3,"CEPEDA GARCIA PERLA ABIGAIL"]
[4,"CUADROS CALVILLO IMELDA PATRICIA"]
[5,"DE LA GARZA SANCHEZ REGINA"]
[6,"DOMINGUEZ FLORES JOSELYN ANDREA"]
[7,"ESCOLASTICO RUIZ ALESSANDRA"]
[8,"GARCIA ESCOBEDO JENIFER JANETH"]
[9,"GAYTAN BERMEA ANDREA"]
[10,"GONZALEZ LOMAS LORENA ALEJANDRA"]
[11,"GONZALEZ PALOMO DEVANI MONSERRATH"]
[12,"GUTIERREZ CISNEROS GABRIELA BERENICE"]
[13,"GUTIERREZ FONSECA TANIA MELISA"]
[14,"HERNANDEZ SERRANO ARELY"]
[15,"HERRERA IBARRA CLAUDIA FERNANDA"]
[16,"HUERTA JIMENEZ MARIA FERNANDA"]
[17,"MARTINEZ PONCE ANA PAOLA"]
[18,"MONTOYA SILVA JULIA YESSENIA"]
[19,"ONTIVEROS RODRIGUEZ MAYRA RUBY"]
[20,"PEÑA FARIAS ANA PAOLA"]
[21,"RAMIREZ MEDINA YUMIKO"]
[22,"REALPOZO HARO RANIA ROMINA"]
[23,"ROCHA VICUÑA XIMENA GUADALUPE"]
[24,"SALAS CASTILLO JOHANA VANESSA"]
[25,"SANCHEZ MONCADA ESTRELLA JANETH"]
[26,"SEGOVIA LUCIO BRITANIA SCARLETT"]
[27,"SERRATO MONTENEGRO ANA PAULINA"]
[28,"VALDEZ RIOS MONSERRATH"]

{"sheet":"RESUMEN.","index":5,"n_rows":0,"n_cols":0,"rows_kept":0}