Building a Cross-Tab from Raw Rows with COUNTIFS
This lesson is part of the course
In this lesson
You turn 40 raw survey rows into a plan × purpose cross-tab with one COUNTIFS formula, check that no row went missing, and add a mean per cell with AVERAGEIFS.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Building a Cross-Tab from Raw Rows with COUNTIFS Locked
- Row %, Column % and Total %: Asking the Right Question Locked
- Expected Counts: What Independence Would Look Like Locked
- Chi-Square Test of Independence: by Hand and with CHISQ.TEST Locked
- Cramér's V: How Strong Is the Association? Locked
- 2 × 2 Tables: Risk Difference, Relative Risk and Odds Ratio with a CI Locked
- Small Samples: Expected Counts Below 5, Combining Categories & Fisher's Exact Test Locked
- McNemar's Test for Paired Yes/No Answers + a 100% Stacked Chart Locked