I am trying to solve a "Trickle down" Rating Formula.
The interaction is between a Seller, a Service, Participants in the Service and several Buyers of the Service. The rating is from 1 to 5 where 5 is the top rating. The Seller and Participants Can not Rate on the Service.
The Service Rating is done by the Buyers and is calculated by Weighted average Plus the Sellers and Participants Rating: What formula should I use? Rating=(1N1+2N2+3N3+4N4+5*N5)/TotalN
The Seller and Participants rating is only based on the rating of the previous Services and the total of all Services created: What formula should I use?
Thank you in advance for any help. Vasco