When Broad Appeal at Eurovision Doesn't Work | TOP 25 (1975-2023)

Описание: This is a video showing the top 25 Eurovision entries that got a lower than expected result despite having received points from relatively many countries! This can happen if these point values are all quite small and aren't enough to help overtake countries on the scoreboard.

How is this calculated?

I've crunched the numbers for every single finalist since 1975, and these are the two factors:

1. Result in the grand final
This is converted into a percentage so that wins are equal to 100% and last places are 0%, with all the rest of the places filling fractionally in between- you can think of it as the percentage of other participants which placed below a country. This is so that years with different amounts of participants are all brought to the same scale and results are able to be compared fairly.

2. Amount of countries giving it points
This is converted to a percentage in quite a complicated way so that each year under different variations of the system is just as capable of making the list. Here goes...
if the amount of countries an entry received points from is BELOW the average of sets of points received (10 from 1975-2003, slightly higher for 2004-2015 due to NQs also voting, and even higher from 2016-2023 due to the amount of possible sets being doubled), this is divided by the average and then by 2 to make a percentage between 0-50%.
if the amount of countries an entry received points from is ABOVE the average of sets of points received: subtract the average from it and divide it by the maximum (participants - 1) also with the average subtracted from that; then divide the total by 2 and add 0.5 to make a percentage betwen 50-100%.
finally, subtract this percentage from 100% in order to reverse it

WHY is this method used and not just simply dividing everything by the maximum?
In smaller years, it is much easier to get a higher ratio of sets of points from other countries, as they are still casting out 10 sets but across a smaller field. This means years with more participants have a much fairer chance of making the list.
In years after 2016, it is much easier to score points from a lot of countries due to the amount of potential sets everyone can give out going up to 20- setting the average much higher than what it would be under the 2004-2015 system ensures that seemingly high percentages of countries giving an entry points are reduced to something that more accurately reflects the impressiveness of this.

The average is taken of the 2 percentages (the figure from 1. and the reversed figure from 2.) and these 25 songs are in decreasing order approaching the lowest average percentage! You can think of it as how well these 2 factors correlate- a low result but with a low amount of countries blanking an entry.

FULL SHEET OF ALL THE RESULTS:
https://docs.google.com/spreadsheets/...

I know the calculations behind this video are very complicated so I'm very open to answering questions in the comments! To sum it up- if you see something in the video that doesn't seem right then it's because a formula has been put in place to make a fairer adjustment.