Finding averages in an array
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Max
am 15 Okt. 2015
Beantwortet: Jos (10584)
am 16 Okt. 2015
1 4 2001 30 29 8 1
2 4 2002 4 5 2 1
2 4 2002 9 6 4 7
2 4 2002 19 14 7 3
2 4 2002 25 21 5 4
2 4 2002 7 18 4 5
2 4 2002 8 3 4 10
2 4 2003 10 27 8 0
Each row represents a match played. Column 6 represents the goals scored by 1 team and column 7 represents the goals scored by the opposition team. How do I find the average number of goals scored per match in the year 2002 (column 3)
Thanks for the help.
0 Kommentare
Akzeptierte Antwort
Thorsten
am 15 Okt. 2015
Bearbeitet: Thorsten
am 15 Okt. 2015
To find the average across all matches
mean(sum(X(:,6:7), 2))
4 Kommentare
Nobel Mondal
am 16 Okt. 2015
avgScoreFor2002 = mean(sum(X(X(:,3)==2002,6:7), 2));
sprintf('Average score/match for 2002 : %.4f', avgScoreFor2002)
Weitere Antworten (1)
Jos (10584)
am 16 Okt. 2015
As a beginner, you're better of to write out each individual step of the process in detail
Is2002Game = X(:,3)==2002 % true when the 3rd column equals 2002
Goals2002 = X(Is2002Game,[6 7]) % select goals of these matched
TotalScorePer2002Game = sum(Goals2002,2) % sum them per match
TotalScore = sum(TotalScorePer2002Game) % total sum
0 Kommentare
Siehe auch
Kategorien
Mehr zu Cell Arrays finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!