due Thursday, May 31.
The Excel file Soccer.xls contains data about the 23 soccer player
from Germany and the 23 soccer player from Brasil participating in the FIFA soccer World Cup 2006. Please do the following:
a) On the teams datasheet, make a frequency table for Germany and Brasilian for the different teams. Use the COUNTIF function. Display both these informations as a bar graph.
b) On a new datasheet, make a frequency table for the German players' height with four classes: 160-169, 170-179, 180-189, 190-199. Also make a relative frequency table. Make histograms for both tables. Do the same for 10 classes: 160-163, 164-167, 168-171, 172-175,
176-179, 180-183, 184-187, 188-191, 192-195, 196-199.
Do the same for Brasil by copying the whole page on a new datasheet and pasting the 23 Brasil heights in.
c) Compute the mean of the German players' height, and the same for the Brasilian players. Compute also the standard deviation of both data sets.
d) Compute also mean and standard deviation for the age for the Germans, and also for the Brasilian players.
e) Find the median for the age of the German players and also the median of the Brasilian players' age.
f) Let's check whether players in the defense are larger on average than those attacking. Compute mean and standard deviation of all six (German and Brasil) goalkeepers (marked by a "G"), and do the same for the 17 defensive players ("D"), and for the 18 midfield players ("M"), and for the 8 attack players ("A"). What is the conclusion?
g) Make a scatter plot for age versus number of games played for their nation for Germany and for Brasil. Compare both plots. Is there any pattern visible? Is there any difference in these two scatter plots?
Erich Prisner, May 2006