Calculating Weighted Averaged in Spreadsheets: SUMPRODUCT Command

This site shows students how the average command fails in excel when calculating the weighted mean. It tells students, instead, to use sumproduct.

This description of a site outside SERC has not been vetted by SERC staff and may be incomplete or incorrect. If you have information we can use to flesh out or correct this record let us know.

Subject: Mathematics
Resource Type: Activities:Classroom Activity
Special Interest: Quantitative
Grade Level: College Lower (13-14), College Upper (15-16), Middle (6-8), High School (9-12), Intermediate (3-5)
Quantitative Skills: Probability and Statistics:Describing Data Distribution