Analysis & visual representation of football (soccer) results

**deWinters** · 08-09-2010, 03:18 AM

I have home and away football (soccer) results in a matrix format. The English Premiership results for 2009-10 are attached as an example.

I would like to analyse the frequency of the individual scorelines (0-0, 1-0, 1-1, 2-0, ...) ignoring the teams concerned. A previous attempt for an earlier year is given in the pdf . Ideally I would also like to represent this graphically.

i) How can I quickly count the individual scorelines?
ii) Is there a 'better' way to represent the data in a table or even graphically?

Cheers.

**Bob Phillips** · 08-09-2010, 03:51 AM

Just use COUNTIF

=COUNTIF(B2:U21,"1–1")

**DonkeyOte** · 08-09-2010, 03:56 AM

Using your sample file

A26: =COUNTA($B$2:$U$21)

B26:K26 - enter 1 to 9
A27:A36 - enter 1 to 9

B27: =COUNTIF($B$2:$U$21;B$26&"–"&$A27)/$A$26
apply to matrix B27:K36
apply custom number format of 0.0%;;;