{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["RECOLECTARDATOS","EDAD","ESTATURAS","GENEROS MUSICALES","Hoja6","RESUMEN."],"not_rendered":{"charts":3,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"RECOLECTARDATOS","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[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,1.6,"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":18},{"$f":"_xlfn.MODE.SNGL(E3:E30)","v":1.6},"POP"]
[null,null,"MEDIANA",{"$f":"MEDIAN(Tabla7[EDAD])","v":19},{"$f":"MEDIAN(Tabla7[ESTATURA])","v":1.62}]
[null,null,"MEDIA ARITMETICA",{"$f":"AVERAGE(D3:D30)","v":19.428571428571427},{"$f":"AVERAGE(E3:E30)","v":1.6214285714285714}]

{"sheet":"EDAD","index":1,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["EDAD","FRECUENCIA","FR","%","Columna1"]
[17,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,17)","v":2},{"$f":"B3/28","v":7.1428571428571425E-2},{"$f":"(C3*100)","v":7.1428571428571423},{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":2}]
[18,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,18)","v":9},0.32142857142857145,32.142857142857146,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":9}]
[19,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,19)","v":7},0.25,25,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":7}]
[20,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,20)","v":6},0.21428571428571427,21.428571428571427,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":6}]
[21,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,21)","v":0},0,0,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":0}]
[22,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,22)","v":1},3.5714285714285712E-2,3.5714285714285712,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":1}]
[23,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,23)","v":2},7.1428571428571425E-2,7.1428571428571423,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":2}]
[24,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,24)","v":0},0,0,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":0}]
[25,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,25)","v":0},0,0,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":0}]
[26,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,26)","v":0},0,0,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":0}]
[27,{"$f":"COUNTIF(RECOLECTARDATOS!D3:D30,27)","v":1},3.5714285714285712E-2,3.5714285714285712,{"$f":"Tabla6[[#This Row],[FRECUENCIA]]","v":1}]
["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.285714285714292},{"$f":"(C17)","v":0.6428571428571429},{"$f":"(17+19)/2","v":18},{"$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":0.25},{"$f":"(20+22)/2","v":21},{"$f":"Tabla2[[#This Row],[marca de clase]]*(Tabla2[[#This Row],[f]])","v":147}]
["23-25",2,{"$f":"B19/28","v":7.1428571428571425E-2},7.1428571428571423,{"$f":"(C19)","v":7.1428571428571425E-2},{"$f":"(23+25)/2","v":24},{"$f":"Tabla2[[#This Row],[marca de clase]]*(Tabla2[[#This Row],[f]])","v":48}]
["26-28",1,{"$f":"B20/28","v":3.5714285714285712E-2},3.5714285714285712,{"$f":"(C20)","v":3.5714285714285712E-2},{"$f":"(26+28)/2","v":27},{"$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":1},{"$f":"SUM(F17:F20)","v":90},{"$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.241379310344829}]
[null,"ti",2]
[null,"fi-1",0]
[null,"fi+1",7]

{"sheet":"ESTATURAS","index":2,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
["ESTATURA","FRECUENCIA","FR","%"]
["1.5-1.55",3,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":0.10714285714285714},{"$f":"(C3*100)","v":10.714285714285714}]
["1.56-1.60",10,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":0.35714285714285715},35.714285714285715]
["1.61-1.65",9,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":0.32142857142857145},32.142857142857146]
["1.66-1.70",4,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":0.14285714285714285},14.285714285714285]
["1.71-1.75",2,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":7.1428571428571425E-2},7.1428571428571423]
[null,null,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":0},0]
["TOTAL ",28,{"$f":"Tabla8[[#This Row],[FRECUENCIA]]/28","v":1},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":0.14285714285714285},{"$f":"(1.53+1.56)/2","v":1.5449999999999999},{"$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":0.32142857142857145},{"$f":"(1.57+1.6)/2","v":1.585},{"$f":"Tabla1[[#This Row],[MARCA DE CLASE]]*Tabla1[[#This Row],[FRECUENCIA]]","v":14.265000000000001},{"$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,0.21428571428571427,{"$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,0.25,{"$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.6839999999999999}]
["1.69-1.72",{"$f":"COUNTIFS(RECOLECTARDATOS!E3:E30,\">=1.69\",RECOLECTARDATOS!E3:E30,\"<=1.72\")","v":0},{"$f":"(B24/28)","v":0},0,0,{"$f":"(1.69+1.72)/2","v":1.7050000000000001},{"$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":7.1428571428571425E-2},7.1428571428571423,7.1428571428571425E-2,{"$f":"(1.73+1.76)/2","v":1.7450000000000001},{"$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.9339999999999999}]
["TOTAL",28,{"$f":"SUM(C20:C25)","v":1},{"$f":"SUM(D20:D25)","v":100},1,{"$f":"SUM(F20:F25)","v":9.870000000000001},{"$f":"SUM(G20:G25)","v":45.34},{"$f":"Tabla1[[#This Row],[FRECUENCIA]]","v":28}]
[]
["Columna1","Columna2",null,null,null,"DATOS","."]
["LIM SUP",1.73,null,null,null,"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,null,null,null,"LI",1.53,null,"MEDIANA:",{"$f":"1.53+((28/2-0)/4)*2","v":8.5299999999999994}]
["RANGO",{"$f":"B29-B30","v":0.19999999999999996},null,null,null,"F-1"]
["INTERVALOS",{"$f":"1+(3.322*LOG(28))","v":5.8074589801188523},null,null,null,"fi"]
["TI",{"$f":"B31/B32","v":3.44384696791964E-2},null,null,null,"ti",3.44384696791964E-2]
[null,null,null,null,null,"fi-1"]
[null,null,null,null,null,"fi-2"]
[null,null,null,null,null,"n"]

{"sheet":"GENEROS MUSICALES","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["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,"cut":false,"hidden":false,"merged":[]}
[]
[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,"cut":false,"hidden":false,"merged":[]}