Hard Light Productions Forums
Off-Topic Discussion => General Discussion => Topic started by: Ghostavo on November 23, 2011, 06:01:22 am
-
So I have the following (of many) table:
ENG FRA RUS ITA TUR GER AUS Total
0 3 0 3 2 4 6 5 23
1 0 5 0 3 2 6 4 20
2 1 3 7 7 3 1 1 23
3 0 3 3 6 1 1 0 14
4 0 0 0 0 2 0 4 6
5 2 1 2 0 0 0 2 7
6 2 0 1 0 1 1 1 6
7 1 0 0 0 0 1 2 4
8 0 0 0 0 0 0 1 1
9 0 0 0 0 0 0 1 1
10 0 0 0 0 0 0 0 0
11 0 0 0 0 0 0 0 0
12 0 0 0 0 0 0 0 0
13 0 0 0 0 0 0 0 0
14 0 0 0 0 0 0 0 0
15 0 0 0 0 0 0 0 0
16 0 0 0 0 0 0 0 0
17 0 0 0 0 0 0 0 0
18+ 0 0 0 0 0 0 0 0
Total 9 12 16 18 13 16 21 105
Which shows the results of an experiment involving a board game. It shows the number of games at the end of whose, one of the players (ENG, FRA, etc...) had control over a number of elements of the board. Example, row 7 column AUS shows that the player AUS had 2 games in which it ended with 7 elements, while row 18+ column ENG shows that the player ENG had 0 games in which it ended with 18 or more elements. It's basically a frequency table but with 7 (or 8 if you count total) columns.
I've tried just about every chart I could think of in Excel to try to capture graphically the relation between players, that is which player sucks (see GER), which player is solid (see FRA) and which player is just plain odd (see RUS and AUS). The problem is that every chart I try becomes a mess because of the amount of visual data on one chart, or becomes really hard to comprehend. The 3D surface chart seems to be the closest I found to what I want, but it displays data on the intersections and influences how the data around it looks.
I'm not sure if I explained myself clearly (most probably not) but, any ideas?
-
Bar chart for each match, layered if you want every result on the same chart.
Sounds best to me.
-
Seems like you could look at it in terms of expected winnings. Multiply the column elements by their row number, add up for each country, divide by the number of observations and see who's highest. Why make it complicated?
edit: I was so bored I actually did this in Excel. England wins, Germany loses. Bottom row is average winnings.
ENG FRA RUS ITA TUR GER AUS
0 0 0 0 0 0 0 0
1 0 5 0 3 2 6 4
2 2 6 14 14 6 2 2
3 0 9 9 18 3 3 0
4 0 0 0 0 8 0 16
5 10 5 10 0 0 0 10
6 12 0 6 0 6 6 6
7 7 0 0 0 0 7 14
8 0 0 0 0 0 0 8
9 0 0 0 0 0 0 9
10 0 0 0 0 0 0 0
11 0 0 0 0 0 0 0
12 0 0 0 0 0 0 0
13 0 0 0 0 0 0 0
14 0 0 0 0 0 0 0
15 0 0 0 0 0 0 0
16 0 0 0 0 0 0 0
17 0 0 0 0 0 0 0
18 0 0 0 0 0 0 0
3.4 2.1 2.4 1.9 1.9 1.5 3.3
[attachment deleted by a basterd]
-
I didn't do that because the average is misleading and that is assuming the row number scores are valued linearly.