Sample Statistics in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Sample Statistics capabilities.
For further information visit UNISTAT User's Guide section 5.1.4. Sample Statistics.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Sample Statistics
Quantile Method: Simple Average
| cm | mm | min | ml | |
|---|---|---|---|---|
| Size | 33.0000 | 33.0000 | 33.0000 | 33.0000 |
| Missing | 0.0000 | 0.0000 | 0.0000 | 0.0000 |
| Mean | 8.8848 | 5.8818 | 2.5424 | 2.4742 |
| Geometric Mean | 8.7677 | 5.8692 | 2.0753 | 2.3862 |
| Harmonic Mean | 8.6545 | 5.8567 | 1.2181 | 2.3021 |
| Median | 8.8000 | 5.9000 | 2.4000 | 2.4100 |
| Lower Quartile | 7.6000 | 5.5000 | 1.9000 | 1.8300 |
| Upper Quartile | 9.9000 | 6.2000 | 3.4000 | 2.8600 |
| Interquartile Range | 2.3000 | 0.7000 | 1.5000 | 1.0300 |
| Minimum | 6.9000 | 5.2000 | 0.2000 | 1.5000 |
| Maximum | 12.1000 | 6.8000 | 4.4000 | 4.0600 |
| Range | 5.2000 | 1.6000 | 4.2000 | 2.5600 |
| Sum | 293.2000 | 194.1000 | 83.9000 | 81.6500 |
| Sum of Squares | 2675.6600 | 1146.5700 | 258.2700 | 216.7691 |
| Root Mean Square | 9.0045 | 5.8945 | 2.7976 | 2.5630 |
| Unbiased Variance | 2.2070 | 0.1534 | 1.4050 | 0.4609 |
| Unbiased Standard Deviation | 1.4856 | 0.3917 | 1.1853 | 0.6789 |
| Standard Error of Mean | 0.2586 | 0.0682 | 0.2063 | 0.1182 |
| Coefficient of Variation | 0.1647 | 0.0656 | 0.4591 | 0.2702 |
| Variance | 2.1401 | 0.1488 | 1.3624 | 0.4469 |
| Standard Deviation | 1.4629 | 0.3857 | 1.1672 | 0.6685 |
| Mean Deviation | 1.2268 | 0.3278 | 0.9484 | 0.5592 |
| 3rd Moment About Mean | 1.3593 | 0.0101 | -0.2169 | 0.1339 |
| 4th Moment About Mean | 10.1632 | 0.0519 | 4.6793 | 0.4572 |
| Unbiased 3rd Moment | 1.4922 | 0.0111 | -0.2381 | 0.1469 |
| Moment Coefficient of Skewness | 0.4342 | 0.1764 | -0.1364 | 0.4481 |
| Moment Coefficient of Kurtosis | 2.2191 | 2.3451 | 2.5209 | 2.2895 |
| Pearson’s Skewness Coefficient | 0.1740 | -0.1414 | 0.3661 | 0.2883 |
Sample Statistics
Surface Area: contains data, Blemishes contains frequencies
| Surface Area | |
|---|---|
| Size | 20.0000 |
| Missing | 0.0000 |
| Total Frequency | 94.0000 |
| Mean | 0.8462 |
| Geometric Mean | 0.8265 |
| Harmonic Mean | 0.8070 |
| Median | 0.8400 |
| Lower Quartile | 0.6200 |
| Upper Quartile | 1.0800 |
| Interquartile Range | 0.4600 |
| Minimum | 0.6200 |
| Maximum | 1.0800 |
| Range | 0.4600 |
| Sum | 79.5400 |
| Sum of Squares | 70.3748 |
| Root Mean Square | 0.8653 |
| Unbiased Variance | 0.0330 |
| Unbiased Standard Deviation | 0.1817 |
| Standard Error of Mean | 0.0187 |
| Coefficient of Variation | 0.2136 |
| Variance | 0.0327 |
| Standard Deviation | 0.1807 |
| Mean Deviation | 0.1443 |
| 3rd Moment About Mean | 0.0004 |
| 4th Moment About Mean | 0.0017 |
| Unbiased 3rd Moment | 0.0004 |
| Moment Coefficient of Skewness | 0.0635 |
| Moment Coefficient of Kurtosis | 1.6210 |
| Pearson’s Skewness Coefficient | 0.1024 |