Hello,
I'm looking for ideas on how to do this. I've looked up Mode, Median, and Weighted Averages and I'm not sure which, if any would work.
Currently I have a spreadsheet of albums by different bands. Each song on each album has a rating and this gives an average for an album. The thing is if an album is relatively short (say has 5-6 songs) and some one of them gets a low rating it brings down the average substantially. Alternately an album with 10+ tracks has its rating barely affected by one low rating.
Can anyone think of a formula or way to weight the albums differently based on how many songs are contained on the album?
Thanks in advance!
I'm looking for ideas on how to do this. I've looked up Mode, Median, and Weighted Averages and I'm not sure which, if any would work.
Currently I have a spreadsheet of albums by different bands. Each song on each album has a rating and this gives an average for an album. The thing is if an album is relatively short (say has 5-6 songs) and some one of them gets a low rating it brings down the average substantially. Alternately an album with 10+ tracks has its rating barely affected by one low rating.
Can anyone think of a formula or way to weight the albums differently based on how many songs are contained on the album?
Thanks in advance!