Using data from the statistics file of football matches in the Premier League 2023-2024:
Perform the following requirements:
1. Statistics: use a pivot table to see which team has the most goals at home, which team has
the most away goals, which team has the most ball possession?
2. Statistics: mean, median, mode of shots/shots on target in matches (use 2 columns:
shots/shots on target)
3. Compare the ball possession percentage of Home teams and Away teams.
4. Compare the attendances between two half (10 top vs. 10 bottom) teams.
5. Use the data to answer the following question related to home advantage:
5.1 Are teams more likely to win at home?
5.2 Does a home team get higher scores than an away team?
5.3 Are the teams scoring more goals at home than those in away stadiums?
-------------------------------------------------------------------------------------------------------------------------------
1.
- The team has the most goals at home: ManchesterCity
- The team has the most away goals: ManchesterCity
- The team has the most ball possession: ManchesterCity
2.
Shots Shots on Target
- Mean: 13,66 - Mean: 4,67
- Median: 13,00 - Median: 4,00
- Mode: 10 - Mode: 4
3.
Compare the ball possession percentage of Home teams and Away teams
F-test:
- H0: Possession percentage (Home teams) = Possession percentage (Away teams)
- H1: Possession percentage (Home teams) ≠ Possession percentage (Away teams)
- P value =1 > α = 0,005
Fail to reject H0
No evidence supporting H1.
t-test:
P value= 0,001< α = 0,005
Reject H0
Support H1
Conclusion: Home teams have a higher ball possession percentage than Away teams.
4. Compare the attendances between two half (10 top vs. 10 bottom) teams
F-test:
- H0: Attendance (10 top teams) = Attendance (10 bottom teams)
- H1: Attendance (10 top teams) ≠ Attendance (10 bottom teams)
- P value = 0 < α = 0,005
reject H0
Equal variances not assumed
t-test:
- P value= 0 < α = 0,005
Reject H0
Support H1
Conclusion: 10 top teams have more attendances than 10 bottom teams.
5.
5.1. Are teams more likely to win at home?
F-test:
- H0: Variance (Home wins) ≤ Variance (Away wins)
- H1: Variance (Home wins) > Variance (Away wins)
- P value = 0 < α = 0,005
reject H0
Equal variances not assumed
t-test:
- P value= 0 < α = 0,005
Reject H0
Support H1
Conclusion: Teams are more likely to win at home.
5.3. Are the teams scoring more goals at home than those in away stadiums?
F-test:
- H0: Goals for (Home) ≤ Goals for (Away)
- H1: Goals for (Home) > Goals for (Away)
- P value = 0,159 > α = 0,005
Fail to reject H0
No evidence supporting H1.
t-test:
- P value= 0,001 < α = 0,005
Reject H0
Support H1
Conclusion: The teams are scoring more goals at home than those in away stadiums.
