Table of Means in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Table of Means capabilities.
For further information visit UNISTAT User's Guide section 7.4.1. Table of Means.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Table of Means
For AUC
| Cases | Mean | Standard Deviation | Standard Error | Lower 95% | Upper 95% | |
|---|---|---|---|---|---|---|
| whole sample | 24 | 188.2917 | 58.3956 | 11.9199 | 163.6333 | 212.9500 |
| Period = 1 | 6 | 242.0000 | 57.6090 | 23.5188 | 181.5430 | 302.4570 |
| 2 | 6 | 189.0000 | 49.8277 | 20.3421 | 136.7090 | 241.2910 |
| 3 | 6 | 182.0000 | 39.1969 | 16.0021 | 140.8653 | 223.1347 |
| 4 | 6 | 140.1667 | 45.3802 | 18.5264 | 92.5430 | 187.7903 |
| Sequence = AB | 12 | 202.1667 | 72.7559 | 21.0028 | 155.9396 | 248.3938 |
| BA | 12 | 174.4167 | 37.6381 | 10.8652 | 150.5024 | 198.3309 |
| Treatment = A | 12 | 209.4167 | 63.3353 | 18.2833 | 169.1752 | 249.6581 |
| B | 12 | 167.1667 | 46.3148 | 13.3699 | 137.7395 | 196.5938 |
| Period x Sequence = 1 x AB | 4 | 266.0000 | 52.6941 | 26.3470 | 182.1521 | 349.8479 |
| 1 x BA | 2 | 194.0000 | 36.7696 | 26.0000 | -65.9998 | 453.9998 |
| 2 x AB | 4 | 176.5000 | 58.1578 | 29.0789 | 83.9581 | 269.0419 |
| 2 x BA | 2 | 214.0000 | 19.7990 | 14.0000 | 74.0001 | 353.9999 |
| 3 x AB | 2 | 209.0000 | 57.9828 | 41.0000 | -200.9996 | 618.9996 |
| 3 x BA | 4 | 168.5000 | 26.6646 | 13.3323 | 126.0708 | 210.9292 |
| 4 x AB | 2 | 119.0000 | 59.3970 | 42.0000 | -300.9996 | 538.9996 |
| 4 x BA | 4 | 150.7500 | 42.5235 | 21.2618 | 83.0857 | 218.4143 |
| Period x Treatment = 1 x A | 4 | 266.0000 | 52.6941 | 26.3470 | 182.1521 | 349.8479 |
| 1 x B | 2 | 194.0000 | 36.7696 | 26.0000 | -65.9998 | 453.9998 |
| 2 x A | 2 | 214.0000 | 19.7990 | 14.0000 | 74.0001 | 353.9999 |
| 2 x B | 4 | 176.5000 | 58.1578 | 29.0789 | 83.9581 | 269.0419 |
| 3 x A | 2 | 209.0000 | 57.9828 | 41.0000 | -200.9996 | 618.9996 |
| 3 x B | 4 | 168.5000 | 26.6646 | 13.3323 | 126.0708 | 210.9292 |
| 4 x A | 4 | 150.7500 | 42.5235 | 21.2618 | 83.0857 | 218.4143 |
| 4 x B | 2 | 119.0000 | 59.3970 | 42.0000 | -300.9996 | 538.9996 |
| Sequence x Treatment = AB x A | 6 | 247.0000 | 56.6110 | 23.1113 | 187.5905 | 306.4095 |
| AB x B | 6 | 157.3333 | 60.1387 | 24.5515 | 94.2216 | 220.4450 |
| BA x A | 6 | 171.8333 | 47.2246 | 19.2794 | 122.2741 | 221.3925 |
| BA x B | 6 | 177.0000 | 29.5025 | 12.0444 | 146.0390 | 207.9610 |
| Period x Sequence x Treatment = 1 x AB x A | 4 | 266.0000 | 52.6941 | 26.3470 | 182.1521 | 349.8479 |
| 1 x AB x B | 0 | * | * | * | * | * |
| 1 x BA x A | 0 | * | * | * | * | * |
| 1 x BA x B | 2 | 194.0000 | 36.7696 | 26.0000 | -65.9998 | 453.9998 |
| 2 x AB x A | 0 | * | * | * | * | * |
| 2 x AB x B | 4 | 176.5000 | 58.1578 | 29.0789 | 83.9581 | 269.0419 |
| 2 x BA x A | 2 | 214.0000 | 19.7990 | 14.0000 | 74.0001 | 353.9999 |
| 2 x BA x B | 0 | * | * | * | * | * |
| 3 x AB x A | 2 | 209.0000 | 57.9828 | 41.0000 | -200.9996 | 618.9996 |
| 3 x AB x B | 0 | * | * | * | * | * |
| 3 x BA x A | 0 | * | * | * | * | * |
| 3 x BA x B | 4 | 168.5000 | 26.6646 | 13.3323 | 126.0708 | 210.9292 |
| 4 x AB x A | 0 | * | * | * | * | * |
| 4 x AB x B | 2 | 119.0000 | 59.3970 | 42.0000 | -300.9996 | 538.9996 |
| 4 x BA x A | 4 | 150.7500 | 42.5235 | 21.2618 | 83.0857 | 218.4143 |
| 4 x BA x B | 0 | * | * | * | * | * |