Getting a average from a survey
 

I have survey data that I need to get a average for - Customers were to
select 1-5 for a answer and I now have totals for each of those responses.

1 not satisfied 6
2 7
3 14
4 15
5 very satisfied 20

The answer needs to be a number between 1-5 for the weighted average of the
totals.

Can someone please help

=(6*1+7*2+14*3+15*4+20*5)/(6+7+14+15+20)

HTH. Best wishes Harald

"rickvin" skrev i melding
...
I have survey data that I need to get a average for - Customers were to
select 1-5 for a answer and I now have totals for each of those responses.

1 not satisfied 6
2 7
3 14
4 15
5 very satisfied 20

The answer needs to be a number between 1-5 for the weighted average of
the
totals.

Can someone please help

One way:

Assuming your data are in B1:B5:

=SUMPRODUCT(B1:B5,{1;2;3;4;5})/SUM(B1:B5)



In article ,
"rickvin" wrote:

I have survey data that I need to get a average for - Customers were to
select 1-5 for a answer and I now have totals for each of those responses.

1 not satisfied 6
2 7
3 14
4 15
5 very satisfied 20

The answer needs to be a number between 1-5 for the weighted average of the
totals.

Can someone please help

One way

=SUMPRODUCT(A1:A5,B1:B5)/SUM(B1:B5)

Regards,

Peo Sjoblom

"rickvin" wrote:

I have survey data that I need to get a average for - Customers were to
select 1-5 for a answer and I now have totals for each of those responses.

1 not satisfied 6
2 7
3 14
4 15
5 very satisfied 20

The answer needs to be a number between 1-5 for the weighted average of the
totals.

Can someone please help