Question

duration (seconds) 300 3600 900 180 240 60 3600 600 20 20 180 300 1200 60 2700 90 2700 60 1800 30 14400 60 1200 180 120600 | 300 7200 5400 180 5 | 15 3600 1200 20 3600 180 7200 900 20 120 1200 360 30 300 30010800 1800 2700 120 3600 10 10 300 30 | 60 180 2700 180 300 120 300 180 1200 3600I need to make a Range Control Chart on excel with this data. Labeling the x axis Sample Number and the Y axis Sample range.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
1 2 3 4 Range
300.0 300.0 0.0 300.0 300.0
3600.0 15.0 10800.0 270.0 10785.0
900.0 7200.0 1800.0 600.0 6300.0
180.0 5400.0 5.0 600.0 5395.0
240.0 180.0 2700.0 60.0 2520.0
3.0 15.0 30.0 180.0 177.0
60.0 15.0 120.0 120.0 105.0
3600.0 3600.0 60.0 600.0 3540.0
600.0 1.0 3600.0 3.0 3599.0
20.0 1200.0 10.0 300.0 1190.0
20.0 20.0 10.0 60.0 50.0
180.0 3600.0 300.0 600.0 3420.0
300.0 180.0 30.0 120.0 270.0
1200.0 7200.0 60.0 45.0 7140.0
60.0 900.0 180.0 240.0 840.0
2700.0 20.0 2700.0 180.0 2680.0
90.0 120.0 180.0 1800.0 1710.0
2700.0 1200.0 15.0 300.0 2685.0
60.0 360.0 300.0 120.0 300.0
1800.0 30.0 120.0 2.0 1770.0
30.0 300.0 300.0 180.0 270.0
14400.0 60.0 180.0 1800.0 14340.0
60.0 8.0 1200.0 10.0 1192.0
1200.0 5.0 3600.0 30.0 3595.0
180.0 300.0 30.0 600.0 570.0
120.0 300.0 45.0 10.0 255.0

Formula:

в Sample Data Sample 23 300 0 15 10800 1800 300 3600 900 180 240 13 14 300 270 600 600 60 7200 5400 180 15 15 3600 6 2700 30

4 A C D E F I J K L M N O P Q R S T U V W X Y 2 X-bar and R Charts R Chart for Mean Number of Ounces 7 16000 14000 12000 1000

Formula Ref:

X-bar and UnWN Sample 6 7 1 8 2 9 3 10 4 11 5 126 137 14 8 15 9 16 10 17 11 18 12 19 13 20 14 21 15 22 16 23 17 24 18 25 19 2

Choose maximum 25 for A2,D3 and D4 from table constants

Add a comment
Know the answer?
Add Answer to:
I need to make a Range Control Chart on excel with this data. Labeling the x...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT