SPC Statistics available

• Basic statistics

• Capability

• Control limits

• Maximum/minimum

• Spec analysis

• Spread analysis

• Percent analysis

• Counts

• Non-normal

• Trend

• Dates and/or times

• Configuration setting

• Standard setting

• Standard limits

• Retrieval settings

• Miscellaneous

Default label

Explanation

Code(s)

Count excluded subgroups

Number of subgroups that are excluded as outliers or bypassed records (records set to Bypass record or Include on charts and data lists only) .

8

Count excluded values

Number of individual values associated with subgroups that are excluded as outliers or bypassed records (records set to Bypass record or Include on charts and data lists only) .

5

Count included subgroups

Number of subgroups that are not excluded as outliers or bypassed records (records set to Bypass record or Include on charts and data lists only) .

7

Count included values

Number of individual values associated with subgroups that are not excluded as outliers or bypassed records (records set to Bypass record or Include on charts and data lists only) .

4

Mean

The average of all individual values for the retrieved data.

23

Mean - nominal

Calculated as Mean - Nominal spec

264

Median

Calculated by arranging all individual values in order and then picking the middle one. If the number of values is even, the median is the mean of the two middle numbers. The median is useful when the distribution has very large extreme values that can skew the data.

67

Median range

Calculated by arranging all range values in order and then picking the middle one. If the number of values is even, the median is the mean of the two middle numbers.

64 and 78

Median subgroup

Calculated by arranging all subgroup values in order and then picking the middle one. If the number of values is even, the median is the mean of the two middle numbers.

61

Mode

The individual data value that occurs most often.

160

No data found

Returns "Yes" if no data is found to analyze.

285

R-Bar

The average of all range values for the retrieved data.

24 and 25

SD (factors)

Standard deviation of individual values calculated by the Factors Method:

This method of calculating standard deviation is sensitive to variation within subgroups.

26

SD (range)

Standard deviation of range values calculated by the Sample Standard Deviation method:

28 and 29

SD (sample)

Standard deviation of individual values calculated by the Sample Standard Deviation method:

This method of calculating standard deviation is sensitive to variation between subgroups.

27

SD (subgroup)

Standard deviation of subgroup values calculated by the Sample Standard Deviation method:

286

Subgroup size

Subgroup size of retrieved data.
If retrieval contains data with incomplete subgroups or data entered with different subgroup sizes, this returns "NA".

0

Total subgroups

Number of subgroups in the retrieved data. This number includes excluded subgroups (subgroups that are excluded as outliers or bypassed records).

6

Total values

Number of individual values in the retrieved data. This number includes individual values associated with excluded subgroups (subgroups that are excluded as outliers or bypassed records).

3

Default label

Explanation

Code

Cp

Estimate of process capability if the process is centered between the specification limits. Process spread is based on SD (factors).

125

Cpk

Estimate of process capability if the process center moves toward one of the specification limits. Process spread is based on SD (factors). A Cpk less than zero indicates that the center of the process lies outside the specification limits.

121

Cpm

Estimate of process capability around a target.

129

CR

Capability ratio that is calculated as the inverse of Cp.

123

PC

The ratio of the process spread to the specification limit spread where the process spread is determined by SD (factors).

127

Pp

Estimate of process performance if the process is centered between the specification limits. Process spread is based on SD (sample).

126

PP

The ratio of the process spread to the specification limit spread where the process spread is determined by SD (sample).

128

Ppk

Estimate of process performance if the process center moves toward one of the specification limits. Process spread is based on SD (sample). A Ppk less than zero indicates that the center of the process lies outside the specification limits.

122

PR

Performance ratio that is calculated as the inverse of Pp.

124

Sigma level

Returns the smaller of the two Z values (Zl or Zu) used to calculate process capability.

304

Zl

The distance of the process average from the lower specification limits measured in standard deviation units. The standard deviation is based on factors, sample, or fit to a non-normal curve. (Zl factors, Zl SSD or Zl non-normal.)

136

Zl factors

The distance of the process average from the lower specification limits measured in standard deviation units. The standard deviation is based on SD (factors).

130

Zl non-normal

The distance of the process average from the lower specification limits measured in standard deviation units. The standard deviation is based on the non-normal curve.

134

Zl SSD

The distance of the process average from the lower specification limits measured in standard deviation units. The standard deviation is based on SD (sample).

132

Zu

The distance of the process average from the upper specification limits measured in standard deviation units. The standard deviation is based on factors, sample, or fit to a non-normal curve. (Zu factors, Zu SSD or Zu non-normal.)

137

Zu factors

The distance of the process average from the upper specification limits measured in standard deviation units. The standard deviation is based on SD (factors).

131

Zu non-normal

The distance of the process average from the upper specification limits measured in standard deviation units. The standard deviation is based on the non-normal curve.

135

Zu SSD

The distance of the process average from the upper specification limits measured in standard deviation units. The standard deviation is based on SD (sample).

133

Default label

Explanation

Code(s)

EWMA LCLx

Lower control limit for EWMA chart:

where W = EWMA Weight

177 and 179

EWMA UCLx

Upper control limit for EWMA chart:

where W = EWMA Weight

176 and 178

LCLr

Lower control limit for the range chart. This value is affected by the method used to calculate control limits, the range chart selected for the standard, and the way the data is coded for Short Run charts.

102 and 106

LCLx

Lower control limit for the X or X-bar chart. This value is affected by the method used to calculate control limits, the range chart selected for the standard, and the way the data is coded for Short Run charts.
If the subgroup size for the data set is 1 and the distribution is non-normal, the value may be calculated differently if non-symmetrical control limits are reported.
If the standard setting for Lower Control limit cannot be less than zero is selected, the value may be adjusted if it falls below zero.

100 and 104

LCLx for zones

Lower subgroup control limit used for zone checking when the Lower Control limit cannot be less than zero check box is selected in the standard.

108 and 109

Moving average LCLr

Lower control limit for the moving average range chart. This value is affected by the method used to calculate control limits, the range chart selected for the standard, and the way the data is coded for Short Run charts.

185

Moving average LCLx

Lower control limit for the moving average chart. This value is affected by the method used to calculate control limits, the range chart selected for the standard, and the way the data is coded for Short Run charts.
If the subgroup size for the data set is 1 and the distribution is non-normal, the value may be calculated differently if non-symmetrical control limits are reported.
If the standard setting for Lower Control limit cannot be less than zero is selected, the value may be adjusted if it falls below zero.

182

Moving average mean

The average of the moving average values displayed on the chart. The moving averages are calculated from the retrieved data using the Moving average span.

181

Moving average R-Bar

The average of the moving average range values displayed on the chart. The moving average range values are calculated from the retrieved data using the Moving average span.

184

Moving average UCLr

Upper control limit for the moving average range chart. This value is affected by the method used to calculate control limits, the range chart selected for the standard, and the way the data is coded for Short Run charts.

183

Moving average UCLx

Upper control limit for the moving average chart. This value is affected by the method used to calculate control limits, the range chart selected for the standard, and the way the data is coded for Short Run charts.
If the subgroup size for the data set is 1 and the distribution is non-normal, the value may be calculated differently if non-symmetrical control limits are reported.

180

Trend LCLx

Lower control limit for a trend chart that is calculated from the spread of data around the linear regression line that best fits the data.

151 and 155

Trend UCLx

Upper control limit for a trend chart that is calculated from the spread of data around the linear regression line that best fits the data.

150 and 154

Trend Y-intercept LCLx

The value where the lower trend control limit intersects the Y axis.

153 and 157

Trend Y-intercept UCLx

The value where the upper trend control limit intersects the Y axis.

152 and 156

UCLr

Upper control limit for the range chart. This value is affected by the method used to calculate control limits, the range chart selected for the standard, and the way the data is coded for Short Run charts.

103 and 107

UCLx

Upper control limit for the X or X-bar chart. This value is affected by the method used to calculate control limits, the range chart selected for the standard, and the way the data is coded for Short Run charts.
If the subgroup size for the data set is 1 and the distribution is non-normal, the value may be calculated differently if non-symmetrical control limits are reported.

101 and 105

Default label

Explanation

Code(s)

Maximum range

Maximum value in the calculated set of range values. This includes range values for subgroups that are bypassed (records set to Bypass record or Include on charts and data lists only) or statistical outliers.

53 and 57

Maximum range included

Maximum value in the calculated set of range values that are not excluded (as outliers or as bypassed records) .

62 and 76

Maximum range not bypassed

Maximum value in the calculated set of range values that are not bypassed (records set to Bypass record or Include on charts and data lists only) .

239 and 243

Maximum subgroup

Maximum subgroup value in the retrieved data. This includes subgroups that are bypassed (records set to Bypass record or Include on charts and data lists only) or statistical outliers.

51

Maximum subgroup included

Maximum subgroup value in the retrieved data that is not excluded (as outliers or as bypassed records) .

59

Maximum subgroup not bypassed

Maximum subgroup value in the retrieved data that is not bypassed (records set to Bypass record or Include on charts and data lists only) .

237

Maximum value

Maximum individual value in the retrieved data. This includes values associated with subgroups that are bypassed (records set to Bypass record or Include on charts and data lists only) or statistical outliers.

55

Maximum value included

Maximum individual value in the retrieved data that is not part of an excluded subgroup (subgroup that is excluded as an outlier or a bypassed record) .

65

Maximum value not bypassed

Maximum individual value in the retrieved data that is not part of a bypassed (records set to Bypass record or Include on charts and data lists only) subgroup.

241

Minimum range

Minimum value in the calculated set of range values. This includes range values for subgroups that are bypassed (records set to Bypass record or Include on charts and data lists only) or statistical outliers.

54 and 58

Minimum range included

Minimum value in the calculated set of range values that is not excluded (as outliers or as bypassed records) .

63 and 77

Minimum range not bypassed

Minimum value in the calculated set of range values that is not bypassed (records set to Bypass record or Include on charts and data lists only) .

240 and 244

Minimum subgroup

Minimum subgroup value in the retrieved data.  This includes subgroups that are bypassed (records set to Bypass record or Include on charts and data lists only) or statistical outliers.

52

Minimum subgroup included

Minimum subgroup value in the retrieved data that is not excluded (as outliers or as bypassed records) .

60

Minimum subgroup not bypassed

Minimum subgroup value in the retrieved data that is not bypassed (records set to Bypass record or Include on charts and data lists only) .

238

Minimum value

Minimum individual value in the retrieved data. This includes values associated with subgroups that are bypassed (records set to Bypass record or Include on charts and data lists only) or statistical outliers.

56

Minimum value included

Minimum subgroup value in the retrieved data that is not part of an excluded subgroup (subgroup that is excluded as an outlier or a bypassed record) .

66

Minimum value not bypassed

Minimum subgroup value in the retrieved data that is not part of a bypassed subgroup (records set to Bypass record or Include on charts and data lists only) .

242

Default label

Explanation

Code

Offset Percentage

Percentage that the mean is different from the target, based on specs.
100.0 * ((Mean – Target) / Tolerance)

40

% above lower Spec

Percent of included values above the lower specification limit.
If the lower spec is not set, this returns "NA".

255

% above Spec

Percent of included values above the upper specification limit.
If the upper spec is not set, this returns "NA".

68

% above Spec predicted

Percent of values predicted to fall above the upper specification limit based on the fitted curve. This value is not reliable with small sample sizes.
If the upper spec is not set, this returns "NA".

80

% below Spec

Percent of included values below the lower specification limit.
If the lower spec is not set, this returns "NA".

69

% below Spec predicted

Percent of values predicted to fall below the lower specification limit based on the fitted curve. This value is not reliable with small sample sizes.
If the lower spec is not set, this returns "NA".

79

% below upper Spec

Percent of included values below the upper specification limit.
If the upper spec is not set, this returns "NA".

256

% in Spec

Percent of included values between the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

70

% in Spec predicted

Percent of values predicted to fall inside the upper and lower specification limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

82

% out of Spec

Percent of included values outside the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

71

% out of Spec predicted

Percent of values predicted to fall outside the upper and lower specification limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

81

Count above Spec

Count of included values above the upper specification limit.
If the upper spec is not set, this returns "NA".

211

Count above Spec predicted

Number of values predicted to fall above the upper spec limit based on the fitted curve. This value is not reliable with small sample sizes.
If the upper spec is not set, this returns "NA".

287

Count below Spec

Count of included values below the lower specification limit.
If the lower spec is not set, this returns "NA".

212

Count below Spec predicted

Number of values predicted to fall below the lower spec limit based on the fitted curve. This value is not reliable with small sample sizes.
If the Lower Spec is not set, this returns "NA".

288

Count in Spec

Count of included values between the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

195

Count in Spec predicted

Number of data values predicted to fall between the upper and lower spec limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

289

Count out of Spec

Count of included values outside the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

194

Count out of Spec predicted

Number of data values predicted to fall outside the upper and lower spec limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

290

Mean - 3SD within Spec

If Mean – 3SD falls above the lower spec, this returns "Yes".
If Mean – 3SD falls below the lower spec, this returns "No".
If there is no spec or SD can’t be calculated, this returns "NA".

91

Mean - 4SD within Spec

If Mean – 4SD falls above the lower spec, this returns "Yes".
If Mean – 4SD falls below the lower spec, this returns "No".
If there is no spec or SD can’t be calculated, this returns "NA".

93

Mean + 3SD within Spec

If Mean + 3SD falls below the upper spec, this returns "Yes".
If Mean + 3SD falls above the upper spec, this returns "No".
If there is no spec or SD can’t be calculated, this returns "NA".

90

Mean + 4SD within Spec

If Mean + 4SD falls below the upper spec, this returns "Yes".
If Mean + 4SD falls above the upper spec, this returns "No".
If there is no spec or SD can’t be calculated, this returns "NA".

92

PPM above Spec

PPM of included values above the upper specification limit.
If the upper spec is not set, this returns "NA".

72

PPM above Spec predicted

PPM of values predicted to fall above the upper specification limit based on the fitted curve. This value is not reliable with small sample sizes.
If the upper spec is not set, this returns "NA".

84

PPM below Spec

PPM of included values below the lower specification limit.
If the lower spec is not set, this returns "NA".

73

PPM below Spec predicted

PPM of values predicted to fall below the lower specification limit based on the fitted curve. This value is not reliable with small sample sizes.
If the lower spec is not set, this returns "NA".

83

PPM in Spec

PPM of included values between the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

74

PPM in Spec predicted

PPM of values predicted to fall inside the upper and lower specification limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

86

PPM out of Spec

PPM of included values outside the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

75

PPM out of Spec predicted

PPM of values predicted to fall outside the upper and lower specification limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

85

Default label

Explanation

Code

First quartile

The value below which 25% of the ranked data values lie.

229

Mean - 3SD

The value below which one would expect to find .135 percent of the values from a data set.
This value is calculated based on the Method for calculating standard deviation setting and type of data distribution (Normal or Non-normal).

88

Mean - 3SD within Spec

If Mean – 3SD falls above the lower spec, this returns "Yes".
If Mean – 3SD falls below the lower spec, this returns "No".
If there is no spec or SD can’t be calculated, this returns "NA".

91

Mean - 4SD

The value below which one would expect to find .003 percent of the values from a data set.
This value is calculated based on the Method for calculating standard deviation setting and type of data distribution (Normal or Non-normal).

95

Mean -4SD within Spec

If Mean – 4SD falls above the lower spec, this returns "Yes".
If Mean – 4SD falls below the lower spec, this returns "No".
If there is no spec or SD can’t be calculated, this returns "NA".

93

Mean + 3SD

The value above which one would expect to find .135 percent of the values from a data set.
This value is calculated based on the Method for calculating standard deviation setting and type of data distribution (Normal or Non-normal).

87

Mean + 3SD within Spec

If Mean + 3SD falls below the upper spec, this returns "Yes".
If Mean + 3SD falls above the upper spec, this returns "No".
If there is no spec or SD can’t be calculated, this returns "NA".

90

Mean + 4SD

The value above which one would expect to find .003 percent of the values from a data set.
This value is calculated based on the Method for calculating standard deviation setting and type of data distribution (Normal or Non-normal).

94

Mean + 4SD within Spec

If Mean + 4SD falls below the upper spec, this returns "Yes".
If Mean + 4SD falls above the upper spec, this returns "No".
If there is no spec or SD can’t be calculated, this returns "NA".

92

Six SD

The spread within which one would expect to find 99.9973 percent of the data values. This value is calculated based on the Method for calculating standard deviation setting and type of data distribution (Normal or Non-normal).

89

Third quartile

The value above which 25% of the ranked data values lie.

230

Default label

Explanation

Code

% above Control

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall above the upper control limit (UCLx).

163

% above Gate

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall above the upper Gate limit.
If the upper gate limit is not set, this returns "NA".

167

% above Ind. Gate

Percent of included values that fall above the upper Ind. Gate limit.
If the upper Ind. Gate limit is not set, this returns "NA".

249

% above lower Gate

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall above the lower Gate limit.
If the lower gate limit is not set, this returns "NA".

257

% above lower Ind. Gate

Percent of included values that fall above the lower Ind. Gate limit.
If the lower Ind. Gate limit is not set, this returns "NA".

253

% above lower Spec

Percent of included values above the Lower Spec.
If the Lower Spec is not set, this returns "NA".

255

% above Range Gate

Percent of included values above the Range Gate.
If the Range Gate is not set, this returns "NA".

314

% above Spec

Percent of included values above the Upper Spec.
If the Upper Spec is not set, this returns "NA".

68

% above Spec predicted

Percent of values predicted to fall above the Upper Spec based on the fitted curve. This value is not reliable with small sample sizes.
If the Upper Spec is not set, this returns "NA".

80

% above target

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall above the Target X.
If the Target X is not set, this returns "NA".

214

% below Control

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall below the lower control limit (LCLx).

164

% below Gate

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall below the lower Gate limit.
If the lower gate limit is not set, this returns "NA".

168

% below Ind. Gate

Percent of included values that fall below the lower Ind. Gate limit.
If the lower Ind. Gate limit is not set, this returns "NA".

250

% below Spec

Percent of included values below the Lower Spec.
If the Lower Spec is not set, this returns "NA".

69

% below Spec predicted

Percent of values predicted to fall below the Lower Spec based on the fitted curve. This value is not reliable with small sample sizes.
If the Lower Spec is not set, this returns "NA".

79

% below target

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall below the Target X.
If the Target X is not set, this returns "NA".

216

% below upper Gate

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall below the upper Gate limit.
If the upper gate limit is not set, this returns "NA".

258

% below upper Ind. Gate

Percent of included values that fall below the upper Ind. Gate limit.
If the upper Ind. Gate limit is not set, this returns "NA".

254

% below upper Spec

Percent of included values below the Upper Spec.
If the Upper Spec is not set, this returns "NA".

256

% in Control

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall between the upper and lower Control limits.

166

% in Gate

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall between the upper and lower Gate limits.
If the upper or lower Gate limit is not set, this returns "NA".

170

% in Ind. Gate

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall between the upper and lower Ind. Gate limits.
If the upper or lower Ind. Gate limit is not set, this returns "NA".

252

% in Spec

Percent of included values between the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

70

% in Spec predicted

Percent of values predicted to fall inside the upper and lower specification limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

82

% out of Control

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall outside the upper and lower Control limits.

165

% out of Gate

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall outside the upper and lower Gate limits.
If the upper or lower Gate limit is not set, this returns "NA".

169

% out of Ind. Gate

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall outside the upper and lower Ind. Gate limits.
If the upper or lower Ind. Gate limit is not set, this returns "NA".

251

% out of Spec

Percent of included values outside the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

71

% out of Spec predicted

Percent of values predicted to fall outside the upper and lower specification limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

81

% subgroups within 1 sigma

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall within 1 sigma from the mean.
This statistic is based on the upper and lower control limits and is affected by the way the control limits are calculated.

188

% subgroups within 2 sigma

Percent of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall within 2 sigma from the mean.
This statistic is based on the upper and lower control limits and is affected by the way the control limits are calculated.

189

Default label

Explanation

Code

Bypassed subgroups

Number of subgroups set to Bypass record or Include on charts and data lists only.

234

Bypassed values

Number of data values associated with subgroups set to Bypass record or Include on charts and data lists only.

233

Count above Control

Number of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall above the upper control limit.

245

Count above Gate predicted

Number of subgroups predicted to fall above the upper gate limit based on the fitted curve. This value is not reliable with small sample sizes.
If the upper gate limit is not set, this returns "NA".

295

Count above Ind. Gate predicted

Number of values predicted to fall above the upper Ind. Gate limit based on the fitted curve. This value is not reliable with small sample sizes.
If the upper Ind. Gate limit is not set, this returns "NA".

291

Count above Range Gate

Number of values above the range gate.
If the range gate is not set, this returns "NA".

315

Count above Spec

Count of included values above the upper specification limit.
If the upper spec is not set, this returns "NA".

211

Count above Spec predicted

Number of values predicted to fall above the upper spec limit based on the fitted curve. This value is not reliable with small sample sizes.
If the upper spec is not set, this returns "NA".

287

Count above target

Number of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall above the Target X.
If the Target X is not set, this returns "NA".

213

Count Anchor point

Number of subgroups in the retrieved data that are marked as Anchor points.

210

Count below Control

Number of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall below the lower control limit.

246

Count below Gate predicted

Number of subgroups predicted to fall below the lower gate limit based on the fitted curve. This value is not reliable with small sample sizes.
If the lower gate limit is not set, this returns "NA".

296

Count below Ind. Gate predicted

Number of values predicted to fall below the lower Ind. Gate limit based on the fitted curve. This value is not reliable with small sample sizes.
If the lower Ind. Gate limit is not set, this returns "NA".

292

Count below Spec

Count of included values below the lower specification limit.
If the lower spec is not set, this returns "NA".

212

Count below Spec predicted

Number of values predicted to fall below the lower spec limit based on the fitted curve. This value is not reliable with small sample sizes.
If the Lower Spec is not set, this returns "NA".

288

Count below target

Number of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall below the Target X.
If the Target X is not set, this returns "NA".

215

Count data groups

Number of data groups based on the Data grouped by setting.

231

Count excluded subgroups

Number of subgroups that are excluded as outliers or bypassed records (records set to Bypass record or Include on charts and data lists only) .

8

Count excluded values

Number of individual values associated with subgroups that are excluded as outliers or bypassed records (records set to Bypass record or Include on charts and data lists only) .

5

Count in Control

Number of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall inside the upper and lower control limits.

248

Count in Gate predicted

Number of subgroups predicted to fall between the upper and lower gate limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower Gate limit is not set, this returns "NA".

297

Count in Ind. Gate predicted

Number of subgroups predicted to fall between the upper and lower Ind. Gate limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower Ind. Gate limit is not set, this returns "NA".

293

Count in Spec

Count of included values between the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

195

Count in Spec predicted

Number of data values predicted to fall between the upper and lower spec limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

289

Count included subgroups

Number of subgroups that are not excluded as outliers or bypassed records (records set to Bypass record or Include on charts and data lists only) .

7

Count included values

Number of individual values associated with subgroups that are not excluded as outliers or bypassed records (records set to Bypass record or Include on charts and data lists only) .

4

Count incomplete subgroup values

Number of subgroups that contain one or more data values marked as missing.

284

Count out of Control

Number of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall outside the upper and lower control limits.

247

Count out of Gate predicted

Number of subgroups predicted to fall outside the upper and lower gate limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower Gate limit is not set, this returns "NA".

298

Count out of Ind. Gate predicted

Number of subgroups predicted to fall outside the upper and lower Ind. Gate limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower Ind. Gate limit is not set, this returns "NA".

294

Count out of Spec

Count of included values outside the upper and lower specification limits.
If the upper or lower spec is not set, this returns "NA".

194

Count out of Spec predicted

Number of data values predicted to fall outside the upper and lower spec limits based on the fitted curve. This value is not reliable with small sample sizes.
If the upper or lower spec is not set, this returns "NA".

290

Count subgroups not bypassed

Number of subgroups that are set to Include record.

235

Count subgroups with all missing values

Number of subgroups where all of the data values are marked as missing.

283

Count subgroups within 1 sigma

Number of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall within 1 sigma from the mean.
This statistic is based on the upper and lower control limits and is affected by the way the control limits are calculated.

299

Count subgroups within 3 sigma

Number of subgroups that are not bypassed (records set to Bypass record or Include on charts and data lists only) that fall within 2 sigma from the mean.
This statistic is based on the upper and lower control limits and is affected by the way the control limits are calculated.

300

Count values not bypassed

Number of data values associated with subgroups set to Include record.

236

Total subgroups

Number of subgroups in the retrieved data. This number includes excluded subgroups (subgroups that are excluded as outliers or bypassed records).

6

Total values

Number of individual values in the retrieved data. This number includes individual values associated with excluded subgroups (subgroups that are excluded as outliers or bypassed records).

3

Default label

Explanation

Code

A1

Root (where the fitted curve crosses the X-axis) to the left of the mean.
If the distribution is Normal or cannot be determined, this returns "NA".

110

A2

Root (where the fitted curve crosses the X-axis) to the right of the mean.
If the distribution is Normal or cannot be determined., this returns "NA".

111

Chi-squared

The chi-square statistic is calculated by finding the difference between each observed and theoretical frequency for each possible outcome.
If the distribution is not Normal or Uniform, this returns "NA".

139

Chi-squared hypothesis

“Accepted” or “Rejected” based on the Chi-squared value and degrees of freedom in the data set.
If the distribution is not Normal or Uniform, this returns "NA".

138

Distribution

The curve type that best fits the data retrieved. May be one of the following:
  Normal Distribution
  Uniform Distribution
  Multi-Variate Distribution
  Non-Normal Distribution
  Non-Normal (not modeled)
  No Distribution

117

Insufficient non-normal resolution

Returns "Yes" if the non-normal analysis lacks sufficient resolution to make valid statistical calculations.

302

Kurtosis

Kurtosis describes the peakedness of the data.

120

Kurtosis test

Returns “Pass” if the Kurtosis value falls within high and low values defined for the number of data values in the data set.
Returns “Fail” if the Kurtosis value falls outside the high and low values.

116

M1

Power (steepness of the fitted curve) to the left of the mean.
If the distribution is Normal or cannot be determined, this returns "NA".

112

M2

Power (steepness of the fitted curve) to the right of the mean.
If the distribution is Normal or cannot be determined, this returns "NA".

113

Non-normal area

Area underneath the non-normal curve.
If the distribution is Normal or cannot be determined, this returns "NA".

114

Skewness

Skewness describes how non-symmetrical the data are on either side of a vertical axis through the mean.

119

Skewness test

Returns “Pass” if the Skewness value falls below the critical value defined for the number of data values in the data set.
Returns “Fail” if the Skewness value exceeds the critical value.

115

Spread used

For a Normal Distribution, this returns “Calculated”.
For Uniform or Non-Normal Distributions, this returns “Fitted Curve”.
For Multi-Variate or Non-Normal (not modeled) Distributions, this returns “Observed”.
If there is insufficient data, this returns "NA".

118

Default label

Explanation

Code(s)

Trend correlation coefficient

A measure of the interdependence of x and y values on a trend chart.
Values range from −1 to +1, indicating perfect negative correlation at −1, absence of correlation at zero, and perfect positive correlation at +1.

140 and 146

Trend crosses at

Returns the x value where the current trend line is expected to cross the closest limit displayed on the trend chart.

144 and 145

Trend LCLx

Lower control limit for a trend chart that is calculated from the spread of data around the linear regression line that best fits the data.

151 and 155

Trend line

The line that best fits the data on the trend chart
  y = mx + b
where m = slope and b = y-intercept.

141 and 147

Trend slope

The slope of the line that best fits the data on a trend chart.

142 and 148

Trend UCLx

Upper control limit for a trend chart that is calculated from the spread of data around the linear regression line that best fits the data.

150 and 154

Trend Y-intercept

The y value when x = 0 for the line that best fits the data on a trend chart.

143 and 149

Trend Y-intercept LCLx

The value where the lower trend control limit intersects the Y axis.

153 and 157

Trend Y-intercept UCLx

The value where the upper trend control limit intersects the Y axis.

152 and 156

Default label

Explanation

Code

Current date

Returns the current date.

219

Current date/time

Returns the current date and time.

218

Current time

Returns the current time.

220

High date queried

Returns the high date used to query the data.
If no retrieval period is specified, this returns "NA".

221

High date retrieved

Returns the date from the latest date/time in the retrieved data set.

223

High date/time queried

Returns the high date and time used to query the data.
If no retrieval period is specified, this returns "NA".

11

High date/time retrieved

Returns the latest date/time in the retrieved data set.

161

High time queried

Returns the high time used to query the data.
If no retrieval period is specified, this returns "NA".

222

High time retrieved

Returns the time from the latest date/time in the retrieved data set.

224

Low date queried

Returns the low date used to query the data.
If no retrieval period is specified, this returns "NA".

225

Low date retrieved

Returns the date from the earliest date/time in the retrieved data set.

227

Low date/time queried

Returns the low date and time used to query the data.
If no retrieval period is specified, this returns "NA".

12

Low date/time retrieved

Returns the earliest date/time in the retrieved data set.

162

Low time queried

Returns the low time used to query the data.
If no retrieval period is specified, this returns "NA".

226

Low time retrieved

Returns the time from the earliest date/time in the retrieved data set.

228

Default label

Explanation

Code

Add groups for varying subgroup sizes

One of the Varying subgroup size settings.
Allows data to be broken into groups based on subgroup size so that control limits can be calculated.

268

Amount of time to display

Returns the time precision for reported date/time values based on the current Show time to setting.

274

CuSum acceptance limit type

Returns the current Acceptance limit based on setting.

301

CuSum decision interval

Returns the current Decision interval value setting.

203

CuSum start value constant

Returns the current Start value constant setting.

202

Evaluate more data sets as non-normal

Returns “Yes” or “No” based on the current Evaluate more data sets as non-normal setting.

276

EWMA weight

Returns the current EWMA weight setting.

278

Exclude varying subgroup size (all)

One of the Varying subgroup size settings.
Removes all but the most recent subgroup size so that control limits can be calculated.

303

Exclude varying subgroup size (degrees of freedom)

One of the Varying subgroup size settings.
Removes all but the most recent subgroup size so that control limits can be calculated. Based on degrees of freedom remaining in the data set.

272

Exclude varying subgroup size (percent)

One of the Varying subgroup size settings.
Removes all but the most recent subgroup size so that control limits can be calculated. Based on percent of values remaining in the data set.

271

Force distribution

Returns the current Force distribution setting.

275

Limit non-normal slices

Returns “Yes” or “No” based on the current Limit number of slices for non-normal area calculation setting.

197

Moving average span

Returns the current Moving average span setting.

186

Non-symmetrical Control limits

Returns “Yes” or “No” based on the current Calculate non-symmetrical control limits for subgroup size = 1 setting.

267

Run length

Returns the current Run length setting.

9

Runs based on

Returns the current Run value based on setting.

270

Standardize data for varying subgroup size

One of the Varying subgroup size settings.
Standardizes the data so that control limits can be calculated.

273

Trend chart limits

Returns the current Trend chart limits selections.

277

Default label

Explanation

Code

Data entry constant

Returns the Data entry constant setting from the current SPC standard or Short Run process specification.

158

Decimal places

Returns the Decimal places setting from the current SPC standard or Short Run process specification.

1

Description

Returns the Description setting from the current SPC standard or Short Run process specification.

16

DMS Part Number

The DMS Part Number set on the DMS Data Entry tab of the current SPC standard or Short Run process specification.

265

DMS Process

The DMS Process set on the DMS Data Entry tab of the current SPC standard or Short Run process specification.

266

Exponent

Returns the Exponent setting from the current SPC standard or Short Run process specification.

193

Lower Control limit cannot be less than zero

Returns "Yes" or "No" based on the Lower Control limit cannot be less than zero setting from the current SPC standard or Short Run process specification.

200

Meas. system

Returns “English”, “Metric”, or “Not set” based on the Measurement system setting from the current SPC standard or Short Run process specification.

17

Meas. unit

Returns the Measurement unit setting from the current SPC standard or Short Run process specification.

18

Part Number/Process

Returns the name of the SPC standard or Short Run process specification that is associated with this data retrieval.

10

Range chart

Returns “Range”, “Moving Range”, “Sigma” or “Not set” based on the Range chart setting from the current SPC standard or Short Run process specification.

19

Real-time checks

Returns the current list of real-time checks based on the Real-time checks setting from the current SPC standard or Short Run process specification.

279

Scale high range

Returns the Upper Value setting for Range Scaling from the current SPC standard or Short Run process specification.

190

Scale high X-Bar

Returns the Upper Value setting for X-bar and Performance Chart Scaling from the current SPC standard or Short Run process specification.

191

Scale low X-Bar

Returns the Lower Value setting for X-bar and Performance Chart Scaling from the current SPC standard or Short Run process specification.

192

Short Run index

Returns the number of the traceability field (1-6) on which a short run retrieval is based.
If retrieving data by Part Number, this returns the number 0.

281

Short Run method

Returns the Short Run method setting from the current Short Run process specification.
If this data retrieval is based on an SPC standard instead of a Short Run process specification, this returns "NA".

15

Standard flags

Returns the value of the Standard flags database field from the current SPC standard or Short Run process specification:
  0 = nothing set
  If writing data without failures to the monitor tables, add 1
  If writing data with real-time failures to the monitor tables, add 2
  If the Lower Control limit cannot be less than zero, add 4

280

Standard subgroup size

Returns the subgroup size for the current SPC standard.
If this data retrieval is based on a Short Run process specification, or if the current SPC standard cannot be found, this returns 0.

261

Standard variable 1

Returns the Standard variable 1 setting from the current SPC standard or Short Run process specification.

96

Standard variable 2

Returns the Standard variable 2 setting from the current SPC standard or Short Run process specification.

97

Standard variable 3

Returns the Standard variable 3 setting from the current SPC standard or Short Run process specification.

98

Standard variable 4

Returns the Standard variable 4 setting from the current SPC standard or Short Run process specification.

99

Target R

Returns the Target R setting from the current SPC standard or Short Run process specification.

263

Target X

Returns the Target X setting from the current SPC standard or Short Run process specification.

262

Use exponent

Returns “Yes” or “No” based on the Use exponential notation setting from the current SPC standard or Short Run process specification.

282

Default label

Explanation

Code

Lower Gate

Returns the Lower Gate setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

30

Lower Ind. Gate

Returns the Lower Ind. Gate setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

34

Lower range Gate

Returns the Lower range Gate setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

46

Lower reasonable limit

Returns the Lower Reasonable limit setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

38

Lower Spec

Returns the Lower Spec setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

42

Nominal Gate

If Lower Gate and Upper Gate are set in the current SPC standard or Short Run process specification, then Nominal Gate equals the midpoint between Lower Gate and Upper Gate.
Otherwise, this statistic returns "NA".

32

Nominal Ind. Gate

If Lower Ind. Gate and Upper Ind. Gate are set in the current SPC standard or Short Run process specification, then Nominal Ind. Gate equals the midpoint between Lower Ind. Gate and Upper Ind. Gate.
Otherwise, this statistic returns "NA".

36

Nominal range Gate

If Lower range Gate and Upper range Gate are set in the current SPC standard or Short Run process specification, then Nominal range Gate equals the midpoint between Lower range Gate and Upper range Gate.
Otherwise, this statistic returns "NA".

48

Nominal Spec

If Target X is set in the current SPC standard or Short Run process specification, then Nominal Spec equals Target X.
If Target X is not set, but Lower Spec and Upper Spec are set, then Nominal Spec equals the midpoint between Lower Spec and Upper Spec.
Otherwise, this statistic returns "NA".

44

Tolerance Gate

If Lower Gate and Upper Gate are set in the current SPC standard or Short Run process specification, then Tolerance Gate equals the difference between Lower Gate and Upper Gate.
Otherwise, this statistic returns "NA".

33

Tolerance Ind. Gate

If Lower Ind. Gate and Upper Ind. Gate are set in the current SPC standard or Short Run process specification, then Tolerance Ind. Gate equals the difference between Lower Ind. Gate and Upper Ind. Gate.
Otherwise, this statistic returns "NA".

37

Tolerance range Gate

If Lower range Gate and Upper range Gate are set in the current SPC standard or Short Run process specification, then Tolerance range Gate equals the difference between Lower range Gate and Upper range Gate.
Otherwise, this statistic returns "NA".

49

Tolerance Spec

If Lower Spec and Upper Spec are set in the current SPC standard or Short Run process specification, then Tolerance Spec equals the difference between Lower Spec and Upper Spec.
Otherwise, this statistic returns "NA".

45

Upper Gate

Returns the Upper Gate setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

31

Upper Ind. Gate

Returns the Upper Ind. Gate setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

35

Upper range Gate

Returns the Upper range Gate setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

47

Upper reasonable limit

Returns the Upper Reasonable limit setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

39

Upper Spec

Returns the Upper Spec setting from the current SPC standard or Short Run process specification.
If this limit has not been set, this statistic returns "None".

43

Default label

Explanation

Code

Column

Specifies the column used if only one column of data was retrieved.

41

Date period

Returns the current Date period setting.

208

Exclude outliers

Returns the current Statistical outliers setting.

22

Filter contents

Returns the filter contents associated with Filter name.
If no filter is used, this returns "Not set".

14

Filter name

Returns the current Filter name setting.
If no filter is used, this returns "Not set".

13

High date/time queried

Returns the high date and time used to query the data.
If no retrieval period is specified, this returns "NA".

11

Low date/time queried

Returns the low date and time used to query the data.
If no retrieval period is specified, this returns "NA".

12

Maximum count for retrieval

Returns the current Maximum count for retrieval setting.

2

Method used to calculate Control limits

Returns the current Method used to calculate Control limits setting.

21

Non-normal method

Returns “Yes” or “No” based on the current Use the median method to calculate Z values instead of probability method setting.

50

SQL query statement

Returns the SQL query statement used to retrieve the data.

209

Standard deviation method

Returns the current Method for calculating standard deviation setting.

20

Default label

Explanation

Code

269

CuSum acceptance limit

CuSum acceptance limit is calculated as Upper Limit – Target.
If the upper limit or target is not set, this returns "NA".

201

CuSum high sample unit tolerance

Returns the CuSum C2 value.
If the upper limit or target is not set, this returns "NA".

207

CuSum low sample unit tolerance

Returns the CuSum C1 value.
If the upper limit or target is not set, this returns "NA".

206

CuSum start value

Returns the CuSum S value.
If the upper limit or target is not set, this returns "NA".

205

Data grouped by

Returns the type of grouping used to calculate control limits for the data set.
Possible return values include "None", "Manual", "Hour", "Day", "Week", "Month", "Quarter", "Year", "Anchor point", or one of the traceability fields from the data set.

232

Data in control

Reflects whether the entire retrieved data set exhibits a state of statistical control, including subgroups that are excluded as outliers.

If any retrieved data is outside control limits or exhibits control chart signals for runs, trends, or zones, this statistic returns “No”; otherwise, it returns “Yes”.

217

Degrees of freedom

Returns the number of degrees of freedom found in the data set.
 For a subgroup size of one, df = included subgroups – 1.
 For a subgroup size > 1, df = included subgroups * (subgroup size – 1).
 For varying subgroup sizes, df = ∑ df for each subgroup size in the data set.

260

Drill-down conditions

Returns a list of drill-down actions taken up to the current data set. If no drill-down action is taken, it returns "None".

306

External data

Returns "Yes" if data originates from an external source. Otherwise, it returns "No."

307

Kruskal-Wallis 0.01 limit

Chi-squared value for significance of 0.01.
If not Short Run, if no subgroups are included, if the data does not contain a Part Number column, or if only one Part Number exists in the data set, this returns "NA".

174

Kruskal-Wallis 0.10 limit

Chi-squared value for significance of 0.10.
If not Short Run, if no subgroups are included, if the data does not contain a Part Number column, or if only one Part Number exists in the data set, this returns "NA".

173

Kruskal-Wallis test

Returns “Pass”, “Fail” or “Uncertain”.
If not Short Run, if no subgroups are included, if the data does not contain a Part Number column, or if only one Part Number exists in the data set, this returns "NA".

171

Kruskal-Wallis value

Returns Kruskal-Wallis test statistic
  kw = 12/((good)*(good + 1))+ S - 3 * (good + 1)
where
  good = Count included values
  S = Sum (sum of rank * sum of rank / #ind for pn)
If not Short Run, if no subgroups are included, if the data does not contain a Part Number column, or if only one Part Number exists in the data set, this returns "NA".

172

Last Action Taken

Returns the most recent action taken, which may be blank.

311

Last Cause

Returns the most recent cause, which may be blank.

310

Last Event

Returns the most recent event, which may be blank.

 309

Last Note

Returns the note for the most recent retrieval, which may be blank.

312

Last Part Number

Returns the name of the last standard for the most recent record.

313

Last X-Bar

308

Retrieval name

Returns the name of the Dashboard Retrieval if used or "NA" if no Dashboard Retrieval was used.

317

Sum values squared

Returns the sum of the squares of all included values in the data set.

199

Variance

Returns SD (sample) squared.
If SD (sample) cannot be calculated, this returns "NA".

159

Varying subgroup sizes found

Returns “Yes” or “No” based on whether the data contains incomplete subgroups or varying subgroup sizes.

259

Windows login name

Returns the Windows login name for the Windows user currently logged in on the workstation.

316

X-bar chart all inside Control

Returns “Yes” or “No” based on whether all subgroups on the X-bar chart fall inside the control limits.

175