Excellent work, gram123! [goodjob] Very nice! I use both Excel and SPSS. One comment I'd like to make is that I work with the squared scores rather than the scores themselves. Otherwise the high scores weigh in too much. By the way, you put down the wrong list for the civilizations.
But it's very interesting. I stick to the fact though that we shouldn't separate scores by victory type. It's like compensating the score of a football match by the system the teams use (you know, 4-4-2; 3-4-3; 4-2-3-1...). I always go for a domination victory if possible, but sometimes I just find that a space victory is available earlier than domination victory, so while fighting the space ship reaches Alpha Centauri before I obtain the domination victory. If people go for a space or cultural victory by choice, then they admit defeat towards those that do obtain a domination victory (at the same difficulty level with the same civ). Or they just don't know about the score correlation that gram123 has proven so elegantly here, which can be seen as a lack of skills. (After all, knowledge is power.)
SPSS simply calculates the arithmetic mean per civilization/difficulty/whatever. Combined with the variance an error margin can be calculated too and thus how significantly different the averages are between each other (by doing a one-way ANOVA test).
But it's very interesting. I stick to the fact though that we shouldn't separate scores by victory type. It's like compensating the score of a football match by the system the teams use (you know, 4-4-2; 3-4-3; 4-2-3-1...). I always go for a domination victory if possible, but sometimes I just find that a space victory is available earlier than domination victory, so while fighting the space ship reaches Alpha Centauri before I obtain the domination victory. If people go for a space or cultural victory by choice, then they admit defeat towards those that do obtain a domination victory (at the same difficulty level with the same civ). Or they just don't know about the score correlation that gram123 has proven so elegantly here, which can be seen as a lack of skills. (After all, knowledge is power.)
SPSS simply calculates the arithmetic mean per civilization/difficulty/whatever. Combined with the variance an error margin can be calculated too and thus how significantly different the averages are between each other (by doing a one-way ANOVA test).