Question: statististical quality control question. please try to do this in microsoft exell. thanks The quality standard for the length of a steel shaft is 9.460

statististical quality control question. please try to do this in microsoft exell. thanks
statististical quality control question. please
The quality standard for the length of a steel shaft is 9.460 inches to 9.540 inches. The following length data was collected on fifteen samples and each sample contained four measurements. Total Average Range Comments Recalibrated. Dull tool. Sample #1 1 9.465 2 9.473 3 9.503 4 9.473 5 9.513 6 9.531 7 9.461 8 9.532 9 9,467 10 9.462 11 9.508 12 9.523 13 9.530 14 9.451 IS 9.504 Totals NA #2 9.492 9.501 9.517 9.490 9.531 9.538 9.482 9.528 9.473 9.488 9.511 9.522 9.489 9.538 9.487 NA #3 9.537 9.482 9.538 9.505 9.483 9.543 9.475 9.476 9.469 9.538 9.483 9.521 9,493 9.549 9.512 NA #4 9.483 9.496 9.522 9.500 9.507 9.526 9.501 9.480 9.471 9.507 9.492 9.522 9.517 9.506 9.474 NA Tool shifted New tool Parts dirty NA NA Part A (10 Points): Calculate trial control limits for an average chart and a range chart based on the above data. Show all your equations and the values you substituted in those equations. Part B (10 Points): If there are any out-of-control points with assignable cause variation then remove those samples and calculate revised control limits. Show all your equations and the values you substituted in those equations. Part C (10 Points): Explain how to use the control chart values in the future on a regular basis to control and improve the quality of this process. Part D (10 Points): Compute Cp and Cpk and explain the answers. Show all your equations and the values you substituted in those equations

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!