Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: James Stewart

8th edition

1285741552, 9781305482463 , 978-1285741550

More Books

Students also viewed these Mathematics questions