Overview
You have been hired as a production engineer at a widget factory. Your first task is to conduct statistical process control techniques to monitor the production process. You will be using the following dataset for your initial analysis:
Date | Widgets_Produced | Defective_Widgets | Production_Time_Hours |
2024-01-01 | 100 | 2 | 8 |
2024-01-02 | 110 | 1 | 7.5 |
2024-01-03 | 105 | 3 | 8.2 |
2024-01-04 | 95 | 4 | 8.5 |
2024-01-05 | 120 | 0 | 7 |
2024-01-06 | 115 | 2 | 7.8 |
2024-01-07 | 100 | 5 | 9 |
2024-01-08 | 130 | 1 | 6.5 |
2024-01-09 | 125 | 3 | 7.2 |
2024-01-10 | 110 | 2 | 8 |
Assignment Steps:
- Initial Analysis:
- Use descriptive statistics to summarize the data.
- Statistical Process Control:
- Create an appropriate chart or diagram in Excel.
- Document Creation:
- Create a Word document to summarize the results.
Deliverables: Grading will be based on the clarity of explanation, appropriateness of the statistical methods used, and interpretation of results.
- Excel file showing calculations, initial analysis and control charts
- Word document summarizing results