Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=(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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate average hours and minutes | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions | |||
average, array and offsets | Excel Worksheet Functions | |||
Using Average function when number is zero | Excel Worksheet Functions | |||
Average Column, but Skip Null and 0? | Excel Worksheet Functions |