Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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