Question
Please help me. I have to use excel but I'm not sure how to do it. Could you provide screen visual captures and steps of
Please help me. I have to use excel but I'm not sure how to do it. Could you provide screen visual captures and steps of you putting the data into excel and showing the equations with the right graphs in the screen captures you provide so that I can do the process my self correctly.
A process manufacturing component parts is being controlled with a performance characteristic being the tensile strength in pounds per square inch. Samples of size 5 each are taken every hour and 20 samples are reported. The data are shown below. Use excel software to find the X bar-R chart.Construct the X bar-R charts. Are there any points outside the control limits? Please discuss your result.Construct the X bar-R charts. Are there any points outside the control limits? Please discuss your results.
Row | Sample | Tensile_1 | Tensile_2 | Tensile_3 | Tensile_4 | Tensile_5 |
1 | 1 | 1515 | 1518 | 1512 | 1498 | 1511 |
2 | 2 | 1504 | 1511 | 1507 | 1499 | 1502 |
3 | 3 | 1517 | 1513 | 1504 | 1521 | 1520 |
4 | 4 | 1497 | 1503 | 1510 | 1508 | 1502 |
5 | 5 | 1507 | 1502 | 1497 | 1509 | 1512 |
6 | 6 | 1519 | 1522 | 1523 | 1517 | 1511 |
7 | 7 | 1498 | 1497 | 1507 | 1511 | 1508 |
8 | 8 | 1511 | 1518 | 1507 | 1503 | 1509 |
9 | 9 | 1506 | 1503 | 1498 | 1508 | 1506 |
10 | 10 | 1503 | 1506 | 1511 | 1501 | 1500 |
11 | 11 | 1499 | 1503 | 1507 | 1503 | 1501 |
12 | 12 | 1507 | 1503 | 1502 | 1500 | 1501 |
13 | 13 | 1500 | 1506 | 1501 | 1498 | 1507 |
14 | 14 | 1501 | 1509 | 1503 | 1508 | 1503 |
15 | 15 | 1507 | 1508 | 1502 | 1509 | 1501 |
16 | 16 | 1511 | 1509 | 1503 | 1510 | 1507 |
17 | 17 | 1508 | 1511 | 1513 | 1509 | 1506 |
18 | 18 | 1508 | 1509 | 1512 | 1515 | 1519 |
19 | 19 | 1520 | 1517 | 1519 | 1522 | 1516 |
20 | 20 | 1506 | 1511 | 1517 | 1516 | 1508 |
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