On the input screen above for the chart, there is a button labeled "Show Options". An example based on the data above is shown below. Once you have select the options you want (again, no options are required to make the chart), select OK and the chart will be generated. Show Options: selecting this button shows the various options for this chart (see options below)Ħ.Automatic Updating of Limits: option controls whether the average and control limits are updated as new data are added, default value is Yes set this to No to stop the average and control limits from updating.In One Row: the subgroup identifiers are in one row.In One Column: the subgroup identifiers are in one column (as in this example).Subgroup Identifiers: this information is used to search for new data when updating the chart (see below).Subgroup Size: enter the subgroup size default value is determined by the range selected on the worksheet maximum subgroup size is 100 (note: if you change the subgroup size here, the software will adjust the data range).Name of Chart: chart name - must be a unique name in the workbook and is limited to 25 characters.Data: the worksheet range containing the data in subgroups.Subgroup Identifiers: the worksheet range containing the subgroup identifiers.If you select OK at this point, the software will generate the chart using the default options. This is all that is needed to make the chart. It must be unique - there can not be another workbook tab with that name. This is the name that will appear on the worksheet tab containing the chart. In this example, the name "Weight" is used as the name of the chart. This is why there is an advantage to selecting the subgroup and data ranges prior to making the chart. The program sets the initial subgroup identifiers and data ranges (cells A8:A32 and cells B8:E32 in the example workbook) as well as the subgroup size based on the range you selected on the worksheet. The input screen for the chart is then displayed. Select "Xbar-s Chart" from the "Subgroup Charts" tab. The input screen for variable control charts is displayed.Ĥ. Select "Variable" from the "Control Charts" panel on the SPC for Excel ribbon.ģ. You can use "Select Cells" in the "Utilities" panel of the SPC for Excel ribbon to quickly select the cells.Ģ. Select the data on the worksheet to be included in the analysis. The example is using a subgroup size of four. You enter the data are entered into a worksheet as shown below The data does not have to start in A1. We take four samples at the start of each hour and use those four samples to form subgroups. Suppose we monitoring the weight of a product. Changing the options for the Xbar-s chart.Updating the Xbar-s chart with new data.This page shows you how to make the Xbar-s chart. For more information on Xbar-s charts please see our SPC Knowledge Base on our website. To use an Xbar-s chart, you need frequent data and a method rationally subgrouping the data. You calculate the standard deviation of the four batches and plot those on the s chart. You calculate the average conversion for the four batches and plot those results on the Xbar chart. You use those four batches to form a subgroup. For example, you might be measuring the conversion from a batch reactor. You subgroup data when use an Xbar-s chart. The Xbar-s chart is used with variables data - data that can be "measured" like time, density, weight, conversion, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |