Statit Support Articles
Administration
Frequently Asked Questions
How-to
ODBC
Sample Code
 
Quality Practice Tips

Subscribe to Statit Bulletin, our quarterly SPC/Quality Resource e-newsletter

Your Name:
E-mail:
Company:
 

Creating Xbar Charts with Summarized Data


Most examples of Xbar charts use raw data that are grouped dynamically or by a specified variable. The data values determine the group mean, which is plotted on the chart. The center line and control limits are also calculated from the data. In some circumstances, the data are already summarized into group means, ranges and/or standard deviations. Summarized data can be used in variable charts by selecting appropriate options. This discussion will illustrate how to generate Xbar, R and S charts using summarized data.

The first example generates an Xbar and range chart. The data are summarized for each lot. The data needed to produce the chart are the average diameters, range values, subgroup designations and subgroup sizes. The dialogue to produce the chart begins the same as a chart using raw data. Within the Xbar chart dialogue, select Avg_Diameter as the data variable, choose Subgroup Size using a variable and select Units_Tested. The important variation in this chart is to select the Summarized Data button. Check the box labeled Data are summarized and provide the variable containing the ranges or standard deviations. In this case, the subgroup sizes are reasonably small, so we are going to use the ranges in the Range variable. This dialog is shown in Figure 1.


Figure 1

The control chart is displayed in Figure 2. Since the subgroup sizes are not constant, the control limits are not constant. Because of this, adding the values of the control limits to the chart do not provide helpful information. A more useful alternative is to add variables to the data tips. In this example, it is advantageous to add the range, subgroup size (n), upper control limit and lower control limit to the default data tips for each point.


Figure 2

The accompanying R chart for this data requires that the user check the Data are summarized box under the Summarized Data button. An example of this dialogue can be seen in Figure 3. It is helpful to include the subgroup size and control limits in the data tips for this chart as well.


Figure 3

The resultant range chart is displayed in Figure 4.


Figure 4

The data set in the following example has larger subgroup sizes. Instead of a variable with the subgroup ranges, this dataset contains the subgroup standard deviation as shown in Figure 5. When entering the variable, there is no option to specify the type of value being passed to the control chart.


Figure 5

By default, control limits for X-bar charts are calculated using subgroup range values. However, the use of range values is valid as long as the subgroup sizes are between 2 and 30, inclusive. This dataset uses the Units_Tested variable for subgroup sizes. These values are well beyond the allowable subgroup size. Attempting to produce an X-bar with the current selections would result in an error as shown in the example in Figure 6. Note that this is basically the same dialogue that was used to generate the X-bar chart in Figure 3, even though this data set has much larger subgroup sizes and sample standard deviation values instead of the range values. The software recognizes that the subgroup sizes are not compatible with the choices that have been made up to this point. It is, therefore, necessary to specify that the control limits be calculated using the subgroup standard deviations.


Figure 6

The flag to specify that the control limits are to be calculated based on standard deviations instead of ranges is found in the dialogue in the Control Limits button. The dialogue is shown in Figure 7.


Figure 7

As discussed in the previous series of charts, the control limits vary. The subgroup sizes and control limits are added to the plotted data tips. The Xbar chart is displayed in Figure 8.


Figure 8

Generating the S chart uses similar choices as the R chart. The user specifies the variable containing the standard deviation values and checks the summarized data box under the Summarized Data button as illustrated in Figure 9.


Figure 9

The selection of additional data tip variables produce the final S Chart in figure 10.


Figure 10

If you would like additional information, please call our Support staff at (541) 752-4100 or send email to .