Cricket Analytics: Home Winning Percentage Analysis from 2012-2017

This report presents an analysis of sports data, focusing on cricket, specifically examining home winning percentages of various teams from 2012 to 2017. The analysis employs methods such as pivot tables and correlation analysis to determine the winning percentages on home grounds. The report includes data visualization through graphs and scatterplots, illustrating team ratings and variations over the years. The correlation coefficient is calculated to understand the relationship between different years. Furthermore, the report investigates the relationship between the difference in ratings and team ratings, using scatter diagrams to represent the data. Pivot tables are also utilized to summarize and analyze the winning data. All calculations and analyses were performed in Excel, with the results presented in the report.

SPORTS ASSIGNMENT

Table of Contents
Introduction............................................................................................................................................................... 2
Aims..........................................................................................................................................................................2
Methods..................................................................................................................................................................... 2
Results....................................................................................................................................................................... 2
Question 1:.............................................................................................................................................................4
Part A.................................................................................................................................................................4
Part B:................................................................................................................................................................5
Part C.................................................................................................................................................................5
Part D:................................................................................................................................................................7
Question2:..............................................................................................................................................................8
Part A:................................................................................................................................................................8
Part B:................................................................................................................................................................9
Conclusions..............................................................................................................................................................10
List of Figures
Figure 1: 2012............................................................................................................................................................2
Figure 2: 2013............................................................................................................................................................3
Figure 3: 2014............................................................................................................................................................3
Figure 4: 2015............................................................................................................................................................3
Figure 5: 2016............................................................................................................................................................4
Figure 6: 2017............................................................................................................................................................4
Figure 7: Variation Graph..........................................................................................................................................4
Figure 8: Scatterplot...................................................................................................................................................7
Figure 9: Rearrange the data......................................................................................................................................8
Figure 10: Scatter diagram.........................................................................................................................................8
Figure 11: Scatter diagram (absolute values).............................................................................................................9
Figure 12: Pivot table.................................................................................................................................................9
Figure 13: Scatter diagram.......................................................................................................................................10
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 1 of 11

Introduction
Refers to the data then this is all about the cricket. This provides the information about the wining of the teams at
the home and the away. There is a variable factor that matters the winning of the teams. initially, the cricket was
played in the 18th century. It was initially played in England and then spread to all over the world. The main events
of the crickets were organized by the ICC that is an international council of cricket. the major events are world
cups and the champions trophy. Refers to the current scenario, then there are three formats of cricket. Test, T-20
and one day. Test cricket is of the five days and each day 90 overs. One day cricket was 50 over the match and the
T-20 cricket was 20 over the match.
Aims
The aim is to develop the data for the home winning of the teams and develops the percentage of the winning on
the home grounds. The data is from 2012 to 2017. The data is all about the wining of the teams and calculate the
winning percentage and develops the pivot tables for the teams.
Methods
The method is pivot tables and the correlation analysis. After that analysis the home winning of every year. The
calculation is on the basis of x/y. Here x is the previous year and the y is the current year.
Other than this use the excel solver to analysis the winning percentage use the pivot table to analysis the home
winning. After that use of the correlation to analyses the winning scenario of the teams.
Results
Below shows the result of all the calculations with the screenshots of the excel worksheet.
For the year 2012.
Figure 1: 2012
For the year 2013.
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 2 of 11

Figure 2: 2013
For the year 2014.
Figure 3: 2014
For the year 2015.
Figure 4: 2015
For the year 2016.
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 3 of 11

Figure 5: 2016
For the year 2017.
Figure 6: 2017
Question 1:
Part A.
Below shows the variation graph of H. the graph is from 2012 to 2017.
Figure 7: Variation Graph
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 4 of 11

Part B:
Below shows the table for the team ratings for the years 2012 to 2017.
2012 2013 2014 2015 2016 2017
Adelaide 121.6 107.7 110.2 112.7 131.5 129.3
Brisbane
Lions
88.4 88.4 71.9 66.0 52.4 72.1
Carlton 108.7 107.2 90.7 64.7 79.9 81.5
Collingwood 117.4 116.2 97.4 103.5 96.4 101.1
Essendon 101.7 105.2 105.1 78.7 59.8 104.0
Fremantle 111.6 120.4 122.4 114.5 77.0 76.8
Geelong 116.9 130.1 111.7 101.7 127.6 114.3
Gold Coast 55.0 85.6 92.2 74.2 74.5 73.8
Greater
Western
Sydney
35.6 35.1 76.4 95.6 131.9 113.7
Hawthorn 141.1 131.9 132.7 137.6 115.3 93.0
Melbourne 65.3 42.5 72.9 79.2 98.3 103.5
North
Melbourne
107.3 120.1 111.1 103.9 107.0 85.3
Port Adelaide 83.5 100.1 122.7 109.2 104.4 120.8
Richmond 109.5 118.0 102.2 115.3 81.7 111.5
St Kilda 117.1 86.8 59.3 81.1 94.9 98.0
Sydney 127.9 123.4 129.4 119.4 133.4 118.5
West Coast 121.4 97.7 110.4 132.1 120.7 104.9
Western
Bulldogs
70.0 83.4 81.3 110.6 113.4 97.7
2012 2013 2014 2015 2016 2017
Adelaide 121.6 107.7 110.2 112.7 131.5 129.3
Brisbane
Lions
88.4 88.4 71.9 66.0 52.4 72.1
Part C.
There is a need to develops the scatter diagram for the system. for that need to identifies the x and the y variables.
In the below tables show all the values of the x and y coefficient.
X-2012 Y-2013
121.6 107.7
88.4 88.4
108.7 107.2
117.4 116.2
101.7 105.2
111.6 120.4
116.9 130.1
55.0 85.6
35.6 35.1
141.1 131.9
65.3 42.5
107.3 120.1
83.5 100.1
109.5 118.0
117.1 86.8
127.9 123.4
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 5 of 11

121.4 97.7
70.0 83.4
X-2013 Y-2014
107.7 110.2
88.4 71.9
107.2 90.7
116.2 97.4
105.2 105.1
120.4 122.4
130.1 111.7
85.6 92.2
35.1 76.4
131.9 132.7
42.5 72.9
120.1 111.1
100.1 122.7
118.0 102.2
86.8 59.3
123.4 129.4
97.7 110.4
83.4 81.3
X-2015 Y-2016
112.7 131.5
66.0 52.4
64.7 79.9
103.5 96.4
78.7 59.8
114.5 77.0
101.7 127.6
74.2 74.5
95.6 131.9
137.6 115.3
79.2 98.3
103.9 107.0
109.2 104.4
115.3 81.7
81.1 94.9
119.4 133.4
132.1 120.7
110.6 113.4
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 6 of 11
X-2014 Y-2015
110.2 112.7
71.9 66.0
90.7 64.7
97.4 103.5
105.1 78.7
122.4 114.5
111.7 101.7
92.2 74.2
76.4 95.6
132.7 137.6
72.9 79.2
111.1 103.9
122.7 109.2
102.2 115.3
59.3 81.1
129.4 119.4
110.4 132.1
81.3 110.6

X-2016 Y-2017
131.5 129.3
52.4 72.1
79.9 81.5
96.4 101.1
59.8 104.0
77.0 76.8
127.6 114.3
74.5 73.8
131.9 113.7
115.3 93.0
98.3 103.5
107.0 85.3
104.4 120.8
81.7 111.5
94.9 98.0
133.4 118.5
120.7 104.9
113.4 97.7
Figure 8: Scatterplot
Part D:
Correlation coefficient table will show below:
This was generated with the help of data analysis function in the excel.
2012 2013 2014 2015 2016 2017
Column 1 1
Column 2 0.837315 1
Column 3 0.560728 0.734256 1
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 7 of 11

Column 4 0.475813 0.442464 0.701499 1
Column 5 0.134776 0.001515 0.30255 0.624057 1
Column 6 0.124713 -0.01653 0.25027 0.434276 0.676814 1
Question2:
Part A:
This part shows the plot between the Diff as a function of Rating A. for that arrange all the values of the tables are
put in the same excel sheet and then draw the graph.
Figure 9: Rearrange the data
Figure 10: Scatter diagram
The above figure is without the absolute values. That means this contains both positive and negative values. The
below diagrams show only positive values.
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 8 of 11

Figure 11: Scatter diagram (absolute values)
The graph shows that the team rating increases, as this shows that the large group of values at the same part of the
graph. This shows that the increasing consistency with team rating.
Part B:
Develops the pivot tables.
Figure 12: Pivot table
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 9 of 11

Figure 13: Scatter diagram
Conclusions
This report is all about the Massey Constant Rating model data for the sports. By the use of this data, there is a
lot of calculation is performed and analyzed the report in the different format. All the analysis and the calculations
were performed in the Excel and all the result are attached to this report.
RMIT University
Document:12314360072142910853.docxx/Ian Grundy
Save Date: 02-04-2018
Page 10 of 11