Scientific Bayesian Average Calculator per Ancient Olympic Gods and Chuds Inc.

Simply the Correctly Implemented Bayesian Average Calculator

To calculate the Bayesian average based on the given dataset only, leave both the system’s mean and the system’s average number of ratings fields empty. The first row will return the same value as the average, but filling in two or more fields will shift results closer to the dataset’s average.

To calculate the Bayesian average based on a predefined system’s mean, set both the system’s mean and the system’s average number of ratings, then press the Update Global Constraints button.
You can also adjust the valid limits for ratings.

The addon works well with negative numbers.
Constraints:
• Min possible rating: Both positive and negative floats.
• Maximum possible rating: Both positive and negative floats, must be greater than the minimum possible rating.
• System’s mean: Both positive and negative floats, must be between the minimum and maximum possible rating or left empty (if not empty, the system’s average number of ratings must also be a non-empty positive number).
• System’s average number of ratings: Only positive numbers or left empty (if not empty, the system’s mean must also be non-empty).

For constraints to be applied, press the Update Global Constraints button.
The fields of the table will be calculated automatically.

Fields:
• Link/Name: A link to the product, movie, etc., or its name.
• Average rating: Both positive and negative floats, according to the limits set above for the given item.
• Number of ratings: A positive integer representing the number of ratings for the given item.
• Bayesian average: The calculated Bayesian average result for the given item.

Copy All Info - allows you to easily copy data in CSV format.

Methodology used: https://arpitbhayani.me/blogs/bayesian-average/#the-formula