Question
Fujiyama Electronics wants to construct x - and s-charts for circuit boards that are purchased from an outside supplier. A critical dimension is the distance
Fujiyama Electronics wants to construct x - and s-charts for circuit boards that are purchased from an outside supplier. A critical dimension is the distance between two holes on the board that are supposed to be 5 cm apart. Use the data in the data file.
Sample | Observations | |||
1 | 4.92 | 4.26 | 4.94 | 4.29 |
2 | 4.65 | 5.54 | 5.00 | 5.42 |
3 | 5.77 | 5.26 | 4.76 | 4.79 |
4 | 6.25 | 4.88 | 5.66 | 4.44 |
5 | 5.27 | 5.41 | 6.02 | 4.91 |
6 | 5.22 | 5.38 | 5.08 | 4.65 |
7 | 5.47 | 4.68 | 4.56 | 4.70 |
8 | 5.71 | 4.54 | 4.17 | 4.87 |
9 | 5.24 | 5.58 | 4.72 | 5.41 |
10 | 4.42 | 5.18 | 4.79 | 4.73 |
11 | 5.14 | 4.26 | 4.71 | 5.48 |
12 | 4.92 | 5.78 | 5.50 | 5.05 |
13 | 5.79 | 3.83 | 4.30 | 4.78 |
14 | 4.92 | 4.80 | 4.75 | 5.59 |
15 | 5.68 | 5.74 | 4.65 | 5.20 |
16 | 5.43 | 4.81 | 5.27 | 4.96 |
17 | 4.79 | 6.04 | 4.47 | 5.18 |
18 | 5.03 | 4.66 | 5.25 | 4.46 |
19 | 4.30 | 5.47 | 4.27 | 4.34 |
20 | 6.07 | 4.97 | 5.51 | 5.02 |
21 | 5.11 | 4.90 | 5.91 | 4.66 |
22 | 4.50 | 5.24 | 4.86 | 4.35 |
23 | 4.91 | 4.79 | 5.74 | 5.03 |
24 | 4.65 | 4.71 | 4.81 | 5.32 |
25 | 4.70 | 5.50 | 6.04 | 4.30 |
26 | 5.87 | 5.30 | 5.78 | 5.07 |
27 | 4.41 | 4.75 | 4.95 | 5.11 |
28 | 4.92 | 5.47 | 4.72 | 5.02 |
29 | 5.68 | 4.97 | 4.79 | 4.66 |
30 | 5.43 | 4.90 | 4.71 | 4.35 |
a. Find the centerlines and control limits using Excel template. Round to three decimal places.
b. Manually calculate the control limits of X-bar and s charts.
c. Use the X-bar&s Excel template to construct x - and s-charts. Covert the Excel results to PDF and submit as attachment.
d. What conclusions do you reach concerning the state of the process? Is it under control? Why or why not?
Covert the Excel results (calculations and control charts) to PDF and submit as attachment.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started