|
QWXL: Features
QWXL 3 is a powerful charting utility for Microsoft Excel® that offers many features to help you unlock the power of your data. These include eleven different charts over 5 chart screens and over 100 statistical calculations.
QWXL 3 Features
- MultiLine Chart
- Forecast Chart
- Logsheet
- Numeric data is displayed in colour (based on Limits)
- You can use Excel® based filtering to slice through data
- Prioritizing of relationships based on correlation coefficients
- Limits now saved as a Named Range on the Excel® Workbook
QWXL charts and statistics are available via 6 different screens that are accessible at the click of a mouse button.
Control Screen
The Control Screen offers a control chart, moving range chart and histogram in addition to several statistical calculations. The control chart displays your data over a color coded overlay of your specification and control limits. Average is automatically calculated, and limit calculations and x-axis labels are easily customized from their defaults.
Relate Screen
The Relate Screen uses two control charts to explore relationships between variables. It also offers a scatter plot and more statistics.
Compare Screen
The Compare Screen allows you to compare two separate time frames for an individual variable to help identify if a change has occurred in a product or variable. Included on this screen is a histogram and statistics.
Forecast Screen
The Forecast Screen offers new Forecast Chart that provides the ability to set goals for a variable and then allows the viewing of data in the future to predict when, or if, a goal will be met. The chart allows for the exploring of both linear and exponential plotting of data to determine the best fit for the data.
MultiLine Screen
The MultiLine Screen offers a new MultiLine Chart that allows for the comparison of multiple variables using the Capability Bar (+/- 3SD around the average) for each variable. Variables can be selected of filtered for inclusion in the chart.
The Logsheet Screen
The Logsheet Screen takes the spreadsheet data and reproduces it using colors based on either calculated of fixed limits for each variable. If limits are saved they will be inserted in the first seven rows of the spreadsheet.
Statistics in QWXL v3
In addition to providing exciting charts of your data, QWXL 3 automatically performs 100 different statistical calculations on your data, including target deviation, three different ways of calculating limits, average, moving range, and observed and calculated out of limits. These automatic calculations are reported on screen in the Statistics Box, making statistical analysis a breeze!
Ease of Use
QWXL 3 is a breeze to install and use, saving you from complicated set up procedures. The program offers a simple point and click interface that is intuitive and easy to learn and includes an on-line help program. By using your existing Excel® spreadsheets and templates, the majority of the work is already done and the data is just waiting to be analyzed. Imagine: power and sophistication without the effort!
A Pedigree of Excel®lence
QWXL 3 uses the Quality Window charts which have been tested on the factory floors in over 50 countries for the past 10 years. Adopted as a standard by Fortune 500 firms for process monitoring, downtime analysis and quality control, Quality Window incorporates both traditional and cutting edge SPC/SQC theory in its calculations.
- Back to the QWXL index page
|
