# Calculating Statistics

1. On the Home view, select the Reports Tab. Then, on the left, select Statistics.

2. In the SPC Configuration window, enter the parameters to collect results stored in the controller (Number of Subgroups, Subgroup Size, and Frequency).

3. Select the Plus icon at the upper-right corner of the GUI.
   The SPC Variable window shows the new variable.
   Configure the new SPC Variable.

4. In the SPC Variable window, select Calculate.
   Data is collected from the historical results stored in the controller that are aligned with the criteria set in the SPC Configuration window and SPC Variable window. The values of interest are collected into subgroups of the size set in the SPC Configuration window. The collected tightening results on the controller are used for statistics calculations.

It is not possible to calculate statistics for results from deleted tightening programs or Virtual Stations, unless the results are still stored on the controller.

Only 1 user at a time can calculate statistics.

## Statistics Formulas

Data in a subgroup is calculated as:

- Average:

- Range = R = max (Xi) - min (Xi), where i=1...n

- Standard deviation for a subgroup:

- Total overall of the standard deviation:

  Where N = total number of observations.

When specified number of subgroups to use for calculations has been collected, the SPC function starts calculations to determine the statistical stability.
Calculations are performed through the following steps: (m = number of subgroups)

- Calculation of Average of Average values:

- Calculation of Average of Range:

- Calculation of Average of Standard deviation:

- Calculation of the process capabilities Cp and Cpk with respect to Sigma:

  Where:

  - is the overall arithmetic average of the observed characteristic values.

  - UTL is the Upper Tolerance Limit.

  - LTL is the Lower Tolerance Limit.

  - The sigma estimation is the mean square standard deviation within the subgroups:

- Calculation of the process capabilities Cp and Cpk with respect to Range:

  Where for a normal distribution su = sl = 3.

Calculations for control limits if, in the SPC Configuration window, the Auto calculate switch is set to Yes:

- X-bar R (Mean)

- X-bar R (Range)

- X-bar S (Mean)

- X-bar S (Sigma)

A2, A3, D3, D4, B3, and B4 are constants (for more information, see the "SPC Calculation Constants" paragraph).

## SPC Calculations Constants

Subgroup Size | Divisors for estimate of standard dev. | Factors for Control Limits
--- | --- | ---
|  | Xbar R | Xbar S
A2 | D3 | D4 | A3 | B3 | B4
n | d2
2 | 1.128 | 1.880 | - | 3.267 | 2.659 | - | 3.267
3 | 1.693 | 1.023 | - | 2.574 | 1.954 | - | 2.568
4 | 2.059 | 0.729 | - | 2.282 | 1.628 | - | 2.266
5 | 2.326 | 0.577 | - | 2.114 | 1.427 | - | 2.089
6 | 2.534 | 0.483 | - | 2.004 | 1.287 | 0.030 | 1.970
7 | 2.704 | 0.419 | 0.076 | 1.924 | 1.182 | 0.118 | 1.882
8 | 2.847 | 0.373 | 0.136 | 1.864 | 1.099 | 0.185 | 1.815
9 | 2.970 | 0.337 | 0.184 | 1.816 | 1.032 | 0.239 | 1.761
10 | 3.078 | 0.308 | 0.223 | 1.777 | 0.975 | 0.284 | 1.716
11 | 3.173 | 0.285 | 0.256 | 1.744 | 0.927 | 0.321 | 1.679
12 | 3.258 | 0.266 | 0.283 | 1.717 | 0.886 | 0.354 | 1.646
13 | 3.336 | 0.249 | 0.307 | 1.693 | 0.850 | 0.382 | 1.618
14 | 3.407 | 0.235 | 0.328 | 1.672 | 0.817 | 0.406 | 1.594
15 | 3.472 | 0.223 | 0.347 | 1.653 | 0.789 | 0.428 | 1.572
16 | 3.532 | 0.212 | 0.363 | 1.637 | 0.763 | 0.448 | 1.552
17 | 3.588 | 0.203 | 0.378 | 1.622 | 0.739 | 0.466 | 1.534
18 | 3.640 | 0.194 | 0.391 | 1.608 | 0.718 | 0.482 | 1.518
19 | 3.689 | 0.187 | 0.403 | 1.597 | 0.698 | 0.497 | 1.503
20 | 3.735 | 0.180 | 0.415 | 1.585 | 0.680 | 0.510 | 1.490
21 | 3.778 | 0.173 | 0.425 | 1.575 | 0.663 | 0.523 | 1.477
22 | 3.819 | 0.167 | 0.434 | 1.566 | 0.647 | 0.534 | 1.466
23 | 3.858 | 0.162 | 0.443 | 1.557 | 0.633 | 0.545 | 1.455
24 | 3.895 | 0.157 | 0.451 | 1.548 | 0.619 | 0.555 | 1.445
25 | 3.931 | 0.153 | 0.459 | 1.541 | 0.606 | 0.565 | 1.435

Relevant Information

- Configuring SPC Parameters
- Configuring SPC Variables