See attached file. I am looking for a model answers to 4 questions for my Quality Management Course.
The data is random; questions 1 to 3 use the 500 samples and question 4 uses 50 samples in the size of 10.
1. Analyse the data and test the hypothesis for normal distribution both visually and analytically. MS Excel for calculations.
2. Estimate the process capability and performance. Calculate the expected percentage of rejects and work out the expected number of rejects in a batch of 1,000,000 items, if the specified tolerance is between 5.00 kg and 6.00 kg.
3. Test if the statistical requirements for 6 Sigma Quality for this parameter have been achieved. Advise on necessity of eventual improvements.
4. Identify and prepare appropriate quality control charts using the data from the table above. Analyse the information presented on them and compare with results obtained in (1). Sheet3
Sheet2
Sheet1
Item No
Sample…





