How to do an average formula ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing an evaluation form for example we have satisfied (1-5) and the number of people. How do I do an average function, for example, 4 people chooses level 3, 4 people chooses level 4 and 4 people chooses level 5. The formula I need is the average level depending on how many people responded

Thank you.
 
Have you looked at the Average function ?

Depends how you want to do your calculation but that start you in the right
direction

Regards

Trevor


Zairina said:
I am doing an evaluation form for example we have satisfied (1-5) and the
Click to expand...
number of people. How do I do an average function, for example, 4 people
chooses level 3, 4 people chooses level 4 and 4 people chooses level 5. The
formula I need is the average level depending on how many people responded.
 
Thanks, yes I have looked at the average function. But what I need is something complicated, here's an example of a table

level 1 level 2 level 3 level 4 level 5 average
4 4 4

This is for 12 people in an evaluation study. What I need is an average overall of levels (1-5)
 
Is the 1,2,3,4,5 a satisfaction level, and then would an average of say 3.2 or
3.8 etc be OK depending on data of course. If so then I think you are looking
for a weighted average, which you can possibly get using the following formula.
Assumes your 1,2,3,4,5 is in cells A1:E1 and your responses somewhere in A2:E2
down. Formula can be copied down if you have multiple lines of data.

=SUMPRODUCT($A$1:$E$1*A2:E2)/SUM(A2:E2)

With your 4,4,4 you will get an average of 4 anyway if I have interpreted it
correctly, and if you had 5,4,3 in those cells instead you would get 3.8333...

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Zairina said:
Thanks, yes I have looked at the average function. But what I need is
Click to expand...
something complicated, here's an example of a table.
level 1 level 2 level 3 level 4
Click to expand...
level 5 average ?
 
Back
Top