Archive for the 'Mathematics' Category
I’d like to find a way to properly rank items that have competed against each other. Sorting by percentage alone is not an option as lots of items will have only been in one match.
Well the problem is that the difference between the number of matches could be very pronounced. In my case there could be items with 100 matches and items with just 1, and a whole mess in between.
What i’d like is for some way to know whether a 4 out of 6 team is better then a 20 out of 30 team.
I want to display the results of a rank order survey question, and identify items for which there was significant disagreement (i.e. some people ranking an item high and some ranking it low). Do I just take the standard deviation of the weighted scores, or should I do something else?
On a ranking point system, I need the sum of each rank to equal 100 and to gradually increase over 13 people?
Here is my problem:
There are 13 people who share a commission off of one big revenue pool.
Based on their performance, they are ranked #1 through #13.
Each of them takes a percentage of the revenue based on their ranking (#1 gets the biggest percentage, #13 gets the smallest percentage).
I want #1 to get 15%.
I want #13 to get 1%.
Is there a mathematical formula to figure out what percentage I can I can give to #2 through #12 in which the sum of all the percentages, including the 1% and 15% equals 100%?
It’s easy to get the numbers to distribute evenly from 1% to 15% using a contant rate of increase of 1.6666666% for each consecutive ranking but the sum of all the percentages equals 104%. Is there a parabolic way to figure out how to distribute the percentages?
I have been trying to rank football teams using Excel based on their results for the past 4 seasons.
I would now like to compare ranking I produced with the actual ranking of teams for this season.
Which statistical test could I use to check if the team ranking I have calculated is valid?











