In 2010, South Africa hosted 32 countries in the World Cup soccer tournament. Da
ID: 3318490 • Letter: I
Question
In 2010, South Africa hosted 32 countries in the World Cup soccer tournament. Data were collected on team performance variables including the average number of goals scored per match (Goals), the shooting percentage (Shoot), the average number of passes per match (Pass), whether or not the team played in the 2006 World Cup (Exper = 1 if played, 0 if not), and whether or not the team is from Africa (Africa = 1 if from Africa, 0 if not). Build a model to predict the number of goals per match using the other variables in the data set. Is there evidence of a home-continent advantage in this World Cup? The data are in WorldCup.xlsx.
Question: conduct a complete analysis of the data. Keep in mind the main research question(s) of the given study but be sure to include a complete diagnostic analysis and justification for any model(s) you use in your analysis, (i.e. assess model assumptions and the impact of potentially influential observations). Be sure to clearly state specific model(s) you fit using the correct model notation or specification.
PLEASE USE SPSS
Country Goals Shoot Pass Exper Africa Algeria 0 0 353 0 1 Arentina 2 23 459 1 0 Australia 1 21 348 1 0 Brazil 1.8 29 451 1 0 Cote d'Ivoire 1.33 20 375 1 1 Cameroon 0.67 13 400 0 1 Chile 0.75 16 360 0 0 Denmark 1 19 345 0 0 England 0.75 10 395 1 0 France 0.33 9 335 1 0 Germany 2.29 38 409 1 0 Ghana 1 16 329 1 1 Greece 0.67 13 281 0 0 Honduras 0 0 252 0 0 Italy 1.33 22 407 1 0 Japan 1 15 223 1 0 Korea DPR 0.33 9 268 0 0 Korea Republic 1.5 27 332 1 0 Mexico 1 22 400 1 0 Netherlands 1.71 26 381 1 0 New Zealand 0.67 67 221 0 0 Nigeria 1 33 266 0 1 Paraguay 0.6 12 311 1 0 Portugal 1.75 33 365 1 0 Serbia 0.67 18 358 0 0 Slovakia 1.25 45 309 0 0 Slovenia 1 21 305 0 0 South Africa 1 17 353 0 1 Spain 1.14 17 543 1 0 Switzerland 0.33 11 277 1 0 Uruguay 1.57 24 270 0 0 USA 1.25 19 294 1 0Explanation / Answer
We can use regresssion model to analysis this data set.
The model is
Goal = b0 + b1 Shoot + b2 Pass +b3 Exper +b4 Africa
The results are calculated by excel which is given below
No, there is not evidence of a home-continent advantage in this World Cup becuase p-value is less than greater the level of significance.
SUMMARY OUTPUT Regression Statistics Multiple R 0.76381 R Square 0.583406 Adjusted R Square 0.521688 Standard Error 0.380034 Observations 32 ANOVA df SS MS F Significance F Regression 4 5.460927 1.365232 9.452828 6.52E-05 Residual 27 3.899495 0.144426 Total 31 9.360422 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept -0.60248 0.369887 -1.62881 0.114967 -1.36142 0.156469 Shoot 0.023698 0.005384 4.401468 0.000152 0.01265 0.034745 Pass 0.002796 0.001069 2.613983 0.014457 0.000601 0.00499 Exper 0.316461 0.154064 2.054094 0.049765 0.000349 0.632574 Africa -0.02797 0.180444 -0.15501 0.877969 -0.39821 0.34227Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.