Microsoft Office Tutorials and References
In Depth Information
Case 11: The Baseball Offensive Performance Analysis
You have been hired by league baseball officials to analyze offensive performance in the previous
two years. An Access database file named BaseballAnalysis.accdb has been provided to assist you. The file
contains data for batters
performance during the past two seasons. The tables in the file are discussed next.
Figure 11-1 shows the first few records of player biographical data.
FIGURE 11-1
Player biographical data
Field definitions are as follows:
￿
PlayerNum
A unique number is assigned to each player. This is the table
s primary key field.
￿
Last Name
The player
s last name.
￿
First Initial
The initial letter of the player
s first name.
￿
Team
The player
s team.
￿
League
Teams are in two leagues: American (AL) and National (NL).
￿
Position
The player
s position in the field.
￿
Age
The player
s age in the season just completed.
The table named ThisYearsStats contains data for how each player performed in the season just ended.
Figure 11-2 shows the first few records of the table.
FIGURE 11-2
Player offensive performance this year
Field definitions are as follows:
￿
PlayerNum
A unique number is assigned to each player. This is the table
s primary key field.
￿
PA
The number of plate appearances for a player this season; in other words, the number of
times a player came to bat.
￿
AB
The number of at-bats the player had this season. This number is less than plate
appearances because walks and some other appearances do not count as an at-bat.
￿
R
The number of runs the player scored in the season.
￿
H
The number of hits the player had in the season. A hit occurs when a player hits the ball
and reaches base as a direct result. Hits are either singles, doubles, triples, or home runs.
￿
1B
The number of singles (one-base hits) the batter had this season.
￿
2B
The number of doubles (two-base hits) the batter had this season.
￿
3B
The number of triples (three-base hits) the batter had this season.
￿
HR
The number of home runs the batter had this season.
￿
BB
The number of times the batter reached first base via a walk.
￿
SO
The number of times the batter struck out.
￿
RBI
The number of runs batted in for the player this season. A player is credited with an RBI
each time a teammate scores as a direct result of the player
s base hit, walk, or other action.
The file has another table called LastYearsStats that contains the same types of offensive performance
data as the ThisYearsStats table. Thus, two years of offensive performance data are available. Data in the
ThisYearsStats table reflects statistics for a year in which home-plate umpires called strikes by the rulebook.
The LastYearsStats table reflects statistics for a year in which umpires used a smaller strike zone.
 
Search JabSto ::




Custom Search