I have a star rating system for restaurant
users can rate for Food Quality / Service / Environment / Value for money
Max rating is 5 for all of the topics
There is a overole rating system for display the overole rating of the restaurant based on the above 4 ratings this is where the problam comes . i consider this problem as a mathematical problem
User 1
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
overole rating should be 5 right ? how do i calculate it . thank you
Overole Rating problam
Page 1 of 14 Replies  731 Views  Last Post: 17 May 2013  10:42 PM
Replies To: Overole Rating problam
#2
Re: Overole Rating problam
Posted 17 May 2013  09:48 PM
istore221, on 17 May 2013  09:42 PM, said:
I have a star rating system for restaurant
users can rate for Food Quality / Service / Environment / Value for money
Max rating is 5 for all of the topics
There is a overole rating system for display the overole rating of the restaurant based on the above 4 ratings this is where the problam comes . i consider this problem as a mathematical problem
User 1
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
overole rating should be 5 right ? how do i calculate it . thank you />
users can rate for Food Quality / Service / Environment / Value for money
Max rating is 5 for all of the topics
There is a overole rating system for display the overole rating of the restaurant based on the above 4 ratings this is where the problam comes . i consider this problem as a mathematical problem
User 1
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
overole rating should be 5 right ? how do i calculate it . thank you />
total number of stars / number of ratings. so for your example it would be 15/3 = 5
Is this what you were looking for?
#3
Re: Overole Rating problam
Posted 17 May 2013  10:23 PM
mattmandery, on 17 May 2013  09:48 PM, said:
istore221, on 17 May 2013  09:42 PM, said:
I have a star rating system for restaurant
users can rate for Food Quality / Service / Environment / Value for money
Max rating is 5 for all of the topics
There is a overole rating system for display the overole rating of the restaurant based on the above 4 ratings this is where the problam comes . i consider this problem as a mathematical problem
User 1
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
overole rating should be 5 right ? how do i calculate it . thank you />/>
users can rate for Food Quality / Service / Environment / Value for money
Max rating is 5 for all of the topics
There is a overole rating system for display the overole rating of the restaurant based on the above 4 ratings this is where the problam comes . i consider this problem as a mathematical problem
User 1
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
overole rating should be 5 right ? how do i calculate it . thank you />/>
total number of stars / number of ratings. so for your example it would be 15/3 = 5
Is this what you were looking for?
User 1
Quality 3/5  Service 1/5  Environment 2/5  Value for money 2/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 1/5  Service 3/5  Environment 1/5  Value for money 2/5
User 4
Quality 4/5  Service 4/5  Environment 2/5  Value for money 2/5
What would be the overole rating how do i calculate is please provide the formula for this senario
#4
Re: Overole Rating problam
Posted 17 May 2013  10:27 PM
istore221, on 17 May 2013  10:23 PM, said:
mattmandery, on 17 May 2013  09:48 PM, said:
istore221, on 17 May 2013  09:42 PM, said:
I have a star rating system for restaurant
users can rate for Food Quality / Service / Environment / Value for money
Max rating is 5 for all of the topics
There is a overole rating system for display the overole rating of the restaurant based on the above 4 ratings this is where the problam comes . i consider this problem as a mathematical problem
User 1
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
overole rating should be 5 right ? how do i calculate it . thank you />/>/>
users can rate for Food Quality / Service / Environment / Value for money
Max rating is 5 for all of the topics
There is a overole rating system for display the overole rating of the restaurant based on the above 4 ratings this is where the problam comes . i consider this problem as a mathematical problem
User 1
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
overole rating should be 5 right ? how do i calculate it . thank you />/>/>
total number of stars / number of ratings. so for your example it would be 15/3 = 5
Is this what you were looking for?
User 1
Quality 3/5  Service 1/5  Environment 2/5  Value for money 2/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 1/5  Service 3/5  Environment 1/5  Value for money 2/5
User 4
Quality 4/5  Service 4/5  Environment 2/5  Value for money 2/5
What would be the overole rating how do i calculate is please provide the formula for this senario
Lets examine the quality. If you add all 4 of the ratings it would be 3 + 5 + 1 + 4 =13. There were a total of 4 ratings which led to the sum of 13. so if we divide the total number of stars earned by how many ratings were registered your would get 13/4. which equals 3.25. (if you dont have a gui for half stars ect i would use a floor or ceiling function to keep a nice even number.) Total number of stars earned / number of votes. Hope this helps
#5
Re: Overole Rating problam
Posted 17 May 2013  10:42 PM
mattmandery, on 17 May 2013  10:27 PM, said:
istore221, on 17 May 2013  10:23 PM, said:
mattmandery, on 17 May 2013  09:48 PM, said:
istore221, on 17 May 2013  09:42 PM, said:
I have a star rating system for restaurant
users can rate for Food Quality / Service / Environment / Value for money
Max rating is 5 for all of the topics
There is a overole rating system for display the overole rating of the restaurant based on the above 4 ratings this is where the problam comes . i consider this problem as a mathematical problem
User 1
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
overole rating should be 5 right ? how do i calculate it . thank you />/>/>/>
users can rate for Food Quality / Service / Environment / Value for money
Max rating is 5 for all of the topics
There is a overole rating system for display the overole rating of the restaurant based on the above 4 ratings this is where the problam comes . i consider this problem as a mathematical problem
User 1
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
overole rating should be 5 right ? how do i calculate it . thank you />/>/>/>
total number of stars / number of ratings. so for your example it would be 15/3 = 5
Is this what you were looking for?
User 1
Quality 3/5  Service 1/5  Environment 2/5  Value for money 2/5
User 2
Quality 5/5  Service 5/5  Environment 5/5  Value for money 5/5
User 3
Quality 1/5  Service 3/5  Environment 1/5  Value for money 2/5
User 4
Quality 4/5  Service 4/5  Environment 2/5  Value for money 2/5
What would be the overole rating how do i calculate is please provide the formula for this senario
Lets examine the quality. If you add all 4 of the ratings it would be 3 + 5 + 1 + 4 =13. There were a total of 4 ratings which led to the sum of 13. so if we divide the total number of stars earned by how many ratings were registered your would get 13/4. which equals 3.25. (if you dont have a gui for half stars ect i would use a floor or ceiling function to keep a nice even number.) Total number of stars earned / number of votes. Hope this helps
Thank You very much this helps a lot No i dont have half rating its is working now thank you again ..
Page 1 of 1
