UNISTAT - the ultimate
Excel statistics add-in
Confidence Intervals in Excel with Unistat
The Unistat statistics add-in extends Excel with Confidence Intervals capabilities.
Further documentation is available at section 5.1.2 of the manual, Confidence Intervals.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Confidence Intervals
Data variable: Room Averages
Number of Cases: 168
| 95% Confidence Interval | Value | Lower | Upper |
|---|---|---|---|
| Mean (Z-Score) | 722.2976 | 700.7258 | 743.8695 |
| Mean (t-Score) | 722.2976 | 700.5684 | 744.0268 |
| Variance | 20351.0007 | 16604.9636 | 25532.2875 |
| Normal Approximation | Value | Lower | Upper |
|---|---|---|---|
| Median | 709.5000 | 679.0000 | 735.0000 |
| 25% Quantile | 612.0000 | 592.0000 | 645.0000 |
| 75% Quantile | 805.5000 | 773.0000 | 833.0000 |
| 96.30732% Exact Conservative Interval | Value | Lower | Upper |
|---|---|---|---|
| Median | 709.5000 | 679.0000 | 735.0000 |
| 25% Quantile | 612.0000 | 592.0000 | 645.0000 |
| 75% Quantile | 805.5000 | 773.0000 | 833.0000 |