I mean taking the average of every time on a given board to get an average for that game. I understand I could just go one by one and do this manually but I want to know if there is an easier way.

Problem is there will be heavy variance I'd imagine.

WR can be 11 minutes or something and someone could have submitted a casual run at 2 hours. It only gets worse the more popular the game is.

Seems like if you get the raw data (which is something I assume can be done through API, but I know nothing about it) you could control for outliers, though you'd have to use... STATISTICS (something else I know very little about).

ROMaster2 has a list of all the games data, and one of the stats I think is average run time, https://www.speedrun.com/The_Site/thread/b4hsn#ch3Game_Statistics it might be in there, I can't load the lists on my phone to see

I'd use median instead of average thanks to huge outlier runs. You can use the API to get the runs from each board, though it's less than ideal.

best dumping data in excel and averaging out

It’s difficult to say. For Super Mario Bros, I’d say take the best run of the fastest known strats, and the worst run of the safest strats (ignoring outliers), and find the median between them for the average time.

For games like Odyssey, where the ‘perfect’ run is still far from being discovered, I think there’s nothing to do but eyeball it. At the moment I’d say that’s around a 1:17 run, but the moment a new strat is found, the average time will jump down a couple minutes.

I think I'm going to take a look at that as a for funsies project. A chrome extension or something.