Calculate weighted average for 1 column

  • Thread starter Thread starter Jul2010
  • Start date Start date
J

Jul2010

Hi
I 'm looking for ways to calculated weighted average for 1 column, random
values as follows. I do not have frequences/quantities values.
1.3
1.4
1.6
1.7
1.7
1.8
1.6
1.6
1.7
1.6
 
What do you want to weight them by? Without a second variable, the only
thing you can do is calculate the average, as in:
=average(A:A)

Regards,
Fred
 
See the answers which were given to the very similar question asked by
"Julia" on this group an hour or so ago.
If you don't have weightings, you can calculate only an average, not a
weighted average.
 
To expand on my answer, if you don't understand the concept of a weighted
average:

You have ten values listed in your example, and the average is 1.6
If instead of the ten values you had persented your data in the form
1.3
1

1.4
1

1.6
4

1.7
3

1.8
1


listing the values in one column and the number of occurrences in the second
column, then you could calculate the weighted average with the formula
=SUMPRODUCT(A1:A5,B1:B5)/SUM(B1:B5)
and again get the answer 1.6. If you had just averaged the five values on
column A (with =AVERAGE(A1:A5)) you would have got the answer 1.56, but by
including the weighting factors in column B it gives you the weighted
average of 1.6.
 
Back
Top