P1

Please do your best with the provided information.

Problem 1 Following is a set of measurements of the weights of bags of potato chips in ounces. Given that the customer requirements for the process is (11.9, 12.1). Find Cp, Cpk and DPMO for this process. Sample 1 11.000 11.003 11.00110.991 11.003 2 11.001 11.002 10.99910.996 11.005 3 10.998 10.998 10.99910.995 10.991 4 11.010 11.004 10.997 11.002 10.999 5 11.000 11.002 11.000 10.994 11.007 6 10.998 10.996 10.998 10.996 10.997 7 11.004 10.990 10.996 10.994 10.998 8 10.994 11.001 10.997 10.999 10.997 9 11.004 10.999 11.005 11.005 10.996 10 11.001 11.003 11.005 10.999 11.000 11 10.997 10.995 10.998 10.993 10.994 12 10.996 10.997 10.99911.000 10.995 13 10.999 10.997 10.994 10.989 10.997 14 11.004 11.002 10.990 11.008 11.008 10.998 15 10.999 11.009 11.002 10.997 10.997 16 11.007 11.007 11.005 11.005 11.005 11.006 17 10.996 11.000 11.004 11.005 11.005 11.008 18 10.999 10.998 10.999 11.004 11.004 10.996 19 10.999 11.001 10.998 10.992 11.002 20 11.011 11.005 11.003 11.001 10.997 Pleasesolveusing MS Excelandshowcalculation( Formulas)