course project Quality control
Data Set 1
| Run 1 | Run 2 | Run 3 | Run 4 | Avg | GrMean | UCL | LCL | Stacked | Process Mean | UCL | LCL | Stacked | Spec Mean | Spec USL | Spec LSL | Desc Stats | |||||
| 1 | 6.45 | 5.56 | 5.53 | 6.81 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 2 | 6.47 | 6.99 | 5.65 | 5.74 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | The Mean from Desc Stats MUST be in cell U3 | ||||||||||
| 3 | 5.80 | 5.32 | 6.32 | 6.09 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 4 | 5.87 | 5.13 | 5.06 | 6.82 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 5 | 5.43 | 5.26 | 5.15 | 6.68 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 6 | 6.92 | 6.44 | 5.80 | 5.94 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | TheStdDev from Desc Stats MUST be in cell U7 | ||||||||||
| 7 | 6.35 | 6.45 | 5.21 | 6.26 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 8 | 6.55 | 5.53 | 5.92 | 5.94 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 9 | 5.85 | 6.13 | 6.33 | 6.71 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 10 | 5.98 | 6.50 | 6.78 | 5.71 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 11 | 5.80 | 6.20 | 6.33 | 5.86 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 12 | 5.89 | 5.33 | 6.00 | 6.09 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 13 | 6.49 | 6.81 | 5.33 | 5.89 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 14 | 5.08 | 6.24 | 5.71 | 6.10 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 15 | 5.09 | 6.60 | 6.83 | 5.03 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 16 | 6.45 | 6.88 | 5.95 | 5.29 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 17 | 6.54 | 5.33 | 6.89 | 6.37 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 18 | 6.72 | 6.43 | 5.29 | 6.25 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 19 | 6.38 | 5.99 | 6.66 | 5.45 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 20 | 6.33 | 5.17 | 5.02 | 5.09 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | Place IM chart plotted against process mean/UCL/LCL here | ||||||||||
| Grand Mean | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| Std Dev | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Format Axis to Max of 8.0; Min of 4.0 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Axis Major Unit = .5 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| Place | X-bar | chart | here | 0.00 | 0.00 | 0.00 | |||||||||||||||
| X-bar | ONLY | 0.00 | 0.00 | 0.00 | Place analysis of IM chart plotted against process limits here | ||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| Format Axis to Max of 6.8; Min of 4.8 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| Axis Major Unit = .2 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| Place analysis of X-bar chart and data here | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Place IM chart using Spec Mean, USL and LSL here | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Format axis to max of 7.2; Min of 4.8 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Major unit 0.2 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Place analysis of IM chart plotted against spec limits here | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
Questions DS 1
| You have just completed the first test run of the widget production. Answer the questions below and follow the instructions. |
| What is the customer specification for the widget mean? |
| What is the customer USL for the widget? |
| What is the customer LSL for the widget? |
| X-bar chart |
| What is the Grand Mean of the test data? |
| What is the calculated UCL of the test data? |
| What is the calculated LCL of the test data? |
| Is there an issue with the grouped data and the customer specifications? (Y/N) |
| What is the issue? |
| IM charts |
| What is the calculated UCL of the test data? |
| What is the calculated LCL of the test data? |
| How many widgets are out of specification? |
| Is there an issue with the IM data and the customer USL and LSL? (Y/N) |
| What is the issue? |
| What is your suggestion to correct the problem? |
| Based on your analysis, do you make corrections and do another test sample? (Y/N) |
| If no, why? |
| If yes, proceed to Data Set 2, and repeat the steps for Data Set 1 |
Data Set 2
| Day 1 | Day 2 | Day 3 | Day 4 | Avg | Mean | UCL | LCL | Stack | Mean | UCL | LCL | Stack | Mean S | USL | LSL | Desc Stats | |||||
| 1 | 5.69 | 5.36 | 5.72 | 5.11 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 2 | 5.58 | 5.67 | 5.64 | 5.37 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | The Mean from Desc Stats MUST be in cell U3 | ||||||||||
| 3 | 5.39 | 5.75 | 5.75 | 5.83 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 4 | 5.49 | 5.47 | 5.44 | 5.54 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 5 | 5.44 | 5.55 | 5.84 | 5.47 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 6 | 5.27 | 5.27 | 5.73 | 5.23 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | TheStdDev from Desc Stats MUST be in cell U7 | ||||||||||
| 7 | 5.28 | 5.21 | 5.44 | 5.21 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 8 | 5.27 | 5.37 | 5.27 | 5.84 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 9 | 5.25 | 5.76 | 5.69 | 5.54 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 10 | 5.29 | 5.49 | 5.60 | 5.85 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 11 | 5.31 | 5.42 | 5.80 | 5.53 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 12 | 5.33 | 5.37 | 5.32 | 5.11 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 13 | 5.57 | 5.81 | 5.70 | 5.80 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 14 | 5.60 | 5.43 | 5.76 | 5.44 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 15 | 5.59 | 5.55 | 5.20 | 5.78 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 16 | 5.34 | 5.35 | 5.49 | 5.78 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 17 | 5.56 | 5.87 | 5.85 | 5.16 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 18 | 5.74 | 5.81 | 5.55 | 5.41 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 19 | 5.68 | 5.60 | 5.56 | 5.73 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||
| 20 | 5.82 | 5.23 | 5.80 | 5.74 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | Place IM chart plotted against process mean/UCL/LCL here | ||||||||||
| Grand Mean | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| Std Dev | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Format Axis to Max of 6.2; Min of 4.8 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Axis Major Unit = .1 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| Place | X-bar | chart | here | 0.00 | 0.00 | 0.00 | |||||||||||||||
| X-bar | ONLY | 0.00 | 0.00 | 0.00 | Place analysis of IM chart plotted against process limits here | ||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| Format Axis to Max of 6.2; Min of 4.8 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| Axis Major Unit = .2 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| Place analysis of X-bar chart and data here | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Place IM chart using Spec Mean, USL and LSL here | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Format axis to max of 6.1; Min of 4.9 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Major unit 0.1 | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | Place analysis of IM chart plotted against spec limits here | ||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 | |||||||||||||||||||
| 0.00 | 0.00 | 0.00 |
Questions DS 2
| You have just completed the second test run of the widget production. Answer the questions below and follow the instructions. |
| What is the customer specification for the widget mean? |
| What is the customer USL for the widget? |
| What is the customer LSL for the widget? |
| X-bar chart |
| What is the Grand Mean of the test data? |
| What is the calculated UCL of the test data? |
| What is the calculated LCL of the test data? |
| Is there an issue with the grouped data and the customer specifications? (Y/N) |
| Why? |
| IM charts |
| What is the calculated UCL of the test data? |
| What is the calculated LCL of the test data? |
| How many widgets are out of specification? |
| Is there an issue with the IM data and the customer USL and LSL? (Y/N) |
| Why? |
| What is your suggestion to correct the problem, if any? |
| Based on your analysis, do you make corrections and do another test sample? (Y/N) |
| If no, why? |