{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ProblemaLímites","Tabla_constantes_límites","Hoja3"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"ProblemaLímites","index":0,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[27,11,27,12],[28,11,28,12],[18,11,18,12],[19,11,19,12],[2,0,4,15],[0,0,0,3],[5,0,7,15]]}
["DETERMINAR SISTEMAS FUERA DE CONTROL"]
[]
["La empresa de confecciones TEEN'S FASHION S.A. desea mejorar su proceso de fabricación de pantalones talla M, debido a que últimente recibe muchas devoluciones por parte de sus clientes minoristas (vendedores de Gamarra) porque las tallas son pequeñas en comparación a la talla S. Por ello, ha decidido realizar un análisis y determinar posibles causas atribuibles que puedan estar dañando el proceso. Para esto el área de control de calidad deberá determinar los límites de control del proceso de corte de la longitud, proceso en el que se identificaron problemas. "]
[]
[]
["Se toman 25 muestras, las cuales se determinaran promediando los datos en grupos de 5, esto se realiza con el fin de obtener mejores resultados. Una vez que se tiene el valor de cada muestra (Xprom) y el rango de los datos que lo conforman, se procede hallar los límites de control. Luego, se verifica si todos los datos de Xprom están dentro de los límites obtenidos para este, de ser así se toman los valores obtenidos sino se tendrá que recalcular los nuevos límites de control excluyendo las muestras que se salían de los límites de control hallados primero. "]
[]
[]
[]
["A continuación se presentan las muestras obtenidas por control de calidad. (unidades en cm)"]
[]
[null,"N° MUESTRA","N° 1","N° 2","N° 3","N° 4","N° 5","Xprom ","Rango",null,null,"N° muestras",25,null,"A2",{"$f":"VLOOKUP(M13,Tabla_constantes_límites!A1:B25,2,FALSE)","v":0.57679999999999998}]
[null,1,105.91,106.38,105.92,105.76,105.66,{"$f":"AVERAGE(C13:G13)","v":105.926},{"$f":"MAX(C13:G13)-MIN(C13:G13)","v":0.71999999999999886},null,null,"N° datos",5,null,"(A2 valor sacado de tablas de factores para límites)"]
[null,2,105.96,105.86,106.08,105.74,105.34,{"$f":"AVERAGE(C14:G14)","v":105.79600000000001},{"$f":"MAX(C14:G14)-MIN(C14:G14)","v":0.73999999999999488}]
[null,3,105.86,106,105.46,105.98,105.67,105.79400000000001,0.54000000000000625]
[null,4,105.84,105.77,106.07,105.72,105.89,105.85799999999999,0.34999999999999432,null,null,"X_prom",{"$f":"X_prom(K37,M12)","v":105.82336000000001}]
[null,5,105.9,105.33,106.11,105.76,105.49,105.718,0.78000000000000114,null,null,"Rango prom",{"$f":"rango_prom(L37,M12)","v":0.71719999999999917}]
[null,6,106.08,106.09,106.12,105.87,105.48,105.928,0.64000000000000057]
[null,7,105.64,105.34,106,105.99,105.39,105.672,0.65999999999999659,null,null,"Límite Control Superior",null,106.23656560000001]
[null,8,105.66,105.92,105.99,106,105.28,105.77000000000001,0.71999999999999886,null,null,"Límite Control Inferior",null,105.40943439999999]
[null,9,106.26,105.64,105.98,106.04,105.94,105.97200000000001,0.62000000000000455]
[null,10,105.81,105.89,105.67,106.05,105.97,105.878,0.37999999999999545]
[null,11,106.84,106.13,105.45,106.09,106.17,106.136,1.3900000000000006]
[null,12,106.03,105.23,105.34,105.69,106.09,105.676,0.85999999999999943]
[null,13,105.87,105.77,105.78,105.94,105.87,105.846,0.17000000000000171,null,null,"Nuevo Total",2435.0100000000002]
[null,14,105.84,106.07,105.89,105.74,105.49,105.806,0.57999999999999829,null,null,"X_prom",{"$f":"X_prom($M$25,$M$12)","v":97.400400000000005}]
[null,15,105.85,105.45,105.46,104.32,105.63,105.34200000000001,1.5300000000000011,null,null,"Rango prom",{"$f":"rango_prom(($L$37-$I$27-$I$29),$M$12)","v":0.59159999999999913}]
[null,16,106.05,105.67,106.2,105.86,105.67,105.89000000000001,0.53000000000000114,null,null,"Límite Control Superior",null,97.741634880000007]
[null,17,105.67,106.05,104.44,105.35,104.65,105.232,1.6099999999999994,null,null,"Límite Control Inferior",null,97.059165120000003]
[null,18,105.83,106.1,106.02,105.77,105.84,105.91199999999999,0.32999999999999829]
[null,19,106.06,106.01,105.66,106.14,105.93,105.96,0.48000000000000398]
[null,20,105.77,106.19,105.34,105.98,105.72,105.8,0.84999999999999432]
[null,21,105.99,106.12,105.99,106.15,105.55,105.96,0.60000000000000853]
[null,22,105.94,106.1,105.76,106.08,105.54,105.88399999999999,0.55999999999998806]
[null,23,106.33,106.06,105.87,106.07,105.95,106.056,0.45999999999999375]
[null,24,105.87,105.96,105.64,105.44,106.05,105.79199999999999,0.60999999999999943]
[null,25,106.03,106.44,106.1,105.22,106.11,105.97999999999999,1.2199999999999989,"TOTALES",{"$f":"SUM(Xprom)","v":2645.5840000000003},{"$f":"SUM(I13:I37)","v":17.929999999999978}]

{"sheet":"Tabla_constantes_límites","index":1,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["n","A2"]
[2,1.8806]
[3,1.0230999999999999,null,"n = N° datos"]
[4,0.72850000000000004]
[5,0.57679999999999998]
[6,0.48330000000000001]
[7,0.41930000000000001]
[8,0.37259999999999999]
[9,0.3367]
[10,0.30819999999999997]
[11,0.28510000000000002]
[12,0.26579999999999998]
[13,0.24940000000000001]
[14,0.23530000000000001]
[15,0.22309999999999999]
[16,0.21229999999999999]
[17,0.20280000000000001]
[18,0.1943]
[19,0.18659999999999999]
[20,0.17960000000000001]
[21,0.17330000000000001]
[22,0.16750000000000001]
[23,0.16209999999999999]
[24,0.15720000000000001]
[25,0.15260000000000001]

{"sheet":"Hoja3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}