Pareto Ejemplo

7
A W F V H E K Z G N M B X P I D L J C Y 0.000 7.300 14.600 21.900 29.200 36.500 GRÁFICA DE PARETTO Productos F r e c u e n c i a

description

clases

Transcript of Pareto Ejemplo

Grfico136.551835124720.544356978710.23793789448.45742695636.97960287763.47542038893.39666702053.32133771161.07857874140.9244960640.89573396430.82177427910.78753368420.7615108320.69551208520.43143149660.3261416670.16897733620.10528982950.0384350678

ProductosFrecuenciaGRFICA DE PARETTO

Hoja1CODIGO DEL PRODUCTOCONSUMO ANUAL (UNIDADES)PRECIO DE VENTA UNITARIO (S/.)CODIGO DEL PRODUCTOINGRESO TOTAL POR VENTASINGRESO POR VENTAS (%)A30500700.00A2135000036.552B1200004.00B4800000.822C4100000.15C615000.105D2520001.00D2520000.431E20300010.00E20300003.475F11500052.00F598000010.238G4200015.00G6300001.079H19600208.00H40768006.980I3250001.25I4062500.696J329003.00J987000.169K3200062.00K19840003.397L1270015.00L1905000.326M3270016.00M5232000.896W20000600.00W1200000020.544P1390032.00P4448000.762V19000260.00V49400008.457N1800003.00N5400000.924X1150004.00X4600000.788Y100022.45Y224500.038Z4850040.00Z19400003.32158410200AcumuladoCDIGO DEL PRODUCTOCONSUMO ANUAL (UNIDADES)% ZONA PARA LA GRAFICACDIGO DEL PRODUCTOCONSUMO ANUAL (UNIDADES)% ZONA PARA LA GRAFICA36.5518351247A36.552AA20.5443569787W20.54457.096W36.55210.2379378944F10.238BF57.0968.4574269563V8.45782.771V67.3346.9796028776H6.980H75.7923.4754203889E3.475E82.7713.3966670205K3.397K86.2473.3213377116Z3.321Z89.6431.0785787414G1.079G92.9650.924496064N0.924N94.0430.8957339643M0.896M94.9680.8217742791B0.822CB95.8630.7875336842X0.788100.000X96.6850.761510832P0.762P97.4730.6955120852I0.696I98.2340.4314314966D0.431D98.9300.326141667L0.326L99.3610.1689773362J0.169J99.6870.1052898295C0.105C99.8560.0384350678Y0.038Y99.962100.000max36.552CDIGO DEL PRODUCTOCONSUMO ANUAL ACUMULADO (PORCENTUAL)min0.038A36.552Rango36.513W57.096segn tablaF67.334*para 57.3026800114V75.792para 66.0855666761H82.771para 75.2162000081E86.247K89.643para acumuladoZ92.9650.7857142857G94.04378.5714285714max100.000N94.968min57.096M95.863Rango42.904B96.685segn tablaX97.473para 58.5807615793P98.234para 67.1506346494I98.930para 76.1291154138D99.361L99.687J99.856C99.962Y100.000

Hoja1

ProductosFrecuenciaGRFICA DE PARETTO

Hoja2

ProductosFrecuenciaGRFICA ACUMULADA DE PARETTO

Hoja3