Free Xbar Run Chart Template Download

========1========Control Chart for Mean and Range [Title or Process] [Date] Quality Characteristic Mean Thickness (Xbar) Sample Size, n [1] 5 k [2] 3 Statistics from Data Table R-bar [3] 0.184 Process Mean, m-hat [4] 4.166 Process St.Dev., s-hat [5] #REF! sX-bar [7] #REF! Control Limits for X-bar Chart CLX-bar 4.166 UCLX-bar #REF! LCLX-bar #REF! a [12] 0.0027 ARL [13] 370.4 samples Data Table Sample X-bar [14] Range [15] 1 4.1979891760.192717692 2 4.0476507570.21243095 3 4.1124681790.2351486058 4.166 4 4.1455592980.2113610741 4.166 Process Capability Upper Spec Limit, USL Lower Spec Limit, LSL Cp [6] CPU [8] CPL [9] Cpk [10] Percent Yield [11] 4.5 3.5 #REF! #REF! #REF! #REF! #REF! CL+ksX-bar CL-ksX-bar Control Limits for R Chart CLR 0.184 UCLR #REF! LCLR #REF! X-bar Chart CL UCL 4.166 #REF! 4.166 #REF! #REF! #REF! LCL #REF! #REF! #REF! #REF! R Chart CL 0.184 0.184 0.184 0.184 UCL #REF! #REF! #REF! #REF! LCL #REF! #REF! #REF! #REF!========2========5 4.350119324 0.3086693 4.166 6 4.0997536220.1615460713 4.166 7 4.0097125240.194746015 4.166 8 4.0131768290.20929082 4.166 9 4.1644972580.1661414515 4.166 10 4.2258057140.1634508975 4.166 11 4.2008539230.186566162 4.166 12 4.1030202020.233398436 4.166 13 4.1133223730.19931259 4.166 14 4.2036135870.197763984 4.166 15 4.1820095830.1597361246 4.166 16 4.2017524410.176643066 4.166 17 4.1635293170.1751909587 4.166 18 4.2032122740.1735190963 4.166 19 4.2041368610.1520912171 4.166 20 4.1405354270.2108459486 4.166 21 4.22500293 0.169596354 4.166 22 4.2086954750.213655475 4.166 23 4.1993073020.1640045163 4.166 24 4.2463062030.1696474708 4.166 25 4.0396699520.20246048 4.166 26 4.0805366680.2071799404 4.166 27 4.0409518550.1474648436 4.166 28 4.1982067870.163979492 4.166 29 4.2022922650.1824085906 4.166 30 4.2590514120.1622009275 4.166 31 4.20141744 0.1584259033 4.166 32 4.1296825560.14690399 4.166 33 4.1548873160.17471732 4.166 34 4.0139819360.26318016 4.166 35 4.1074924920.163710022 4.166 36 4.2518688960.1722447717 4.166 37 4.1761469810.1631637747 4.166 38 4.1761469810.1631637747 4.166 39 4.2259887190.1532958983 4.166 40 4.23785957 0.1446015624 4.166 41 4.2399846780.1817521724 4.166 42 4.2047406820.1673109701 4.166 43 4.2543051380.1698458154 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!========3========4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 4.166 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 0.184 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!========4========[1] The number of measurements within each sample. For this chart, all samples are assumed to be the same size. In this spreadsheet, the sample size must be between 2 and 25. [2] The k-value is number of standard deviations (typically 3) that the upper and lower control limits are placed away from the center line. [3] R-bar is the mean of the Ranges in the data table and is used as the center line for the R-Chart. [4] The estimated process mean is calculated as the mean of the X-bar values from the data table. It is used as the Center Line for the X-bar Chart. [5] The estimated process standard deviation. [6] The Cp index is calculated as (USL-LSL)/(6*sigma) where sigma is the process standard deviation. You want Cp to be greater than 1. [7] This is the standard deviation of the sample mean, calculated as the process standard deviation divided by the square root of the sample size. [8] The CPU index is the upper capability index for when you are only given an upper spec limit, USL. You want CPU > 1 [9] The CPL index is the lower capability index for when you are only given a lower spec limit, LSL. You want a CPL > 1. [10] The Cpk index is used when the process mean is shifted away from the target value, or the point half way between the spec limits. It is the minimum of the CPU and CPL. You want a Cpk>1. [11] Percent Yield measures the proportion of the output that is within the spec limits, assuming a Normal population distribution. [12] Probability of a Type I Error (a): If a sample value falls outside the control limits, we would conclude that the process is out of control. A Type I error is made when the process is concluded to be out of control when it is really in control. This probability is calculated assuming a normal distribution for the process. [13] In-Control Average Run Length: If the process is in-control, the ARL is the number of samples, on average, you would observe before getting an out-of-control signal. In other words, you expect to get a false alarm (a point outside the control limits) every N samples, where N is the ARL. [14] X-bar is the sample mean calculated as the sum of the observations divided by the number of observations in the sample (n). [15] The range for each sample is calculated as the Max value minus the Min value.========5========