Calculating an average
I have a feedback sheet that i need to calculate an average on the rating
given. the feedback rating is 1-4 with 1 being bad, 4 being good. It currently looks like this: RATING 1 2 3 4 NUMBER 5 39 113 227 So 5 people have given a rating of 1, 39 people have given a rating of 2 etc etc How can i calculate the avereage rating....ie our average rating is 3.7 etc? Thanks |
Calculating an average
our average rating is 3.7 etc?
I think the correct result should be 3.46 =SUMPRODUCT(B1:E1,B2:E2)/SUM(B2:E2) -- Biff Microsoft Excel MVP "Maggie" wrote in message ... I have a feedback sheet that i need to calculate an average on the rating given. the feedback rating is 1-4 with 1 being bad, 4 being good. It currently looks like this: RATING 1 2 3 4 NUMBER 5 39 113 227 So 5 people have given a rating of 1, 39 people have given a rating of 2 etc etc How can i calculate the avereage rating....ie our average rating is 3.7 etc? Thanks |
All times are GMT +1. The time now is 10:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com