Contained in the Region Object This method returns the statistic requested as a variant
Syntax
region.Stats string
The Stats method syntax has these parts:
Part Description
region An object expression that evaluates to a Region object.
String A string expression indicating the statistic desired, as described in settings.
Settings for Variables Control Charts
The settings for string are as follows. Calculations are provided in the User Help:
|
Setting |
Description |
|
"Process Sigma" |
Based on control chart |
|
"Cp" |
Process Capability Index, using process sigma (normal distr.) |
|
"Cpk" |
Process Capability Index, using process sigma (normal distr.) |
|
"Cpm" |
Process Capability Index, using process sigma (normal distr.) |
|
"Pp" |
Process Performance Index, using sample sigma |
|
"Ppk" |
Process Performance Index, using sample sigma |
|
"Ppm" |
Process Performance Index, using sample sigma |
|
“Percent High” |
Predicted % of distribution above the USL, based on the fitted curve |
|
“Percent Low” |
Predicted % of distribution below the LSL, based on the fitted curve |
|
“Zu” |
Location of USL in standard deviations units |
|
“Zl” |
Location of LSL in standard deviations units |
|
"KS Test" |
Kolmogorov-Smirnov Goodness of Fit Test |
|
“CurveFit Type” |
The actual curve fitted [Johnson, Normal, Weibull, Lognormal] |
|
“Fitted Type” |
The specific type of Johnson curve fitted (Su, Sb, Sl, Sn) |
|
“SubGroups Out of Control” |
List of subgroups exceeding the UCL or LCL |
|
“SubGroups Failing RunTest” |
List of subgroups failing each applied Run Test |
|
“SubGroups Dropped from Chart” |
List of subgroups that were excluded from Chart and Stats by user |
|
“SubGroups Dropped from Stats” |
List of subgroups that were automatically (for exceeding UCL or LCL) or manually dropped from Stats |
|
"Sample Sigma" |
Standard Deviation using Sum of Squares (n-1) |
|
"Population Sigma" |
Standard Deviation using Sum of Squares (n) |
|
"Standard Error" |
Standard Error of Mean (using Population Sigma) |
|
"Skewness" |
Third moment about the mean |
|
"Kurtosis" |
Fourth moment about the mean |
|
"Sum" |
The result of adding all data values together |
|
"Mean" or “Average” |
Average |
|
“Median” |
(Run Chart) The midpoint of the sorted data |
|
"Maximum" |
The largest data value |
|
"Minimum" |
The smallest data value |
Settings for Histograms
The settings for string are as follows. Calculations are provided in the User Help:
|
Setting |
Description |
|
"Histogram Cell Count" |
The number of histogram cells (columns) |
|
"Histogram Cell Size" |
The width of the histogram cells |
|
"Histogram Cell Start" |
The starting (smallest possible) value for the cell |
|
"Histogram Cell End" |
The ending (largest possible) value for the cell |
Settings for Attribute Charts
The settings for string are as follows. Calculations are provided in the User Help:
|
Setting |
Description |
|
"Sample Average" |
The average of the subgroup |
|
“Maximum Count” |
The largest observed count (ex: # errors) |
|
“Minimum Count” |
The smallest observed count (ex: # errors) |
|
“Maximum Sample” |
The largest sample size |
|
“Minimum Sample” |
The smallest sample size |
|
“SubGroups Out of Control” |
List of subgroups exceeding the UCL or LCL |
|
“Pareto GrandTotal” |
The summation of the Pareto cell counts (=100% if all categories included) |
Settings for Scatter Diagrams
The settings for string are as follows. Calculations are provided in the User Help:
|
Setting |
Description |
|
"Scatter_x_max" |
The largest observed value for the x-axis variable |
|
"Scatter_y_max" |
The largest observed value for the y-axis variable |
|
"Scatter_x_min" |
The smallest observed value for the x-axis variable |
|
"Scatter_y_min" |
The smallest observed value for the y-axis variable |
|
"Scatter_x_mean" |
The average of the observed values for the x-axis variable |
|
"Scatter_y_mean" |
The average of the observed values for the y-axis variable |
|
"Scatter_x_sigma" |
The standard deviation of the observed values for the x-axis variable |
|
"Scatter_y_sigma" |
The standard deviation of the observed values for the y-axis variable |
|
"Scatter_x_variance" |
The variance of the observed values for the x-axis variable |
|
"Scatter_y_variance" |
The variance of the observed values for the y-axis variable |
|
"Scatter_x_skewness" |
The third moment about the mean of the observed values for the x-axis variable |
|
"Scatter_y_skewness" |
The third moment about the mean of the observed values for the y-axis variable |
|
"Scatter_x_kurtosis" |
The fourth moment about the mean of the observed values for the x-axis variable |
|
"Scatter_x_kurtosis" |
The fourth moment about the mean of the observed values for the y-axis variable |
|
"Scatter_yintercept" |
The y-intercept for the regression equation |
|
"Scatter_slope" |
The slope for the regression equation |
|
"Scatter_r" |
The correlation coefficient for the regression equation |
|
"Scatter_fnvar" |
The amount of variation explained by the regression equation (=100% * ((Scatter_r)^2)) |
|
"Scatter_ssr" |
The Sum of Squares (regression) for the regression equation |
|
"Scatter_sse" |
The Sum of Squares (error) for the regression equation |
|
"Scatter_msr" |
The Mean Square (regression) for the regression equation |
|
"Scatter_mse" |
The Mean Square (error) for the regression equation |
|
"Scatter_f" |
The F-ratio for the regression equation |
|
"Scatter_probf" |
The probability of F for the regression equation |
Settings for Box-Whisker Charts
The settings for string are as follows. Calculations are provided in the User Help:
|
Setting |
Description |
|
"Box Average" |
The average value |
|
"Box Max" |
The upper limit on the box |
|
"Box Min" |
The lower limit on the box |
|
"Whisker Max" |
The upper limit defined by the whiskers |
|
"Whisker Min" |
The lower limit defined by the whiskers |
Return Value
Returns a variant. The string contains the statistic or error message, and the double contains the numeric result, if any.