0Nowadays rating got high importance everywhere. Whether you want to purchase an AC or a toy first we will check for rating of that product. Even before joining any institute we will review the rating then we will decide whether to join or not. Today we will learn calculating rating in Excel with example. In the below screenshot1 you can see the Overall rating and number of students reviewed count in JD site. Overall rating is 4.4 from 307 student reviews. Let’s see algorithm behind this 4.4.
5 star rating given by 210 students, 4 star rating by 60 students…(see below screenshot2)
Weighted Average of Overall student rating is =210*5+60*4+19*3+6*2+12*1 = 4.47
Screenshot1
Screenshot2
Hope you have learned something new today
Regards,
Team Excelytics
