I Need Help With Number 3 6 7 1 (69.57 KiB) Viewed 31 times
A tire manufacturer periodically tests its tires for tread wear under simulated road conditions. To study and control its manufacturing processes, the company uses R-charts. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Questions 1. What is the number of samples? Round your answer to the nearest whole number. 30 2. What is the sample size? Round your answer to the nearest whole number. 5 3. What is the average range? Round your answer to three decimal places. 22.833 X 4. What are the appropriate Control Chart Factors? Round your answers to three decimal places. Control Chart Factor Value D3 0 D4 2.114 5. What is the lower control limit for the R-chart? Round your answer to three decimal places. 0 6. What is the value that specifies the center line for the R-chart? Round your answer to three decimal places. 22.833 7. What is the upper control limit for the R-chart? Round your answer to three decimal places. 48 27
R-Chart DATA 1 28 O 17 UAWN 43 28 36 41 29 31 34 32 47 24 23 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 2 16 20 21 46 39 27 43 48 29 48 34 25 44 28 16 27 32 23 34 26 36 24 18 48 24 35 50 43 37 33 31 30 40 41 32 27 3 41 34 49 48 45 16 20 44 44 27 44 41 34 30 43 22 19 45 42 49 17 38 39 32 25 16 47 47 31 25 44 35 30 37 24 20 36 25 50 16 16 26 27 34 22 45 31 33 42 20 21 35 47 40 35 35 37 18 31 49 19 30 35 17 50 35 25 26 30 28 18 16 42 42 30 16 37 46 41 34 17 27 20 26 18 30 23 27 50 45 24 48 45 21 N> Control Chart Factors A2 D3 D4 d2 A3 B3 B4 1.880 0.000 3.267 1.128 2.659 0.000 3.267 3 1.023 0.000 2.574 1.693 1.954 0.000 2.568 4 0.729 0.000 2.282 2.059 1.628 0.000 2.266 5 0.577 0.000 2.114 2.326 1.427 0.000 2.089 6 0.483 0.000 2.004 2.534 1.287 0.030 1.970 7 0.419 0.076 1.924 2.704 1.182 0.118 1.882 0.373 0.136 1.864 2.847 1.099 0.185 1.815 9 0.337 0.184 1.816 2.970 1.032 0.239 1.761 10 0.308 0.223 1.777 3.078 0.975 0.284 1.716
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!