Problem (12 points) Solve this problem in Mintab and Copy-paste Minitab Results into Excel worksheet: Five data entry operators work at the data processing department of the Birmingham Bank. Each day for 30 days, the number of defective records in a sample of 250 records typed by these operators has been noted, as follows. (Note: You should be able to copy-paste the data into Minitab) Sample Number 1 Number of Defectives 17 12 2 3 6 4 7 5 13 6 10 7 14 18 6 12 9 10 3 11 17 12 5 13 19 14 10 15 11 14 10 15 11 16 17 12 19 18 19 20 21 6 13 18 5 22 23 16 24 25 26 27 28 11 8 12 4 29 6 30 16 Presenting the Control Chart without answering the questions will not carn full points. You must explicitly answer all the questions (and demonstrate you are able to extract useful information from the charts) to earn full points as listed here. Short crisp answers in a sentance or two would be enough No need for elaborate explanations. a) Use Minitab to plot an appropriate control chart to control the performance of the Data Processing Department. [4 points) 12 4 27 28 29 30 6 16 Presenting the Control Chart without answering the questions will not eam full points. You must explicitly answer all the questions and demonstrate you are able to extract useful information from the charts) to eam full points as listed here. Short crisp answers in a sentence or two would be enough. No need for elaborate explanations a) Use Minitab to plot an appropriate control chart to control the performance of the Data Processing Department. 14 points) b) What controllimit values you would use for controlling "Defective Records:12 points) d Conduct all the tests. Are any points failing the tests for "special causes? If so, how many points have failed the tests? Which points and for what specific reasons (tests) (2 points) d) is the process operating under the natural variations? Is the process under statistical control? (2 points) e) Why is the lower controllimit not equal to zero? 12 points) Problem (12 points) Solve this problem in Mintab and Copy-paste Minitab Results into Excel worksheet: Five data entry operators work at the data processing department of the Birmingham Bank. Each day for 30 days, the number of defective records in a sample of 250 records typed by these operators has been noted, as follows. (Note: You should be able to copy-paste the data into Minitab) Sample Number 1 Number of Defectives 17 12 2 3 6 4 7 5 13 6 10 7 14 18 6 12 9 10 3 11 17 12 5 13 19 14 10 15 11 14 10 15 11 16 17 12 19 18 19 20 21 6 13 18 5 22 23 16 24 25 26 27 28 11 8 12 4 29 6 30 16 Presenting the Control Chart without answering the questions will not carn full points. You must explicitly answer all the questions (and demonstrate you are able to extract useful information from the charts) to earn full points as listed here. Short crisp answers in a sentance or two would be enough No need for elaborate explanations. a) Use Minitab to plot an appropriate control chart to control the performance of the Data Processing Department. [4 points) 12 4 27 28 29 30 6 16 Presenting the Control Chart without answering the questions will not eam full points. You must explicitly answer all the questions and demonstrate you are able to extract useful information from the charts) to eam full points as listed here. Short crisp answers in a sentence or two would be enough. No need for elaborate explanations a) Use Minitab to plot an appropriate control chart to control the performance of the Data Processing Department. 14 points) b) What controllimit values you would use for controlling "Defective Records:12 points) d Conduct all the tests. Are any points failing the tests for "special causes? If so, how many points have failed the tests? Which points and for what specific reasons (tests) (2 points) d) is the process operating under the natural variations? Is the process under statistical control? (2 points) e) Why is the lower controllimit not equal to zero? 12 points)