Quantcast

Weighted Average

vCalc Reviewed
Last modified by
on
Jul 24, 2020, 6:28:07 PM
Created by
on
Aug 7, 2017, 7:21:51 PM
`WA = ( "S1" * "A1" + "S2" * "A2" )/( "S1" + "S2" )`
`(S1)"Sample size of group 1"`
`(A1)"The average of group 1"`
`(S2)"Sample size of group 2"`
`(A2)"The average of group 2"`
Tags
UUID
aa922b59-7ba5-11e7-9770-bc764e2038f2

The Weighted Average calculator computes the weighted average from two groups based on their averages (means) and group sizes.

INSTRUCTIONS: Enter the following:

  • (S1) This is the size of group 1.
  • (A1) This is average (mean) of group 1.
  • (S2) This is the size of group 2.
  • (A2) This is the average of group 2. 

Weighted Average: The calculator returns the weighted average of the two groups. 

Related Calcs:

The Math

If you consider the following two groups:

  • Group 1:  23,15,87,15,67,43,28,22,17,19   Group Size: 10  Mean: 33.6
  • Group 2:  28,67,91,15,4                             Group Size:   5  Mean: 41.0

If you take the average of the two means:

                `(33.6 + 41.0)/2 = 37.3` you do not take into consideration that Group 1 had twice as many observations.

To compute the weighted average:

                `WA = (10 * 33.6 + 5 * 41)/(10 + 5) = 36.066

This takes into account the larger size of Group 1.


  • Comments
  • Attachments
  • Stats
No comments
This site uses cookies to give you the best, most relevant experience. By continuing to browse the site you are agreeing to our use of cookies.