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