f* B B D E H I J K L M N o R Observatic 3 1 2 3 4 1 2 NE 1 12.2 12.3 12.4 11.8 12.7 2 12.3 12.1 11.8 12.2 12.3 4 12.5 12.3 12.3 12.1 12.1 F G Sample 5 6 11.5 12.6 11 11.8 11.8 11.7 11.9 11.9 11.9 12.4 12.7 12.3 12.5 12.3 7 11.8 12.1 12.5 12.8 12.5 8 12.5 12.8 12 12.5 11.9 9 12.1 12.3 12 11.9 12.1 10 12.1 12.4 11.9 12 12.3 3 5 6 122 4 7 5 8 Max Min Range R-bar UCL-R LCL-R Mean X-bar-bar UCL-X LCL-X 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Directions: 1. Complete the chart in its entirety. Use the following info to help complete the chart: Max-the maximum observation of the 5 in the sample. Min-the minimum observation of the 5 in the sample. Range-the max observation minus the minimum observation R-bar-the mean of all the ranges. Note: this will be the same all the way across. UCL-R=D4(Rbar) Note: D4 values are in table 5.4 on page 123 of the text. Remember the sample size is 5. Also, since R-bar is the same all the way across, so is the UCL-R. LCL-R=D3(Rbar) Note: D3 values are in table 5.4 on page 123 of the text. Remember the sample size is 5. Also, since R-bar is the same all the way across, so is the LCL-R. Mean-the average of the 5 observations. X-bar-bar-the average of the averages of the 5 observations. UCL-X=X-bar-bar + A2 (R-bar) Note: A2 values are in table 5.4 on page 121 of the text. Remember the sample size is 5. Also, since X-bar-bar is the same all the way across, so is the UCL-X. LCL-X=X-bar-bar-A2(R-bar) Note: A2 values are in table 5.4 on page 121 of the text. Remember the sample size is 5. Also, since X-bar-bar is the same all the way across, so is the LCL-X. Determine if the R chart is in control. Hint: Does range stay within the LCL and UCL forthe entire sample? yeso 3. Determine if the X chart is in control. Hint: Does the mean stay within the LCL and the UCL for the entire sample? yeso Make a separate copy of your completed excel document. Do not try and save on this document. (It will not save) After copying onto a new excel document, submit through Canvas in this assignment 2. 4. 5. 77 The Problem Our company produces hard drives for computers. The average seek time for the hard drive has been determined to be 12.1ms +/-.25ms. During each hour of a 10-hour production run, a sample of 5 hard drives was collected at a process along the line. The data displayed on the excel document were collected. Complete the chart in it's entirety. Be sure to answer whether the X and R charts are in control. After completing this assignment the student will be able to: . Calculate the average range of several observations in a sample and set the lower and upper control limits for that range. (CourseSLO14,Chapter5-SLO1, Chapter5- SLO4,Chapter5-SLO5) Calculate the mean of several observations in a sample and set the lower and upper control limits for that mean. (Course SLO14 Chapter5-SL01, Chapter5-SLO4,Chapter5- SLO5) Determine if the quality specifications are met using statistical process control methods. (CourseSLO14 Chapter5-SLO1, Chapter5-SLO4,Chapter5-SLO5)