Combination of Assays in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Combination of Assays capabilities.
For further information visit UNISTAT User's Guide section 10.5. Combination of Assays.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Combination of Assays
Valid Number of Cases: 6, 0 Omitted
Data
| Assay | Potency | Lower 95% | Upper 95% | DoF |
|---|---|---|---|---|
| 1 | 18367.0000 | 17755.0000 | 19002.0000 | 20 |
| 2 | 18003.0000 | 17415.0000 | 18610.0000 | 20 |
| 3 | 18064.0000 | 17319.0000 | 18838.0000 | 20 |
| 4 | 17832.0000 | 17253.0000 | 18429.0000 | 20 |
| 5 | 18635.0000 | 17959.0000 | 19339.0000 | 20 |
| 6 | 18269.0000 | 17722.0000 | 18834.0000 | 20 |
Homogeneity Tests
| Chi-Square | DoF | Probability | |
|---|---|---|---|
| Mean | 4.419 | 5 | 0.4907 |
| Variance | 2.598 | 5 | 0.7616 |
Combined Potency EP
| Geometric Mean | Potency | Lower 95% | Upper 95% |
|---|---|---|---|
| Weighted EP | 18186.8537 | 17946.0755 | 18430.8624 |
| Semi-weighted EP | 18187.7481 | 17926.1824 | 18453.1304 |
| Unweighted | 18193.1071 | 17894.1048 | 18497.1056 |
Combined Potency USP
| Geometric Mean | Potency | Lower 95% | Upper 95% |
|---|---|---|---|
| Weighted USP | 18186.8537 | 17923.4957 | 18454.0813 |
| Semi-weighted USP | 18190.0887 | 17855.8964 | 18530.5359 |
| Unweighted | 18193.1071 | 17894.1048 | 18497.1056 |
| Standard Deviation (Log base e) | 0.0158 |
|---|---|
| Unweighted Mean (Log base e) | 9.8088 |
| %RSD | 0.16% |
Combination of Assays
Valid Number of Cases: 6, 0 Omitted
Data
| Assay | Potency |
|---|---|
| 1 | 18367.0000 |
| 2 | 18003.0000 |
| 3 | 18064.0000 |
| 4 | 17832.0000 |
| 5 | 18635.0000 |
| 6 | 18269.0000 |
Combined Potency
| Potency | Lower 95% | Upper 95% | |
|---|---|---|---|
| Geometric Mean | 18193.1071 | 17894.1048 | 18497.1056 |
| Standard Deviation (Log base e) | 0.0158 |
|---|---|
| Unweighted Mean (Log base e) | 9.8088 |
| %RSD | 0.16% |
