Weighted Average — Solution & ExplanationProblems / Weighted Average / EditorialApproach

For each student, compute the numerator: SUM(grade * credits) — each grade is scaled by its credit weight.

Compute the denominator: SUM(credits) — the total credits.

Divide and round to 2 decimal places.

Key ConceptA simple AVG() treats all values equally. A weighted average gives more influence to values with higher weights. This pattern appears in GPA calculations, portfolio returns, and blended metrics.Formulaweighted_avg = Σ(grade_i × credits_i) / Σ(credits_i)Hints

A weighted average is SUM(value * weight) / SUM(weight).

You can multiply columns inside SUM(): SUM(grade * credits).

Solve Weighted Average yourself →