Intraclass Correlation Coefficients in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Intraclass Correlation Coefficients capabilities.
For further information visit UNISTAT User's Guide section 6.2.4. Intraclass Correlation Coefficients.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Intraclass Correlation Coefficient
Number of Columns: 4
Number of Rows: 6
| Due To | Sum of Squares | DoF | Mean Square | F-Stat | Prob |
|---|---|---|---|---|---|
| Between Raters | 97.458 | 3 | 32.486 | 31.866 | 0.1293 |
| Between Subjects | 56.208 | 5 | 11.242 | 11.027 | 0.2246 |
| Within Subjects | 112.750 | 18 | 6.264 | 6.144 | 0.3086 |
| Error | 15.292 | 15 | 1.019 | ||
| Total | 168.958 | 23 | 7.346 |
| Correlation Coefficient | F-Statistic | d.f. Numerator | d.f. Denominator | Right-Tail Probability | 2-Tail Probability | Lower 95% | Upper 95% | |
|---|---|---|---|---|---|---|---|---|
| ICC(1): one-way, single | 0.1657 | 1.7947 | 5 | 18 | 0.1648 | 0.3295 | -0.1329 | 0.7226 |
| ICC(K): one-way, average | 0.4428 | 1.7947 | 5 | 18 | 0.1648 | 0.3295 | -0.8844 | 0.9124 |
| ICC(C,1): two-way, consistency, single | 0.7148 | 11.0272 | 5 | 15 | 0.0001 | 0.0003 | 0.3425 | 0.9459 |
| ICC(C,N): two-way, consistency, average | 0.9093 | 11.0272 | 5 | 15 | 0.0001 | 0.0003 | 0.6757 | 0.9859 |
| ICC(A,1): two-way, agreement, single | 0.2898 | 11.0272 | 5 | 5 | 0.0099 | 0.0198 | 0.0188 | 0.7611 |
| ICC(A,N): two-way, agreement, average | 0.6201 | 11.0272 | 5 | 5 | 0.0099 | 0.0198 | 0.0711 | 0.9272 |