Contingency Table (3 Rows x 3 Columns) in Excel with Unistat
The Unistat statistics add-in extends Excel with Contingency Table (3 Rows x 3 Columns) capabilities.
Further documentation is available at section 6.6.1 of the manual, Contingency Table.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Contingency Table (3 Rows x 3 Columns)
| Frequency | Negative smear | NegSmr-PosCult | NegSmr-NegCult | Row Sum |
|---|
| 1 | 56.0000 | 30.0000 | 13.0000 | 99.0000 |
|---|
| 2 | 46.0000 | 18.0000 | 20.0000 | 84.0000 |
|---|
| 3 | 37.0000 | 18.0000 | 35.0000 | 90.0000 |
|---|
| Column Sum | 139.0000 | 66.0000 | 68.0000 | 273.0000 |
|---|
| Expected | Negative smear | NegSmr-PosCult | NegSmr-NegCult |
|---|
| 1 | 50.4066 | 23.9341 | 24.6593 |
|---|
| 2 | 42.7692 | 20.3077 | 20.9231 |
|---|
| 3 | 45.8242 | 21.7582 | 22.4176 |
|---|
| Chi-Square | Negative smear | NegSmr-PosCult | NegSmr-NegCult |
|---|
| 1 | 0.6207 | 1.5374 | 5.5127 |
|---|
| 2 | 0.2441 | 0.2622 | 0.0407 |
|---|
| 3 | 1.6992 | 0.6492 | 7.0622 |
|---|
| Total % | Negative smear | NegSmr-PosCult | NegSmr-NegCult | Row Sum |
|---|
| 1 | 20.51% | 10.99% | 4.76% | 36.26% |
|---|
| 2 | 16.85% | 6.59% | 7.33% | 30.77% |
|---|
| 3 | 13.55% | 6.59% | 12.82% | 32.97% |
|---|
| Column Sum | 50.92% | 24.18% | 24.91% | 100.00% |
|---|
| Column % | Negative smear | NegSmr-PosCult | NegSmr-NegCult |
|---|
| 1 | 40.29% | 45.45% | 19.12% |
|---|
| 2 | 33.09% | 27.27% | 29.41% |
|---|
| 3 | 26.62% | 27.27% | 51.47% |
|---|
| Row % | Negative smear | NegSmr-PosCult | NegSmr-NegCult |
|---|
| 1 | 56.57% | 30.30% | 13.13% |
|---|
| 2 | 54.76% | 21.43% | 23.81% |
|---|
| 3 | 41.11% | 20.00% | 38.89% |
|---|
| Chi-Square Statistic | 17.6284 |
|---|
| Degrees of Freedom | 4 |
|---|
| Right-Tail Probability | 0.0015 |
|---|
| |
| Phi | 0.2541 |
|---|
| Cramer's V | 0.1797 |
|---|
| Contingency Coefficient | 0.2463 |
|---|
| |
| Somer's delta (col) | 0.1735 |
|---|
| Somer's delta (row) | 0.1618 |
|---|
| |
| Goodman-Kruskal's Gamma | 0.2568 |
|---|
| |
| Kendall's tau b | 0.1676 |
|---|
| Kendall's tau c | 0.1615 |
|---|