# Sports Stats by ajizai

VIEWS: 0 PAGES: 11

• pg 1
```									Name: Anna Wernimont                                                  CIT 110 Basics                        Date Printed:3/25/2013

Analysis:
My Excel document is illustrating statistics from the NBA teams from the 2011-2012 season.
My document takes each team from the NBA and identifies the teams averages for
fouls, points per game field goal percentages, 3 point percentages, free throw
percentages, rebounds per game, blocks per game, steals per game
total games played where over 100 points were scored and the total games won
and lost that were over those 100 points.

In the tabs below you will find information regarding the comparisons of many of the stats
found. The first tab lists all the teams and their statistics. The second tab holds
the same statistics but in alphabetical order. Following these two basic tabs are information
breakdowns of team statistics specifics. The filtering tab identifies the top teams
that have the least amount of fouls and averagly score over 100 points per game.
Conditioning formatting highlights the teams in the top 3% and lowest 3% of
field goal, free throw and 3 point percentages.
Following these conditiong tabs are tabs indicating charts and pivot tables comparing
teams to each other. The first chart compare teams with rebounds per game and the
scond chart compares all the teams in field goal, free throw and 3 point percentages.
Finally, the pivot tables identify games played where over 100 points were scored
and games won where over 100 points were scored, as well as rebounds per
game and steals per game.

The most interesting findings I had when comparing this data together was in the filtering tab.
The Denver Nuggets and the San Antonio Spurs are the only two teams with
less than 20 fouls per game and over 100 points scored per game. Also, it was
interesting to compare all the teams with the average field goal, free throw and
3 point percentages.

I will continue to update my data by going back at the end of the season and seeing how those
numbers relate to the numbers I found for this excel document. It will be
interesting to make a copy of this whole excel workbook and then compare
how the charts alter when the data entered changes.

File:7316150c-dc19-4b32-8d32-72743254f651.xlsx                         Page 1 of 11                                 Sheet:Analysis
Name: Anna Wernimont                                                                                     CIT 110 Basics                                                                                         Date printed:3/25/2013

SEQ        Team                  Mascot               Fouls           PPG             GW           GL            TGP            FG%           3PT%          FT%         RPG             BPG            SPG
1   New York              Knicks                       21.33           97.19        16.00          6.00          22.00          44%           32%          75%           42.48           4.33           9.58
2   Oklahoma City         Thunder                      20.31          103.71        29.00          5.00          34.00          48%           36%          78%           43.45           7.90           7.61
3   Denver                Nuggets                      19.56          103.48        22.00          8.00          30.00          47%           32%          74%           43.60           5.15           8.31
4   Detroit               Pistons                      19.31           89.51         6.00          4.00          10.00          43%           34%          76%           39.78           4.06           7.08
5   Orlando               Magic                        17.75           94.15        21.00          4.00          25.00          44%           38%          64%           42.83           4.25           6.71
6   Minnesota             Timberwolves                 18.74           98.57        14.00         10.00          24.00          44%           34%          77%           44.57           4.11           6.98
7   New Orleans           Hornets                      20.24           89.24         2.00          4.00           6.00          45%           33%          76%           41.12           4.77           7.08
8   Cleveland             Cavaliers                    20.51           93.65         8.00          6.00          14.00          42%           35%          71%           43.00           4.22           7.43
9   Washington            Wizards                      21.35           93.08         7.00          7.00          14.00          44%           32%          72%           41.88           6.65           7.92
10   Toronto               Raptors                      23.75           91.65         7.00          6.00          13.00          44%           34%          77%           41.35           5.02           6.83
11   New Jersey            Nets                         19.42           92.81         9.00          6.00          15.00          42%           35%          77%           40.21           4.08           7.47
12   L.A. Lakers           Lakers                       17.45           95.98        14.00          2.00          16.00          46%           31%          76%           45.59           5.47           6.02
13   Miami                 Heat                         20.00          101.26        23.00          3.00          26.00          48%           38%          78%           41.66           5.42           9.10
14   Houston               Rockets                      20.25           98.06        15.00          5.00          20.00          45%           36%          79%           42.19           4.87           7.25
15   Boston                Celtics                      20.29           91.59        11.00          3.00          14.00          46%           36%          78%           38.37           5.65           7.22
16   Sacramento            Kings                        19.51           98.37        12.00         11.00          23.00          43%           32%          75%           43.49           4.71           8.28
17   Memphis               Grizzlies                    20.04           95.10        13.00          3.00          16.00          45%           32%          75%           42.00           5.22          10.00
18   Indiana               Pacers                       21.94           96.10        15.00          4.00          19.00          44%           37%          78%           43.34           5.28           8.00
19   Charolotte            Bobcats                      19.45           87.49         4.00          3.00           7.00          42%           30%          75%           39.10           5.63           6.29
20   Portland              Trail Blazers                19.71           96.75        14.00          5.00          19.00          44%           34%          79%           40.62           5.08           8.23
21   Chicago               Bulls                        17.15           97.25        19.00          0.00          19.00          46%           38%          73%           46.02           5.89           7.04
22   Milkwaukee            Bucks                        19.53           98.57        20.00          5.00          25.00          44%           34%          77%           41.84           4.80           8.20
23   San Antonio           Spurs                        17.27          101.22        25.00          4.00          29.00          47%           39%          72%           42.57           4.29           7.18
24   Philadelphia          76er's                       17.73           93.61        13.00          2.00          15.00          45%           37%          73%           43.43           4.92           8.39
25   Atlanta               Hawks                        18.15           94.59        19.00          3.00          22.00          45%           37%          73%           42.65           4.69           8.00

TOTALS                                          490.74           2392.98                     119.00         477.00         11.14          8.63     18.78           1057.14         126.46         192.20

Source=http://www.nba.com/statistics/sortable_team_statistics/sortable2.html?cnf=1&prd=1

File:7316150c-dc19-4b32-8d32-72743254f651.xlsx                                                            Page 2 or 11                                                                                                 Sheet:NBA Stats
Name: Anna Wernimont                                                                                  CIT 110 Basics                                                                                   Date printed:3/25/2013

SEQ      Team            Mascot          Fouls           PPG             GW           GL            TGP            FG%           3PT%          FT%           RPG             BPG            SPG
25 Atlanta         Hawks                   18.15           94.59        19.00          3.00          22.00          45%           37%           73%            42.65           4.69           8.00
15 Boston          Celtics                 20.29           91.59        11.00          3.00          14.00          46%           36%           78%            38.37           5.65           7.22
19 Charolotte      Bobcats                 19.45           87.49         4.00          3.00           7.00          42%           30%           75%            39.10           5.63           6.29
21 Chicago         Bulls                   17.15           97.25        19.00          0.00          19.00          46%           38%           73%            46.02           5.89           7.04
8 Cleveland       Cavaliers               20.51           93.65         8.00          6.00          14.00          42%           35%           71%            43.00           4.22           7.43
3 Denver          Nuggets                 19.56          103.48        22.00          8.00          30.00          47%           32%           74%            43.60           5.15           8.31
4 Detroit         Pistons                 19.31           89.51         6.00          4.00          10.00          43%           34%           76%            39.78           4.06           7.08
14 Houston         Rockets                 20.25           98.06        15.00          5.00          20.00          45%           36%           79%            42.19           4.87           7.25
18 Indiana         Pacers                  21.94           96.10        15.00          4.00          19.00          44%           37%           78%            43.34           5.28           8.00
12 L.A. Lakers     Lakers                  17.45           95.98        14.00          2.00          16.00          46%           31%           76%            45.59           5.47           6.02
17 Memphis         Grizzlies               20.04           95.10        13.00          3.00          16.00          45%           32%           75%            42.00           5.22          10.00
13 Miami           Heat                    20.00          101.26        23.00          3.00          26.00          48%           38%           78%            41.66           5.42           9.10
22 Milkwaukee      Bucks                   19.53           98.57        20.00          5.00          25.00          44%           34%           77%            41.84           4.80           8.20
6 Minnesota       Timberwolves            18.74           98.57        14.00         10.00          24.00          44%           34%           77%            44.57           4.11           6.98
11 New Jersey      Nets                    19.42           92.81         9.00          6.00          15.00          42%           35%           77%            40.21           4.08           7.47
7 New Orleans     Hornets                 20.24           89.24         2.00          4.00           6.00          45%           33%           76%            41.12           4.77           7.08
1 New York        Knicks                  21.33           97.19        16.00          6.00          22.00          44%           32%           75%            42.48           4.33           9.58
2 Oklahoma City   Thunder                 20.31          103.71        29.00          5.00          34.00          48%           36%           78%            43.45           7.90           7.61
5 Orlando         Magic                   17.75           94.15        21.00          4.00          25.00          44%           38%           64%            42.83           4.25           6.71
24 Philadelphia    76er's                  17.73           93.61        13.00          2.00          15.00          45%           37%           73%            43.43           4.92           8.39
20 Portland        Trail Blazers           19.71           96.75        14.00          5.00          19.00          44%           34%           79%            40.62           5.08           8.23
16 Sacramento      Kings                   19.51           98.37        12.00         11.00          23.00          43%           32%           75%            43.49           4.71           8.28
23 San Antonio     Spurs                   17.27          101.22        25.00          4.00          29.00          47%           39%           72%            42.57           4.29           7.18
10 Toronto         Raptors                 23.75           91.65         7.00          6.00          13.00          44%           34%           77%            41.35           5.02           6.83
9 Washington      Wizards                 21.35           93.08         7.00          7.00          14.00          44%           32%           72%            41.88           6.65           7.92

TOTALS                              490.74            2392.98                     119.00         477.00         11.14          8.63         18.78         1057.14         126.46         192.20

File:7316150c-dc19-4b32-8d32-72743254f651.xlsx                                                            Page 3 or 11                                                                            Sheet:Softing-Alphabetically
Name: Anna Wernimont                                                    CIT 110 Basics                             Date printed:3/25/2013

Team          Mascot     Fouls PPG    GW    GL    TGP      FG%     3PT%     FT%     RPG       BPG      SPG
3 Denver        Nuggets     19.56 103.48 22.00 8.00    30.00     47%      32%     74%     43.60     5.15     8.31
23 San Antonio   Spurs       17.27 101.22 25.00 4.00    29.00     47%      39%     72%     42.57     4.29     7.18

*Teams with less than 20 fouls and over 100 points averaged per game.

File:7316150c-dc19-4b32-8d32-72743254f651.xlsx                           Page 4 or 11                                      Sheet:Filtering
Name: Anna Wernimont                                                                              CIT 110 Basics                                                                                     Date printed:3/25/2013

SEQ        Team            Mascot          Fouls            PPG             GW           GL            TGP            FG%           3PT%          FT%           RPG             BPG            SPG
1   New York        Knicks                   21.33           97.19        16.00          6.00          22.00          44%           32%           75%            42.48           4.33           9.58
2   Oklahoma City   Thunder                  20.31          103.71        29.00          5.00          34.00          48%           36%           78%            43.45           7.90           7.61
3   Denver          Nuggets                  19.56          103.48        22.00          8.00          30.00          47%           32%           74%            43.60           5.15           8.31
4   Detroit         Pistons                  19.31           89.51         6.00          4.00          10.00          43%           34%           76%            39.78           4.06           7.08
5   Orlando         Magic                    17.75           94.15        21.00          4.00          25.00          44%           38%           64%            42.83           4.25           6.71
6   Minnesota       Timberwolves             18.74           98.57        14.00         10.00          24.00          44%           34%           77%            44.57           4.11           6.98
7   New Orleans     Hornets                  20.24           89.24         2.00          4.00           6.00          45%           33%           76%            41.12           4.77           7.08
8   Cleveland       Cavaliers                20.51           93.65         8.00          6.00          14.00          42%           35%           71%            43.00           4.22           7.43
9   Washington      Wizards                  21.35           93.08         7.00          7.00          14.00          44%           32%           72%            41.88           6.65           7.92
10   Toronto         Raptors                  23.75           91.65         7.00          6.00          13.00          44%           34%           77%            41.35           5.02           6.83
11   New Jersey      Nets                     19.42           92.81         9.00          6.00          15.00          42%           35%           77%            40.21           4.08           7.47
12   L.A. Lakers     Lakers                   17.45           95.98        14.00          2.00          16.00          46%           31%           76%            45.59           5.47           6.02
13   Miami           Heat                     20.00          101.26        23.00          3.00          26.00          48%           38%           78%            41.66           5.42           9.10
14   Houston         Rockets                  20.25           98.06        15.00          5.00          20.00          45%           36%           79%            42.19           4.87           7.25
15   Boston          Celtics                  20.29           91.59        11.00          3.00          14.00          46%           36%           78%            38.37           5.65           7.22
16   Sacramento      Kings                    19.51           98.37        12.00         11.00          23.00          43%           32%           75%            43.49           4.71           8.28
17   Memphis         Grizzlies                20.04           95.10        13.00          3.00          16.00          45%           32%           75%            42.00           5.22          10.00
18   Indiana         Pacers                   21.94           96.10        15.00          4.00          19.00          44%           37%           78%            43.34           5.28           8.00
19   Charolotte      Bobcats                  19.45           87.49         4.00          3.00           7.00          42%           30%           75%            39.10           5.63           6.29
20   Portland        Trail Blazers            19.71           96.75        14.00          5.00          19.00          44%           34%           79%            40.62           5.08           8.23
21   Chicago         Bulls                    17.15           97.25        19.00          0.00          19.00          46%           38%           73%            46.02           5.89           7.04
22   Milkwaukee      Bucks                    19.53           98.57        20.00          5.00          25.00          44%           34%           77%            41.84           4.80           8.20
23   San Antonio     Spurs                    17.27          101.22        25.00          4.00          29.00          47%           39%           72%            42.57           4.29           7.18
24   Philadelphia    76er's                   17.73           93.61        13.00          2.00          15.00          45%           37%           73%            43.43           4.92           8.39
25   Atlanta         Hawks                    18.15           94.59        19.00          3.00          22.00          45%           37%           73%            42.65           4.69           8.00

TOTALS                                  490.74         2392.98                     119.00         477.00         11.14          8.63         18.78         1057.14         126.46         192.20

File:7316150c-dc19-4b32-8d32-72743254f651.xlsx                                                     Page 5 or 11                                                                                Sheet:Conditional Formatting
Average Rebounds Per Game by Team
Atlanta
San Antonio
Milkwaukee
Chicago
Portland
Charolotte
Indiana
Memphis
T     Sacramento
Boston
e        Houston

a          Miami
L.A. Lakers
Series1
m      New Jersey
Toronto
s     Washington
Cleveland
New Orleans
Minnesota
Orlando
Detroit
Denver
Oklahoma City
New York

34.00   36.00       38.00    40.00   42.00   44.00   46.00   48.00

Average Rebounds Per Game
NBA Comparison
90%

80%
P
e   70%

r
60%
c
e   50%                    Green=FT%
Red=3PT%
n                          Blue=FG%
40%
t
a   30%

g
20%
e
s   10%

0%

NBA Teams
Name: Anna Wernimont                                                     CIT 110 Basics                                                                                                                                                          Date printed:3/25/2013

Row Labels      Sum of Games Won       Sum of Total Games Played
Atlanta                           19                                22
Boston                            11                                14
Charolotte                         4                                 7
Chicago                           19                                19    40
Cleveland                          8                                14
35
Denver                            22                                30
Detroit                            6                                10    30
Houston                           15                                20    25
Indiana                           15                                19    20
L.A. Lakers                       14                                16    15                                                                                                                                                            Sum of Games Won
Memphis                           13                                16
10                                                                                                                                                            Sum of Total Games Played
Miami                             23                                26
Milkwaukee                        20                                25     5
Minnesota                         14                                24     0

Indiana

Milkwaukee
Detroit

Orlando
Atlanta
Charolotte

Memphis

New York

Portland

Washington
San Antonio
Cleveland

New Jersey
New Jersey                         9                                15
New Orleans                        2                                 6
New York                          16                                22
Oklahoma City                     29                                34
Orlando                           21                                25
Portland                          14                                19
Sacramento                        12                                23
San Antonio                       25                                29
Toronto                            7                                13
Washington                         7                                14
Grand Total                      358                               477

File:7316150c-dc19-4b32-8d32-72743254f651.xlsx                           Page 8 or 11                                                                                                                                                Sheet:Pivot Table-Gm Pld vs Gm Won
Name: Anna Wernimont                             CIT 110 Basics        Date printed:3/25/2013

Row Labels           Sum of RPG Sum of SPG
Denver                       43.6       8.31
L.A. Lakers                 45.59       6.02
Portland                    40.62       8.23
Sacramento                  43.49       8.28
San Antonio                 42.57       7.18
Washington                  41.88       7.92
Grand Total               257.75       45.94

50
45
40
35
30
25
20
15                                  Sum of RPG
10
5                                 Sum of SPG
0

File:7316150c-dc19-4b32-8d32-72743254f651.xlsx   Page 9 or 11     Sheet:Pivot Table-RPG vs SPG
Name: Anna Wernimont                                                                                   CIT 110 Basics                       Date printed:3/25/2013

SEQ        Team                Fouls      PPG       FG%      3PT%     FT%      RPG       BPG      SPG       IsBlank (Fouls)   IF Function
1   New York                 21.33     97.19     0.44     0.32     0.75     42.48     4.33      9.58       FALSE       not ok
2   Oklahoma City            20.31   103.71      0.48     0.36     0.78     43.45     7.90      7.61       FALSE       not ok
3   Denver                   19.56   103.48      0.47     0.32     0.74     43.60     5.15      8.31       FALSE       not ok
4   Detroit                  19.31     89.51     0.43     0.34     0.76     39.78     4.06      7.08       FALSE
5   Orlando                  17.75     94.15     0.44     0.38     0.64     42.83     4.25      6.71       FALSE
6   Minnesota                18.74     98.57     0.44     0.34     0.77     44.57     4.11      6.98       FALSE
7   New Orleans              20.24     89.24     0.45     0.33     0.76     41.12     4.77      7.08       FALSE
8   Cleveland                20.51     93.65     0.42     0.35     0.71     43.00     4.22      7.43       FALSE
9   Washington               21.35     93.08     0.44     0.32     0.72     41.88     6.65      7.92       FALSE
10   Toronto                  23.75     91.65     0.44     0.34     0.77     41.35     5.02      6.83       FALSE
11   New Jersey               19.42     92.81     0.42     0.35     0.77     40.21     4.08      7.47       FALSE
12   L.A. Lakers              17.45     95.98     0.46     0.31     0.76     45.59     5.47      6.02       FALSE
13   Miami                    20.00   101.26      0.48     0.38     0.78     41.66     5.42      9.10       FALSE
14   Houston                  20.25     98.06     0.45     0.36     0.79     42.19     4.87      7.25       FALSE
15   Boston                   20.29     91.59     0.46     0.36     0.78     38.37     5.65      7.22       FALSE
16   Sacramento               19.51     98.37     0.43     0.32     0.75     43.49     4.71      8.28       FALSE
17   Memphis                  20.04     95.10     0.45     0.32     0.75     42.00     5.22     10.00       FALSE
18   Indiana                  21.94     96.10     0.44     0.37     0.78     43.34     5.28      8.00       FALSE
19   Charolotte               19.45     87.49     0.42     0.30     0.75     39.10     5.63      6.29       FALSE
20   Portland                 19.71     96.75     0.44     0.34     0.79     40.62     5.08      8.23       FALSE
21   Chicago                  17.15     97.25     0.46     0.38     0.73     46.02     5.89      7.04       FALSE
22   Milkwaukee               19.53     98.57     0.44     0.34     0.77     41.84     4.80      8.20       FALSE
23   San Antonio              17.27   101.22      0.47     0.39     0.72     42.57     4.29      7.18       FALSE
24   Philadelphia             17.73     93.61     0.45     0.37     0.73     43.43     4.92      8.39       FALSE
25   Atlanta                  18.15     94.59     0.45     0.37     0.73     42.65     4.69      8.00       FALSE

TOTALS                  490.74    2392.98         11.14            18.78    1057.14    126.46         192.20

Criteria:
Team                Fouls        PPG        FG%           3PT%   FT%       RPG        BPG       SPG
Chicago                      0
Extract Certain Records:
Team                 Fouls       PPG        FG%           3PT%   FT%       RPG        BPG       SPG

File:7316150c-dc19-4b32-8d32-72743254f651.xlsx                                                         Page 10 or 11                           Sheet:Criteria(Extra)
Name: Anna Wernimont                                                           CIT 110 Basics                           Date printed:3/25/2013

Team            Fouls      PPG       FG%      3PT%      FT%      RPG       BPG      SPG
New York             21.33     97.19     0.44      0.32     0.75     42.48     4.33      9.58
Oklahoma City        20.31    103.71     0.48      0.36     0.78     43.45     7.90      7.61
Denver               19.56    103.48     0.47      0.32     0.74     43.60     5.15      8.31
Detroit              19.31     89.51     0.43      0.34     0.76     39.78     4.06      7.08
Orlando              17.75     94.15     0.44      0.38     0.64     42.83     4.25      6.71
Minnesota            18.74     98.57     0.44      0.34     0.77     44.57     4.11      6.98
New Orleans          20.24     89.24     0.45      0.33     0.76     41.12     4.77      7.08
Cleveland            20.51     93.65     0.42      0.35     0.71     43.00     4.22      7.43
Washington           21.35     93.08     0.44      0.32     0.72     41.88     6.65      7.92
Toronto              23.75     91.65     0.44      0.34     0.77     41.35     5.02      6.83
New Jersey           19.42     92.81     0.42      0.35     0.77     40.21     4.08      7.47
L.A. Lakers          17.45     95.98     0.46      0.31     0.76     45.59     5.47      6.02
Miami                20.00    101.26     0.48      0.38     0.78     41.66     5.42      9.10
Houston              20.25     98.06     0.45      0.36     0.79     42.19     4.87      7.25
Boston               20.29     91.59     0.46      0.36     0.78     38.37     5.65      7.22
Sacramento           19.51     98.37     0.43      0.32     0.75     43.49     4.71      8.28
Memphis              20.04     95.10     0.45      0.32     0.75     42.00     5.22     10.00
Indiana              21.94     96.10     0.44      0.37     0.78     43.34     5.28      8.00
Charolotte           19.45     87.49     0.42      0.30     0.75     39.10     5.63      6.29
Portland             19.71     96.75     0.44      0.34     0.79     40.62     5.08      8.23
Chicago              17.15     97.25     0.46      0.38     0.73     46.02     5.89      7.04
Milwaukee            19.53     98.57     0.44      0.34     0.77     41.84     4.80      8.20
San Antonio          17.27    101.22     0.47      0.39     0.72     42.57     4.29      7.18
Philadelphia         17.73     93.61     0.45      0.37     0.73     43.43     4.92      8.39

TOTALS             472.59    2298.39         10.70       8.26         18.04    1014.49      121.77     184.20
Select Totals       17.15      97.25         0.457      0.381         0.727      46.02        5.89       7.04

Team            Fouls       PPG        FG%           3PT%       FT%           RPG        BPG         SPG
Chicago

File:7316150c-dc19-4b32-8d32-72743254f651.xlsx                                 Page 11 or 11                    Sheet:Select Totals DSUM(Extra)

```
To top