Symmetric Measures: what it means and how to read it
In the report: Symmetric Measures — With details = TRUE: the strength of the relation, Phi and Cramér's V, as in SPSS CROSSTABS /STATISTICS=PHI. Follows the Chi-Square Tests table.
In plain words
A shop owner learned from the Chi-Square Tests block that the age group of customers and the drink they pick go together. But those tests do not say how strongly. Right after them, with details switched on, comes Symmetric Measures. It holds Phi and Cramér's V, which run from 0, no link at all, to 1, a perfect link. Hers came out 0.25. Now she can say: the link exists, but it is fairly weak, and knowing a customer's age tells her only a little about which drink the customer picks.
Example
The cell with Symmetric Measures is selected in each report; point at a label to see its note.
- — the sample data (50 rows) the examples use
- — with the Chi-Square Tests and Symmetric Measures tables at the end
=STATS_CHI2(Data!A1:T51, "gender", "group", TRUE)
Where you see it
STATS_CHI2— Pearson chi-square test for association between two categorical columns.
Related values
- N of Valid Cases — The rows the test is computed on: both answers present and applicable.
- Observed counts — The crosstab of the counts the test uses — the same table as STATS_CROSSTABS.
- Expected counts — The counts expected if the two variables were unrelated: row total × column total / N, for the non-empty categories. The test compares them with the observed counts.
- Percentage — The share of the rows in the range, empty answers included; rows with "." (not applicable) are left out.
- Valid percentage — The share among the valid answers: missing and not applicable are left out, and _other too when the labels are closed.
Get it in your sheet
One formula in a cell gives the whole report, Symmetric Measures included. ALS Stats is a free add-on for Google Sheets™.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)