Procedure: Cross-Tabulation
UNISTAT statistical package extends Excel with Cross-Tabulation support.
Sample output
Here we provide annotated example report output from the UNISTAT Excel add-in for data analysis.
Cross-Tabulation
Sequence Rows, Treatment Columns
Subsample selected by: Period = 1
| Frequency | A | B | Row Sum |
|---|
| AB | 6.0000 | 0.0000 | 6.0000 |
|---|
| BA | 0.0000 | 6.0000 | 6.0000 |
|---|
| Column Sum | 6.0000 | 6.0000 | 12.0000 |
|---|
| Expected | A | B |
|---|
| AB | 3.0000 | 3.0000 |
|---|
| BA | 3.0000 | 3.0000 |
|---|
| Chi-Square | A | B |
|---|
| AB | 3.0000 | 3.0000 |
|---|
| BA | 3.0000 | 3.0000 |
|---|
| Total % | A | B | Row Sum |
|---|
| AB | 50.00% | 0.00% | 50.00% |
|---|
| BA | 0.00% | 50.00% | 50.00% |
|---|
| Column Sum | 50.00% | 50.00% | 100.00% |
|---|
| Column % | A | B |
|---|
| AB | 100.00% | 0.00% |
|---|
| BA | 0.00% | 100.00% |
|---|
| Row % | A | B |
|---|
| AB | 100.00% | 0.00% |
|---|
| BA | 0.00% | 100.00% |
|---|
| Chi-Square Statistic | 12.0000 |
|---|
| Degrees of Freedom | 1 |
|---|
| Right-Tail Probability | 0.0005 |
|---|
| |
| Results with Yates' Correction |
|---|
| Chi-Square Statistic | 12.3333 |
|---|
| Degrees of Freedom | 1 |
|---|
| Right-Tail Probability | 0.0004 |
|---|
| |
| Phi | 1.0000 |
|---|
| Cramer's V | 1.0000 |
|---|
| Contingency Coefficient | 0.7071 |
|---|
| |
| Somer's delta (col) | 1.0000 |
|---|
| Somer's delta (row) | 1.0000 |
|---|
| |
| Goodman-Kruskal's Gamma | 1.0000 |
|---|
| |
| Kendall's tau b | 1.0000 |
|---|
| Kendall's tau c | 1.0000 |
|---|
| |
| P(observed) | 1.0000 |
|---|
| P(expected) | 0.5000 |
|---|
| Kappa | 1.0000 |
|---|
| Standard Deviation | 0.0000 |
|---|
| 95% Confidence Interval | 1.0000 <> 1.0000 |
|---|