qaqpbann.gif (1572 bytes)

trans.gif (85 bytes)spc-pc-info.gif (340 bytes)

Home
Software
Six Sigma
Certification
Books
Training
Support
Contact
Demos
Knowledge Center
Order Form
Search

Contents | Index

QUERY.CHART

Obtain numerical information from a chart

Syntax: QUERY.CHART (chart.title, item.no, [subgroup-no (zero-based)])

Reply:

requested.value successful
null unsuccessful

The chart.title to pass to this command is returned by the NEW.CHART command.

Note: Subgroup level data is available ONLY for items: 41, 42, 44, 45, 46, 51, and 52-55.

Parameters:

item.no
description
0
UCL for Average chart (or attribute chart)

LCL for Average chart (or attribute chart)

Average or Center for Range, Sigma, Attribute or CuSum chart;
Mean of X variable if Scatter

UCL for Range or Sigma chart

LCL for Range or Sigma chart

Average or Center for Average chart

Process Sigma

Population Sigma

Sample Sigma (of X variable if Scatter)

Cpk (or Ppk if sigma type != process)

Cr (or Pr if sigma type != process)

Cpm (or Ppm if sigma type != process)

Zu

Zl

% above high spec

% below low spec

smallest individual value (or Cusum)
smallest individual value of X for Scatter

largest individual value (or Cusum)
largest individual value of X if Scatter

Skewness (of X variable if Scatter)

Kurtosis (of X variable if Scatter)

K.S. Statistic for curve fit

Fitted Johnson curve:
0 = None
  1. = Sn
  2. = Sl
  3. = Sb
  4. = Su
22
Number of groups out of control
23
Comma-delimited list of groups out of control
24
Mean of Y variable if Scatter
25
Sample Sigma of Y variable if Scatter
26
Smallest individual value of Y if Scatter
27
Largest individual value of Y if Scatter
28
Skewness of Y variable if Scatter)
29
Kurtosis of Y variable if Scatter)
30
For Scatter, the B0 parameter in Y = B0 + B1*X
31
For Scatter, the B1 parameter in Y = B0 + B1*X
32
For Scatter, correlation coeff
33
For Scatter, Regression df
34
For Scatter, Regression SS
35
For Scatter, Regression MS
36
For Scatter, Residual df
37
For Scatter, Residual SS
38
For Scatter, Residual MS
39
For Scatter, F
40
For Scatter, Prob F
41
Subgroup out of control
42
Subgroup run tests
Bit 0 = Run test 1
...
Bit 7 = Run test 8
Bit 8 = User run test 1
...
Bit 15 = User run test 8

43
Reserved
44
Individual value The subgroup-no parameter should be:
LOWORD (bits 0-15) = subgroup no (zero-based)
HIWORD (bits 16-31) = element no in group (zero-based)
This is supported for chart types 0, 1, 2, 3, 5, 6, 9, 10, 11, 12, 15
45
Subgroup plot value
This is supported for chart types 0, 1, 2, 3, 5, 6, 9, 10, 11, 12, 15
46
Subgroup range/sigma
This is supported for chart types 0, 1, 2, 3, 5, 6, 15
47
Cpk/Ppk confidence
48
Cp/Pp confidence
49
Cpm/Ppm confidence
50
Optimal lambda (For wandering EWMA)
51
Subgroup forecast (For wandering EWMA)
52
Subgroup UCL on average chart
This is supported for chart types 0, 1, 2, 3, 5, 6, 9, 10, 11, 12, 15
53
Subgroup LCL on average chart
This is supported for chart types 0, 1, 2, 3, 5, 6, 9, 10, 11, 12, 15
54
Subgroup range/sigma UCL
This is supported for chart types 0, 1, 2, 3, 5, 6, 15
55
Subgroup range/sigma LCL
This is supported for chart types 0, 1, 2, 3, 5, 6, 15
99
Chart was calculated successfully
100
Zoom In is available
101
Zoom Out is available
102
Alert popup status:
0 = Alert Popup not supported by this chart type
  1. = Alert Popup hidden
  2. = Alert Popup visible

Site Map | Privacy | About Us

Copyright © 1995-1999 Quality America Inc. All Rights Reserved