Docstoc

Sports Stats

Document Sample
Sports Stats Powered By Docstoc
					Name: Anna Wernimont                                                  CIT 110 Basics                        Date Printed:4/28/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:24e52461-5610-4c02-a45d-568bdf884431.xlsx                         Page 1 of 11                                 Sheet:Analysis
Name: Anna Wernimont                                                                                     CIT 110 Basics                                                                                         Date printed:4/28/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:24e52461-5610-4c02-a45d-568bdf884431.xlsx                                                            Page 2 or 11                                                                                                 Sheet:NBA Stats
Name: Anna Wernimont                                                                                  CIT 110 Basics                                                                                   Date printed:4/28/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:24e52461-5610-4c02-a45d-568bdf884431.xlsx                                                            Page 3 or 11                                                                            Sheet:Softing-Alphabetically
Name: Anna Wernimont                                                    CIT 110 Basics                             Date printed:4/28/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:24e52461-5610-4c02-a45d-568bdf884431.xlsx                           Page 4 or 11                                      Sheet:Filtering
Name: Anna Wernimont                                                                              CIT 110 Basics                                                                                     Date printed:4/28/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:24e52461-5610-4c02-a45d-568bdf884431.xlsx                                                     Page 5 or 11                                                                                Sheet:Conditional Formatting
                                 Average Rebounds Per Game by Team
          Atlanta
      Philadelphia
      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:4/28/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
Philadelphia                      13                                15
Portland                          14                                19
Sacramento                        12                                23
San Antonio                       25                                29
Toronto                            7                                13
Washington                         7                                14
Grand Total                      358                               477




File:24e52461-5610-4c02-a45d-568bdf884431.xlsx                           Page 8 or 11                                                                                                                                                Sheet:Pivot Table-Gm Pld vs Gm Won
Name: Anna Wernimont                             CIT 110 Basics        Date printed:4/28/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:24e52461-5610-4c02-a45d-568bdf884431.xlsx   Page 9 or 11     Sheet:Pivot Table-RPG vs SPG
Name: Anna Wernimont                                                                                   CIT 110 Basics                       Date printed:4/28/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:24e52461-5610-4c02-a45d-568bdf884431.xlsx                                                         Page 10 or 11                           Sheet:Criteria(Extra)
Name: Anna Wernimont                                                           CIT 110 Basics                           Date printed:4/28/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:24e52461-5610-4c02-a45d-568bdf884431.xlsx                                 Page 11 or 11                    Sheet:Select Totals DSUM(Extra)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:4/28/2013
language:Unknown
pages:11
huangyuarong huangyuarong
About