Calculate weighted average for 1 column

[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

 

[Fred Smith]

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

 

[David Biddulph]

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.

 

[David Biddulph]

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.