Golf Stats & Handicap Math: Score Differentials, Net Scores, Club Gapping & Strokes Gained

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 Priya's 18-hole scorecard into scores to par, the back nine against par, her fairways-hit rate and the putts she needs on greens hit in regulation.
• Turn 20 scores from three courses into score differentials, find Priya's best round and work backwards to the score she needs for a target differential.
• Find the 8th-lowest of 20 differentials, average the best eight into a simplified handicap index and see how one new round moves the index when the oldest round drops out.
• Convert two handicap indexes into course handicaps for one set of tees, give out the strokes hole by hole with INT, MOD and the stroke index, and highlight the holes where Priya gets two strokes.
• Subtract Priya's strokes from her gross scores, score every hole in points with MAX, total the points straight from the data and compare her net score with par.
• Average five carries per club, measure the gap to the next club, compare how spread out the driver is with STDEV.S and flag the gaps that are too small to be useful.
• Look up the expected strokes before every shot in a fictional baseline, calculate the strokes gained per shot, check that the total equals expectation minus score, and name the part of Priya's game that cost the most.
• Build Priya's season dashboard: average score per course with AVERAGEIFS, the trend of her differentials, a trend chart and a formula that names her practice priority from the strokes-gained summary.