Average Rating Calculator
Use our average rating calculator to calculate an overall star rating from 1–5 star reviews. Includes the average rating formula, how ratings are calculated, how to calculate average rating out of 5, and examples like 1 star rating, 4 star rating, and 5 star rating.
What Is an Average Star Rating?
An average star rating (also called an overall star rating) summarizes many individual reviews into one number—typically on a 1 to 5 stars rating system.
Most platforms calculate the average of ratings as a weighted average: each star level (1★, 2★, 3★, 4★, 5★) is multiplied by how many reviews it received, then divided by the total number of reviews.
This average rating calculator out of 5 is useful for products, apps, restaurants, and any place you want a single score that reflects all review counts.
Average Rating Formula
The overall star rating is a weighted average of each star value times its count.
n1 through n5 are the number of 1-star through 5-star ratings.
Your average is the weighted sum divided by the total count.
A quick example of how ratings are calculated.
This is a common “average star rating” pattern with some low ratings.
How to Calculate Average Rating
- 1
Enter how many 1-star, 2-star, 3-star, 4-star, and 5-star ratings you have.
- 2
The calculator multiplies each star value by its count and sums the results.
- 3
Divide by the total number of ratings to get the average rating out of 5.
Frequently Asked Questions
Use a weighted average: (1·n1 + 2·n2 + 3·n3 + 4·n4 + 5·n5) ÷ (n1 + n2 + n3 + n4 + n5).
Most sites calculate an overall star rating by taking the weighted average of the star values (1 through 5) based on how many reviews each star level received.
Average = (Σ(stars × count)) ÷ (total ratings). For a 1–5 system: (1·n1 + 2·n2 + 3·n3 + 4·n4 + 5·n5) ÷ N.
Add up all rating values and divide by how many ratings you have. Example: (5 + 4 + 4 + 3) ÷ 4 = 4.0.
If you have counts in cells (n1..n5), you can do a weighted average. Example: = (1*n1 + 2*n2 + 3*n3 + 4*n4 + 5*n5) / (n1+n2+n3+n4+n5). If you have a list of individual ratings in a column, use =AVERAGE(range).
Often, yes—4.0/5.0 generally indicates positive reviews. But what’s “good” depends on context (industry norms, number of reviews, and how spread out ratings are).
A 1-star rating usually represents the lowest satisfaction level in a 5-star rating system.
A 5-star rating usually represents the highest satisfaction level in a 5-star rating system.