Confidence Intervals in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Confidence Intervals capabilities.
For further information visit UNISTAT User's Guide section 5.1.2. Confidence Intervals.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Confidence Intervals
Data variable: BUN
Number of Cases: 48
| Value | Lower 95% | Upper 95% | |
|---|---|---|---|
| * Mean | 33.9167 | 23.4904 | 44.3430 |
| ** Median | 21.0000 | 18.0000 | 28.0000 |
| * Geometric Mean | 24.5681 | 19.8113 | 30.4670 |
| * Harmonic Mean | 19.6621 | 16.6516 | 24.0014 |
| Variance | 1289.3121 | 893.4988 | 2022.8759 |
| Standard Deviation | 35.9070 | 29.8915 | 44.9764 |
* t-interval
** Quantile Method: Simple Average, Interval Method: Normal Approximation
Confidence Intervals
Data variable: BUN
Subsample selected by: Gender = Male
Number of Cases: 29
| Value | Lower 95% | Upper 95% | |
|---|---|---|---|
| * Mean | 34.2414 | 22.8591 | 45.6237 |
| ** Median | 23.0000 | 17.0000 | 40.0000 |
| * Geometric Mean | 26.3676 | 20.4902 | 33.9309 |
| * Harmonic Mean | 21.5768 | 17.7698 | 27.4599 |
| Variance | 978.0468 | 615.9429 | 1788.9705 |
| Standard Deviation | 31.2737 | 24.8182 | 42.2962 |
* Z-interval
** Quantile Method: Simple Average, Interval Method: Normal Approximation
Data variable: BUN
Subsample selected by: Gender = Female
Number of Cases: 19
| Value | Lower 95% | Upper 95% | |
|---|---|---|---|
| * Mean | 33.4211 | 14.1087 | 52.7334 |
| ** Median | 21.0000 | 12.0000 | 27.0000 |
| * Geometric Mean | 22.0553 | 15.2769 | 31.8414 |
| * Harmonic Mean | 17.3167 | 13.4342 | 24.3555 |
| Variance | 1844.7018 | 1053.2333 | 4034.2189 |
| Standard Deviation | 42.9500 | 32.4536 | 63.5155 |
* Z-interval
** Quantile Method: Simple Average, Interval Method: Normal Approximation