Question: Utilize Microsoft Excel to create an X-bar and R chart to capture the variation in the sample means of the battery life data set from

Utilize Microsoft Excel to create an X-bar and R chart to capture the variation in the sample means of the battery life data set from the table below. Is this in control? Why or why not?

Sample 1 Sample 2 Sample 3 Sample 4
Test 1 22 24 28 27
Test 2 24 16 29 25
Test 3 29 16 29 13
Test 4 29 28 18 15
Test 5 27 26 19 20
Test 6 20 26 18 16
Test 7 24 15 20 23
Test 8 19 16 13 22
Test 9 13 20 23 26
Test 10 18 17 26 23
Test 11 29 14 18 26
Test 12 21 13 17 22
Test 13 19 22 17 22
Test 14 15 24 15 29
Test 15 17 19 22 29
Test 16 26 21 16 26
Test 17 15 23 29 19
Test 18 18 16 29 21
Test 19 24 26 28 20
Test 20 29 13 29 24
Test 21 25 13 29 15
Test 22 24 22 20 21
Test 23 13 29 18 28
Test 24 27 26 14 29
Test 25 21 19 26 25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!