XLSTAT-SPC

XLSTAT-SPC is an Excel add-in which has been developed to provide XLSTAT-Pro users with a powerful solution for Statistical Process Control (SPC). XLSTAT-SPC is the ideal product for companies that which to apply Six Sigma methods to control and improve the quality of their production or sales processes.

All XLSTAT-SPC functions have been intensively tested against other software to guarantee the users fully reliable results, and to allow you to integrate this software in your Six Sigma business improvement process.

FEATURES:

SUBGROUP CHARTS:

Use this tool to supervise production quality, in the case where you have a group of measurements for each point in time. The measurements need to be quantitative data. This tool is useful to recap the mean and the variability of the measured production quality.

Integrated in this tool, you will find Box-Cox transformations, calculation of process capability and the application of rules for special causes and Westgard rules (an alternative set of rules to identify special causes) to complete your analysis.

The subgroup charts tool offers you the following chart types alone or in combination:

- X bar
- R
- S
- S²

An X bar chart is useful to follow the mean of a production process. Mean shifts are easily visible in the diagrams.

An R chart (Range chart) is useful to analyze the variability of the production. A large difference in production, caused for example by the use of different production lines, will be easily visible.

S and S² charts are also used to analyze the variability of production. The S chart draws the standard deviation of the process and the S² chart draws the variance (which is the square of the standard deviation). Click here to see a tutorial.

INDIVIDUAL CHARTS:

Use this tool to supervise the production quality, in the case where you have a single measurement for each point in time. The measurements need to be quantitative variables.

This tool is useful to recap the moving mean and median and the variability of the production quality that is being measured.

Integrated in this tool, you will find Box-Cox transformations, calculation of process capability and the application of rules for special causes and Westgard rules (an alternative rule set to identify special causes) available to complete your analysis.

The individual charts tool offers you the following chart types alone or in combination:

- X Individual
- MR moving range

An X individual chart is useful to follow the moving mean of a production process. Mean shifts are easily visible in the diagrams.

An MR chart (moving range diagram) is useful to analyze the variability of the production. Large difference in production, caused by the use of different production lines, will be easily visible. Click here to see a tutorial.

ATTRIBUTE CHARTS:

Use this tool to supervise the production quality, in the case where you have a single measurement for each point in time. The measurements are based on attribute or attribute counts of the process.

This tool is useful to recap the categorical variables of the measured production quality.

Integrated in this tool, you will find Box-Cox transformations, calculation of process capability and the application of rules for special causes and Westgard rules (an alternative rule set to identify special causes) available to complete your analysis.

The attribute charts tool offers you the following chart types:

- P chart
- NP chart
- C chart
- U chart

A P chart is useful to follow the fraction of non conforming units of a production process.

An NP chart is useful to follow the absolute number of non conforming units of a production process.

A C chart is useful to follow the number of non conforming units per inspection unit of a production process having a constant size of a inspection unit.

A U chart is useful to follow the number of non conforming units per inspection unit of a production process having a non constant size of a inspection unit. Click here to see a tutorial.

TIME WEIGHTED CHARTS:

Use this tool to supervise production quality, in the case where you have a group of measurements or a single measurement for each point in time. The measurements need to be quantitative variables.

This tool is useful to recap the mean and the variability of the measured production quality.

Integrated in this tool, you will find Box-Cox transformations, calculation of process capability and the application of rules for special causes and Westgard rules (an alternative rule set to identify special causes) available to complete your analysis.

The time weighted charts tool offers you the following chart types:

- CUSUM or CUSUM individual
- UWMA or UWMA individual
- EWMA or EWMA individual

A CUSUM, UWMA or EWMA chart is useful to follow the mean of a production process. Mean shifts are easily visible in the diagrams.

UWMA and EWMA charts

These charts are not directly based on the raw data. They are based on the smoothed data.

In the case of UWMA charts, the data is smoothed using a uniform weighting in a moving window. Then the chart is analyzed like Shewhart charts.

In the case of EWMA charts, the data is smoothed using a exponentially weighting. Then the chart is analyzed like Shewhart charts.

CUSUM charts

These charts are not directly based on the raw data. They are based on the normalized data.

These charts help to detect mean shifts of a user defined granularity. The granularity is defined by the design parameter k. K is the half of the mean shift to be detected. Normally to detect 1 sigma shifts, k is set to 0.5.

Two kinds of CUSUM charts can be drawn: one and two sided charts. Click here to see a tutorial.

PARETO PLOTS:

Use this tool to calculate descriptive statistics and display Pareto plots (bar and pie charts) for a set of qualitative variables.

XLSTAT offers you a large number of descriptive statistics and charts which give you a useful and relevant preview of your data.

Although you can select several variables (or samples) at the same time, XLSTAT calculates all the descriptive statistics for each of the samples independently. Click here to see a tutorial.

Demo version

A trial version of XLSTAT-SPC is included in the main XLStat-Pro download.

Ordering XLStat-SPC

The prices, in UK£ and US$, for academic and commercial users are listed below. There are two ordering options:

1. E-mail only - a registration code will be e-mailed to you that will unlock the demo version of the program from our web site.
2. With CD-ROM - this costs an additional £15 ($30) + shipping & handling.

You can order on-line using our secure shopping cart facility below. Simply choose the required item and price and press the "Add to cart" button in that row to add the item to your shopping cart.

If you already have XLStat-Pro then use the section below to order just the advanced module. Please send us your original XLStat-Pro serial number, either in the Special Instructions section of the order form or in a separate e-mail.

Notes:

1. Academic prices (where offered) apply to students and staff at educational institutions using the software for research as well as charities/NGOs and residents of least developed countries. Governmental bodies pay the commercial price. Commercial prices also apply if the software is to be used for commercial consulting within universities.
2. VAT - Customers within the UK will have Value Added Tax at 17.5% added to the order. Those in other countries in the European Union will also have VAT added, unless they are registered for VAT in their own country and supply their registration number with their order (in the "Special Instructions" section at checkout). Our VAT registration number is GB 625 3760 41.
3. If you wish to order by fax or postal mail, or need to pay by means other than credit card, then you can also use the shopping cart above, but choose the appropriate option when you check out. You can also print out and use our printed order form.
4. All credit card orders are charged in British pounds. The US$ prices apply only when paying in US$ by check (drawn on a US bank) or bank transfer.
5. Your order will normally be processed within two working days. Orders outside of the United Kingdom are shipped by air-mail. Within the UK first class post is used.
6. All prices above are for single computer/user licenses. The program may only be used on a single computer, or by a single user on up to two computers (i.e. a single user can use it on both an office computer and a laptop, so long as no one else is using those computers). Contact us for discounts on multiple copies and site licenses.