Tutorvo
Menu
Courses Guides Pricing Log in Sign up

League table from match results: points, goal difference & tiebreaks

Lesson 1 of 816 minLab

This lesson is part of the course

In this lesson

You turn 28 Harbor League results into a full league table: result letters, wins with COUNTIFS, goals with SUMIFS, and a rank that breaks ties on goal difference.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Buy course — $9.99 Log in

Lessons in this course

  1. League table from match results: points, goal difference & tiebreaksLab16 min Locked
  2. Per-90 and per-game stats: fair comparisonsLab13 min Locked
  3. Shooting efficiency: eFG% and true shooting % (basketball)Lab14 min Locked
  4. Expected goals (xG): sums, over- and under-performanceLab15 min Locked
  5. Elo ratings: expected score, K-factor & rating updateLab15 min Locked
  6. Pythagorean expectation: win % from points for and againstLab14 min Locked
  7. Player comparison: z-scores & a weighted composite scoreLab16 min Locked
  8. Home advantage & match prediction with Poisson goalsLab18 min Locked