During the manufacture of the driver gear of an automobile, a dial bore gauge is used to bore a hole into cast steel. Specifications require that the diameter of the bore hole be between 204.05 and 205.05 millimeters, with a target mean of 205 millimeters. The International Journal of Quality Research (Vol. 8, 2014) applied capability analysis to assess the performance of the boring operation. Five driver gear parts were sampled each hour for 20 consecutive hours, and the bore diameter of each part was determined. The data are presented in the file BORE.xlsx. Run a complete capability analysis on the data. How would you categorize the performance of the boring process? Is the process under control. Find the capability index and plot the X-bar chart to support your argument.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.3: Measures Of Spread
Problem 1GP
icon
Related questions
Question
120
A.
В
F
G
H
1 Sample Hole1
Hole2
Hole3
Hole4
Hole5
Mean
Range
2
1
205.03
205.02
205.01
205.045
205.01 205.023
0.035
3
2
205.01
205.02
205.025
205.03
205.01
205.019
0.02
4
205.01
205.03
205.05
205.03
205.02 205.028
0.04
5
4
205.03
205.02
205.03
205.04
205.035
205.031
0.02
205.04
205.035
205.03
205.03
205.035 205.034
0.01
7
205.03
205.03
205.025
205.03
205.035
205.03
0.01.
8
7
205.025
205.025
205.025
205.025
205.025
205.025
8.
205.015
205.02
205.025
205.01
205.02
205.018
0.015
10
205.025
205.03
205.04
205.01
205.01
205.023
0.03
11
10
205.025
205.025
205.02
205.01
205.02
205.02
0.015
12
11
205.01
205.005
205.03
205.04
205.04 205.025
0.035
13
12
205.03
205.02
205.03
205.03
205.03 205.028
0.01
14
13
205.03
205.04
205.03
205.04
205.03
205.034
0.01
15
14
205.03
205.04
205.03
205.03
205.025
205.031
0.015
16
15
205.01
205.01
205.02
205.04
205.05
205.026
0.04
17
16
205.035
205.04
205.037
205.042
205.04
205.038
0.007
18
17
205.045
205.038
205.045
205.033
205.03
205.038
0.015
19
18
205.04
205.03
205.025
205.025
205.02
205.028
0.02
20
19
205.03
205.025
205.03
205.03
205.035
205.03
0.01
21
20
205.04
205.035
205.03
205.03
205.02
205.031
0.02
22
Transcribed Image Text:120 A. В F G H 1 Sample Hole1 Hole2 Hole3 Hole4 Hole5 Mean Range 2 1 205.03 205.02 205.01 205.045 205.01 205.023 0.035 3 2 205.01 205.02 205.025 205.03 205.01 205.019 0.02 4 205.01 205.03 205.05 205.03 205.02 205.028 0.04 5 4 205.03 205.02 205.03 205.04 205.035 205.031 0.02 205.04 205.035 205.03 205.03 205.035 205.034 0.01 7 205.03 205.03 205.025 205.03 205.035 205.03 0.01. 8 7 205.025 205.025 205.025 205.025 205.025 205.025 8. 205.015 205.02 205.025 205.01 205.02 205.018 0.015 10 205.025 205.03 205.04 205.01 205.01 205.023 0.03 11 10 205.025 205.025 205.02 205.01 205.02 205.02 0.015 12 11 205.01 205.005 205.03 205.04 205.04 205.025 0.035 13 12 205.03 205.02 205.03 205.03 205.03 205.028 0.01 14 13 205.03 205.04 205.03 205.04 205.03 205.034 0.01 15 14 205.03 205.04 205.03 205.03 205.025 205.031 0.015 16 15 205.01 205.01 205.02 205.04 205.05 205.026 0.04 17 16 205.035 205.04 205.037 205.042 205.04 205.038 0.007 18 17 205.045 205.038 205.045 205.033 205.03 205.038 0.015 19 18 205.04 205.03 205.025 205.025 205.02 205.028 0.02 20 19 205.03 205.025 205.03 205.03 205.035 205.03 0.01 21 20 205.04 205.035 205.03 205.03 205.02 205.031 0.02 22
During the manufacture of the driver gear of an automobile, a dial bore gauge is used
to bore a hole into cast steel. Specifications require that the diameter of the bore hole
be between 204.05 and 205.05 millimeters, with a target mean of 205 millimeters. The
International Journal of Quality Research (Vol. 8, 2014) applied capability analysis to
assess the performance of the boring operation. Five driver gear parts were sampled
each hour for 20 consecutive hours, and the bore diameter of each part was determined.
The data are presented in the file BORE.xlsx. Run a complete capability analysis on
the data. How would you categorize the performance of the boring process? Is the
process under control. Find the capability index and plot the X-bar chart to support
your argument.
*For problems where data is available in an excel file, use the AVERAGE and STDEV function to calculate mean
and standard deviation. You may need to appropriately adjust for sample size where necessary.
Transcribed Image Text:During the manufacture of the driver gear of an automobile, a dial bore gauge is used to bore a hole into cast steel. Specifications require that the diameter of the bore hole be between 204.05 and 205.05 millimeters, with a target mean of 205 millimeters. The International Journal of Quality Research (Vol. 8, 2014) applied capability analysis to assess the performance of the boring operation. Five driver gear parts were sampled each hour for 20 consecutive hours, and the bore diameter of each part was determined. The data are presented in the file BORE.xlsx. Run a complete capability analysis on the data. How would you categorize the performance of the boring process? Is the process under control. Find the capability index and plot the X-bar chart to support your argument. *For problems where data is available in an excel file, use the AVERAGE and STDEV function to calculate mean and standard deviation. You may need to appropriately adjust for sample size where necessary.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill