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 1## 4 Replies - 841 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