Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Data & Analytics Intermediate

Cross-Tabs & Chi-Square: Analysing Categorical Data in Excel

Build cross-tabs from raw rows with COUNTIFS, read row and column percentages, compute expected counts, chi-square and Cramér's V by hand, and handle 2 × 2 tables, small samples and paired answers, in a live spreadsheet that checks every cell.

8 lessons 8 labs 2 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • 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.
  • Turn the full 600-rider cross-tab into row, column and total percentages, compare plans in percentage points, and chart the row percentages.
  • Build the table of expected counts under independence (row total × column total ÷ grand total), measure how far each observed cell is from it with standardised residuals, and check the minimum expected count.
  • Compute the chi-square statistic cell by cell, turn it into a p-value with CHISQ.DIST.RT, and confirm it with CHISQ.TEST.
  • Turn chi-square into Cramér's V for two tables, then see that ten times more riders makes the p-value collapse while the effect size stays exactly the same.
  • Read a 2 × 2 table of a reminder experiment, calculate the risk difference, the relative risk and the odds ratio, and put a 95% confidence interval around the odds ratio on the log scale.
  • Check the expected-count rule on a sparse table, fix it by combining two categories, and calculate a one-sided Fisher exact p-value for a tiny 2 × 2 pilot with COMBIN.
  • Test whether the same riders changed their answer after a campaign with McNemar's test (chi-square and exact binomial) and show the before/after shares in a 100% stacked column chart.

About this course

Survey answers, customer types and yes-or-no outcomes all produce categorical data, and the cross-tab is the main tool for analysing it. In this course you build cross-tabs from raw rows and choose between row, column and total percentages to answer the right question. You calculate expected counts under independence and run a chi-square test by hand and with a built-in function, then measure strength of association with Cramér's V. Two-by-two labs calculate risk difference, relative risk and odds ratio with a confidence interval. You handle small samples by combining categories or using Fisher's exact test, and analyse paired answers with McNemar's test. For researchers, analysts and students.

Curriculum

Course content

8 lessons · 8 labs · 2 h · final exam

  1. Building a Cross-Tab from Raw Rows with COUNTIFSLab14 min4 checked tasks
    Unlocked when you buy the course
  2. Row %, Column % and Total %: Asking the Right QuestionLab14 min5 checked tasks
    Unlocked when you buy the course
  3. Expected Counts: What Independence Would Look LikeLab14 min4 checked tasks
    Unlocked when you buy the course
  4. Chi-Square Test of Independence: by Hand and with CHISQ.TESTLab16 min4 checked tasks
    Unlocked when you buy the course
  5. Cramér's V: How Strong Is the Association?Lab14 min4 checked tasks
    Unlocked when you buy the course
  6. 2 × 2 Tables: Risk Difference, Relative Risk and Odds Ratio with a CILab16 min4 checked tasks
    Unlocked when you buy the course
  7. Small Samples: Expected Counts Below 5, Combining Categories & Fisher's Exact TestLab18 min4 checked tasks
    Unlocked when you buy the course
  8. McNemar's Test for Paired Yes/No Answers + a 100% Stacked ChartLab16 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Data & Analytics courses →
$9.99one-time payment
Buy course