In this Project Microsoft Excel Technology has been used.
To perform prediction analysis, I have chosen the College Basketball Stats and History website at Reference
Basketball is one of most popular sports in the college and professional level in the America. In this project, I will be comparing the performance of the teams in many ways for the 2019-2020 season to determine which team is the best performer. I will be using various techniques and methodology taught during this course to perform analysis on selected dataset.
Source of the dataset: Sports-reference
Entity | Name of Team |
---|---|
G | Number of Games |
MP | Minutes Played per Game |
FG | Field Goals per Game |
FGA | Field Goals Attempt per Game |
FG% | Field Goals percentage per Game |
2P | 2 PTs Per Game |
2PA | 2 PTs Attempt per Game |
2P% | 2 PTs Field Goal percentage per Game |
3P | 3 PTs Per Game |
3PA | 3 PTs Attempt per Game |
3P% | 3 PTs Field Goal percentage per Game |
FT | Free Throws per Game |
FTA | Free Throws Attempt per Game |
FT% | Free Throw Percentage per Game |
ORB | Offensive Rebounds per Game |
DRB | Defensive Rebounds per Game |
TRB | Total Rebounds per Game |
AST | Assists per Game |
STL | Steals per Game |
BLK | Blocks per Game |
TOV | Turnovers per Game |
PF | Personal Fouls |
PTS | Points Per Game |
• I am planning to use benchmark to measure a performance using very specific indicators such as productivity per unit of measure, cost per unit of measure, cycle time of x per unit of measure or defects per unit of measure.
• These outcomes will give us performance results and it is easy to compare with each other teams.
• At the minimum, will include the following performance indicators for each team:
-
Number of games won
-
Number of games lost
-
PTS -- Total Points
-
G -- Number of Games played during the season
-
FG% -- Field Goal Percentage
-
2P% -- 2 Points Field Goal percentage per Game
-
TOV -- Total Turnovers
Apply all the knowledge of lessons learned in class, in additional try out more Business analytics techniques on the data set, to find out what could be more scope of study in different area. The main aim of project to gain experience in versatile Business analytics subject.
I have decided to use Excel and functions such as Min, Max, Sum, Average, Count, Count IF, VlookUp to ease analysis work. I will also use some of the different features of Excel like Dashboard, ICON Sets, Sparklines, Descriptive Statistics, Predictive Model. This will be new function for me Use the Slicer functionality to slice the data