Below are data from measurements of burst strength of a thin film.

Calculate the statistics in the yellow cells for the Current Process.

Your customer has a requirement for a minimum Cpk of 1.67.

Determine the standard deviation required to meet their minimum Cpk

and with the process centered, determine the new values in the yellow cells for the Proposed Process

The formula's to use to calculate the numbers in highlighted boxes

P Q R S T U V Current process Proposed Process Average Std Dev USL LSL 8.1 5.5 8.1 5.5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cpu Cpl Losses above Losses below Total Losses 7 Measurements 8 7.676 6.924 7.185 6.815 7.039 7.002 6.63 7.063 5.847 6.941 7.075 6.206 7.109 9 7.477 6.444 6.557 7.621 6.305 6.66 8.073 7.274 8.108 6.356 7.574 7.088 6.981 10 6.965 6.804 6.753 8.319 7.219 6.509 6.974 7.652 6.783 7.804 6.046 6.013 6.633 11 6.274 7.085 6.609 6.484 8.164 7.89 5.965 8.236 7.1927.385 7.291 5.992 7.381 12 7.062 6.92 6.626 7.442 7.275 7.162 6.259 6.556 5.778 6.83 6.956 7.814 7.514 13 6.57 6.933 5.743 7.54 5.571 7.261 7.682 7.693 7.75 8.035 6.823 6.19 7.158 14 7.317 6.02 7.312 6.139 6.931 7.625 6.822 7.291 5.425 7.317 7.806 7.015 7.198 15 6.178 7.002 6.023 6.897 6.86 7.328 7.49 8.399 6.729 7.016 6.709 6.365 6.422 16 7.668 6.85 6.976 6.684 7.339 6.528 7.749 6.975 7.011 8.035 7.355 7.992 7.772 17 7.66 7.185 6.235 6.79 7.78 7.537 7.102 7.826 7.393 6.333 7.156 5.708 5.67 18 6.065 6.33 6.031 6.893 6.81 6.224 5.981 7.288 7.717 7.438 5.765 6.624 6.433 19 7.419 7.587 7.134 6.059 7.734 7.831 7.214 7.212 7.917 6.908 7.088 6.752 7.414 20 7.733 6.613 7.268 7.161 6.7 7.237 7.532 7.186 6.875 7.861 6.916 7.184 7.371 21 4.891 6.165 6.528 6.958 5.855 7.202 6.123 6.911 6.154 7.146 8.07 8.147 6.612 22 6.321 7.716 7.5 7.518 7.464 6.825 6.68 8.095 6.359 7.291 7.386 7.276 7.638 23 6.007 7.147 7.238 7.732 8.312 6.63 6.274 7.388 8.313 7.218 7.293 7.178 7.093 24 6.925 8.508 6.412 7.207 8.018 6.565 7.929 6.244 6.313 7.489 6.8 6.428 6.636 25 7.218 7.859 8.365 7.638 7.256 7.873 6.497 7.162 7.036 7.857 7.864 7.736 7.456 26 6.943 7.292 6.131 7.443 7.752 6.728 7.407 5.625 6.314 7.064 7.499 7.771 7.17 Sheet1 7.169 7.79 7.05 5.885 7.491 6.591 7.604 6.817 6.839 6.993 6.607 8.052 7.815 7.666 6.697 6.44 5.179 7.036 5.975 6.41 7.012 7.39 7.006 7.201 6.41 6.65 6.613 7.032 6.792 6.538 6.737 6.707 7.574 7.413 7.097 7.58 7.4 7.981 O 7.981 6.08 7.818 6.889 6.093 6.586 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 A B D E F G H 1 K L M 6.943 7.292 6.131 7.443 7.752 6.728 7.407 5.625 6.314 7.064 7.499 7.771 7.17 6.715 7.573 6.741 7.82 6.398 6.726 6.756 5.704 6.458 8.048 6.351 6.617 6.334 7.422 7.351 6.049 7.434 7.245 7.115 6.636 6.877 6.418 8.711 7.199 7.53 6.728 7.049 7.418 5.516 8.15 7.103 6.44 7.619 7.333 6.6 7.842 7.887 6.888 6.388 7.175 6.089 7.209 7.242 7.899 7.869 6.647 7.609 8.176 8.276 8.363 7.027 6.1 6.459 6.652 7.406 6.342 6.134 7.758 8.238 6.52 7.025 5.525 7.649 6.485 7.729 7.655 6.86 7.116 7.292 7.319 7.229 6.636 6.866 6.645 7.466 7.728 7.24 6.536 6.684 7.058 6.452 5.901 6.856 6.424 8.041 7.032 6.601 6.797 6.148 6.187 7.866 6.399 5.97 6.858 6.79 6.919 7.873 7.526 7.733 7.696 5.964 7.188 5.597 6.653 8.082 7.055 6.11 8.371 5.954 6.608 6.889 7.253 7.223 7.037 6.62 6.649 6.206 6.342 6.798 7.227 7.996 6.723 6.192 7.657 6.303 6.447 7.26 6.967 5.953 7.388 7.481 6.626 6.775 7.512 8.002 7.609 6.766 7.287 8.205 6.387 6.585 7.281 8.389 6.913 5.228 6.84 7.349 6.25 6.644 7.346 7.536 6.002 8.411 6.447 7.207 7.774 7.422 7.295 6.139 6.753 6.567 8.047 6.155 7.33 7.218 7 7.461 7.364 5.657 8.116 6.768 6.975 6.466 6.504 7.342 7.379 7.6237.521 6.831 7.441 6.557 8.16 6.551 6.656 7.541 6.79 6.378 6.105 7.433 6.982 8.315 6.328 6.406 7.244 7.91 N 5.975 5.963 8.213 7.484 7.379 7.272 6.878 7.812 8.459 6.852 5.713 7.58 6.324 7.75 6.949 7.804 P Q R S T U V Current process Proposed Process Average Std Dev USL LSL 8.1 5.5 8.1 5.5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Cpu Cpl Losses above Losses below Total Losses 7 Measurements 8 7.676 6.924 7.185 6.815 7.039 7.002 6.63 7.063 5.847 6.941 7.075 6.206 7.109 9 7.477 6.444 6.557 7.621 6.305 6.66 8.073 7.274 8.108 6.356 7.574 7.088 6.981 10 6.965 6.804 6.753 8.319 7.219 6.509 6.974 7.652 6.783 7.804 6.046 6.013 6.633 11 6.274 7.085 6.609 6.484 8.164 7.89 5.965 8.236 7.1927.385 7.291 5.992 7.381 12 7.062 6.92 6.626 7.442 7.275 7.162 6.259 6.556 5.778 6.83 6.956 7.814 7.514 13 6.57 6.933 5.743 7.54 5.571 7.261 7.682 7.693 7.75 8.035 6.823 6.19 7.158 14 7.317 6.02 7.312 6.139 6.931 7.625 6.822 7.291 5.425 7.317 7.806 7.015 7.198 15 6.178 7.002 6.023 6.897 6.86 7.328 7.49 8.399 6.729 7.016 6.709 6.365 6.422 16 7.668 6.85 6.976 6.684 7.339 6.528 7.749 6.975 7.011 8.035 7.355 7.992 7.772 17 7.66 7.185 6.235 6.79 7.78 7.537 7.102 7.826 7.393 6.333 7.156 5.708 5.67 18 6.065 6.33 6.031 6.893 6.81 6.224 5.981 7.288 7.717 7.438 5.765 6.624 6.433 19 7.419 7.587 7.134 6.059 7.734 7.831 7.214 7.212 7.917 6.908 7.088 6.752 7.414 20 7.733 6.613 7.268 7.161 6.7 7.237 7.532 7.186 6.875 7.861 6.916 7.184 7.371 21 4.891 6.165 6.528 6.958 5.855 7.202 6.123 6.911 6.154 7.146 8.07 8.147 6.612 22 6.321 7.716 7.5 7.518 7.464 6.825 6.68 8.095 6.359 7.291 7.386 7.276 7.638 23 6.007 7.147 7.238 7.732 8.312 6.63 6.274 7.388 8.313 7.218 7.293 7.178 7.093 24 6.925 8.508 6.412 7.207 8.018 6.565 7.929 6.244 6.313 7.489 6.8 6.428 6.636 25 7.218 7.859 8.365 7.638 7.256 7.873 6.497 7.162 7.036 7.857 7.864 7.736 7.456 26 6.943 7.292 6.131 7.443 7.752 6.728 7.407 5.625 6.314 7.064 7.499 7.771 7.17 Sheet1 7.169 7.79 7.05 5.885 7.491 6.591 7.604 6.817 6.839 6.993 6.607 8.052 7.815 7.666 6.697 6.44 5.179 7.036 5.975 6.41 7.012 7.39 7.006 7.201 6.41 6.65 6.613 7.032 6.792 6.538 6.737 6.707 7.574 7.413 7.097 7.58 7.4 7.981 O 7.981 6.08 7.818 6.889 6.093 6.586 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 A B D E F G H 1 K L M 6.943 7.292 6.131 7.443 7.752 6.728 7.407 5.625 6.314 7.064 7.499 7.771 7.17 6.715 7.573 6.741 7.82 6.398 6.726 6.756 5.704 6.458 8.048 6.351 6.617 6.334 7.422 7.351 6.049 7.434 7.245 7.115 6.636 6.877 6.418 8.711 7.199 7.53 6.728 7.049 7.418 5.516 8.15 7.103 6.44 7.619 7.333 6.6 7.842 7.887 6.888 6.388 7.175 6.089 7.209 7.242 7.899 7.869 6.647 7.609 8.176 8.276 8.363 7.027 6.1 6.459 6.652 7.406 6.342 6.134 7.758 8.238 6.52 7.025 5.525 7.649 6.485 7.729 7.655 6.86 7.116 7.292 7.319 7.229 6.636 6.866 6.645 7.466 7.728 7.24 6.536 6.684 7.058 6.452 5.901 6.856 6.424 8.041 7.032 6.601 6.797 6.148 6.187 7.866 6.399 5.97 6.858 6.79 6.919 7.873 7.526 7.733 7.696 5.964 7.188 5.597 6.653 8.082 7.055 6.11 8.371 5.954 6.608 6.889 7.253 7.223 7.037 6.62 6.649 6.206 6.342 6.798 7.227 7.996 6.723 6.192 7.657 6.303 6.447 7.26 6.967 5.953 7.388 7.481 6.626 6.775 7.512 8.002 7.609 6.766 7.287 8.205 6.387 6.585 7.281 8.389 6.913 5.228 6.84 7.349 6.25 6.644 7.346 7.536 6.002 8.411 6.447 7.207 7.774 7.422 7.295 6.139 6.753 6.567 8.047 6.155 7.33 7.218 7 7.461 7.364 5.657 8.116 6.768 6.975 6.466 6.504 7.342 7.379 7.6237.521 6.831 7.441 6.557 8.16 6.551 6.656 7.541 6.79 6.378 6.105 7.433 6.982 8.315 6.328 6.406 7.244 7.91 N 5.975 5.963 8.213 7.484 7.379 7.272 6.878 7.812 8.459 6.852 5.713 7.58 6.324 7.75 6.949 7.804