Real Time SPC Template for Excel
X-bar-R chart Six Pack performs analysis as data is imported
This Real Time SPC template for Excel, parses your data into subgroups and automatically performs statistical analysis. It creates control charts, histograms and calculates Cp and Cpk.
To use this template:
- Click on the QI Macros menu and select Control Chart templates and then XbarR Six Pack.
- Select the tab labeled XbarR Realtime.
- Click on Cell
A1 and enter the number of samples per subgroup. If you have a USL and LSL, enter it in cells AM3 and AM5.
- Clear contents of cells B2:B21
- Click on Cell B2 and start entering data. You can type this manually or use a gage interface (USB or RS232)
- As you add new data your charts and calculations will update automatically.
- You can add more rows by copying cells C21:L21 down to row 22 and beyond.
Why Choose QI Macros Over Other Control Chart Software?
Affordable
- Only $279 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free
