The first attachment (above) is the price elasticity spreadsheet (where answers will be recorded). Use the data from the remaining attachments (below) to fill in the average ticket prices and average home game attendance figures for all of the NBA teams in 2019 and 2020. Use the information to calculate the price elasticity coefficient for each team.
Question 1 Average ticket price Attendance per game change in 2019 2020 2019 2020 price average price % change in price change in attendance average attendance % change in attendance Elasticity coefficient Team New York Knicks Los Angeles Lakers Golden State Warriors Chicago Bulls Boston Celtics Houston Rockets Los Angeles Clippers Sacramento Kings Cleveland Cavaliers Miami Heat Dallas Mavericks Brooklyn Nets Toronto Raptors Philadelphia 76ers Portland Trail Blazers Milwaukee Bucks San Antonio Spurs Phoenix Suns Atlanta Hawks Detroit Pistons Denver Nuggets Oklahoma City Thunder Orlando Magic Indiana Pacers Utah Jazz Minnesota Timberwolves Washington Wizards New Orleans Pelicans Memphis Grizzlies Charlotte Hornets Florida Panthers Question 3: Interpret the elasticity coefficient for Golden State Question 4: Why are some of the coefficients positive? Draw a graph to support your answer. Avg Ticket Price 180.78 131.42 140.41 104.84 Team New York Knicks Golden State Warriors Los Angeles Lakers Boston Celtics Chicago Bulls Houston Rockets Los Angeles Clippers Sacrament o Kings 110.51 108.35 90.3 89.08 81.12 Dallas Mavericks Miami Heat 72.93 83.58 67.86 71.23 Cleveland Cavaliers Brooklyn Nets Milwaukee Bucks Toronto Raptors Portland Trail Blazers Philadelphi a 76ers 76.03 69.58 68.89 70.52 63 58.39 57.07 San Antonio Spurs Oklahoma City Thunder Denver Nuggets Phoenix Suns Indiana Pacers Detroit Pistons Utah Jazz Orlando Magic Washington Wizards 57.02 55.36 55.68 55.23 41.84 53 43.52 37.73 Atlanta Hawks Minnesota Timberwolv es New Orleans Pelicans Memphis Grizzlies Charlotte Hornets Average 33.29 32.82 75.38 Avg Ticket Price 180.78 140.41 125.43 113.17 Team New York Knicks Los Angeles Lakers Golden State Warriors Chicago Bulls Boston Celtics Houston Rockets Los Angeles Clippers Sacrament o Kings 100.79 108.35 87.73 89.08 93.77 Cleveland Cavaliers Miami Heat 72.9 74.34 61.65 70.89 65.6 Dallas Mavericks Brooklyn Nets Toronto Raptors Philadelphi a 76ers Portland Trail Blazers Milwaukee Bucks San Antonio Spurs 65.71 61.39 70.52 57.07 60.44 54.1 54.63 Phoenix Suns Atlanta Hawks Detroit Pistons Denver Nuggets Oklahoma City Thunder Orlando Magic Indiana Pacers Utah Jazz 60.82 52.73 50.91 49.25 43.58 41.84 35.61 Minnesota Timberwolv es Washington Wizards New Orleans Pelicans Memphis Grizzlies Charlotte Hornets Average 34.27 32.05 73.66 2019 Attendance Home Road Overall RK TEAM GMS TOTAL AVG PCT GMS AVG PCT GMS AVG PCT 1 76ers 41 94.3 82 19,168 97.5 2 Bulls 41 94.7 82 18,953 95.4 41 17,895 41 17,822 41 18,073 41 18,239 3 Mavericks 41 95.9 838,092 20,441 100.6 823,475 20,084 96.0 820,569 20,013 104.2 812,822 19,824 100.1 805,264 19,640 100.2 803,436 19,596 108.5 82 19,043 100.1 4 Raptors 41 95.7 98.0 82 19,032 82 18,908 5 Heat 41 41 18,176 95.5 97.9 6 Warriors 41 41 18,790 100.0 82 19,193 104.2 Trail Blazers 41 799,345 19,496 100.3 41 17,992 96.1 82 18,753 98.2 N 00 Cavaliers 41 41 92.6 96.1 82 18,490 82 18,284 9 NY Knicks 41 41 93.4 94.7 10 Lakers 41 41 100.3 82 18,929 100.0 17,632 17,566 18,862 18,671 17,474 17,381 11 Celtics 41 41 97.5 98.8 82 18,647 82 17,962 12 Nuggets 41 41 93.6 94.1 13 Spurs 41 41 92.3 82 17,844 95.4 14 Jazz 41 793,337 19,349 99.6 779,087 19,002 95.9 778,877 18,997 99.7 763,584 18,624 100.0 756,457 18,450 94.5 750,616 18,307 98.5 750,546 18,306 100.0 746,323 18,203 100.0 740,392 18,058 100.1 721,692 17,602 101.5 720,024 17,561 93.2 716,996 17,487 86.2 710,327 17,325 90.9 41 17,517 93.0 82 17,911 96.4 15 Thunder 41 41 17,866 94.7 82 18,034 97.3 16 Rockets 41 41 95.0 82 17,989 97.5 17 Bucks 41 41 17,921 18,185 17,659 95.9 98.6 18 Magic 41 41 92.4 92.8 82 17,893 82 17,610 82 17,498 82 17,279 19 Wizards 41 41 17,509 91.8 89.0 20 Clippers 41 41 17,233 92.1 91.5 21 Kings 41 700,975 17,096 97.7 41 17,199 91.1 82 17,148 94.3 22 Pacers 41 689,310 16,812 92.6 41 17,957 93.7 82 17,377 93.1 23 Hornets 86.5 41 92.8 82 17,074 89.7 17,648 17,819 24 Pistons 78.5 41 94.1 85.9 25 Pelicans 93.1 41 17,667 93.4 93.3 41 676,570 16,501 41 675,963 16,486 41 656,183 16,004 41 607,564 15,578 41 628,440 15,327 41 627,543 15,305 26 Grizzlies 86.0 41 93.3 89.8 27 Hawks 81.8 41 17,579 17,786 17,641 93.7 82 17,153 82 16,835 82 16,604 82 16,557 82 16,473 82 16,638 82 16,513 87.8 28 Timberwolves 80.7 41 93.7 87.1 29 Suns 41 83.0 41 17,982 95.3 89.2 627,023 15,293 612,597 14,941 30 Nets 41 84.3 41 18,085 94.7 89.7 31 Leb 0 0 1 0 World 0 o 1 0 Usa 1 0 0 Gia 1 0 0 Question 1 Average ticket price Attendance per game change in 2019 2020 2019 2020 price average price % change in price change in attendance average attendance % change in attendance Elasticity coefficient Team New York Knicks Los Angeles Lakers Golden State Warriors Chicago Bulls Boston Celtics Houston Rockets Los Angeles Clippers Sacramento Kings Cleveland Cavaliers Miami Heat Dallas Mavericks Brooklyn Nets Toronto Raptors Philadelphia 76ers Portland Trail Blazers Milwaukee Bucks San Antonio Spurs Phoenix Suns Atlanta Hawks Detroit Pistons Denver Nuggets Oklahoma City Thunder Orlando Magic Indiana Pacers Utah Jazz Minnesota Timberwolves Washington Wizards New Orleans Pelicans Memphis Grizzlies Charlotte Hornets Florida Panthers Question 3: Interpret the elasticity coefficient for Golden State Question 4: Why are some of the coefficients positive? Draw a graph to support your answer. Avg Ticket Price 180.78 131.42 140.41 104.84 Team New York Knicks Golden State Warriors Los Angeles Lakers Boston Celtics Chicago Bulls Houston Rockets Los Angeles Clippers Sacrament o Kings 110.51 108.35 90.3 89.08 81.12 Dallas Mavericks Miami Heat 72.93 83.58 67.86 71.23 Cleveland Cavaliers Brooklyn Nets Milwaukee Bucks Toronto Raptors Portland Trail Blazers Philadelphi a 76ers 76.03 69.58 68.89 70.52 63 58.39 57.07 San Antonio Spurs Oklahoma City Thunder Denver Nuggets Phoenix Suns Indiana Pacers Detroit Pistons Utah Jazz Orlando Magic Washington Wizards 57.02 55.36 55.68 55.23 41.84 53 43.52 37.73 Atlanta Hawks Minnesota Timberwolv es New Orleans Pelicans Memphis Grizzlies Charlotte Hornets Average 33.29 32.82 75.38 Avg Ticket Price 180.78 140.41 125.43 113.17 Team New York Knicks Los Angeles Lakers Golden State Warriors Chicago Bulls Boston Celtics Houston Rockets Los Angeles Clippers Sacrament o Kings 100.79 108.35 87.73 89.08 93.77 Cleveland Cavaliers Miami Heat 72.9 74.34 61.65 70.89 65.6 Dallas Mavericks Brooklyn Nets Toronto Raptors Philadelphi a 76ers Portland Trail Blazers Milwaukee Bucks San Antonio Spurs 65.71 61.39 70.52 57.07 60.44 54.1 54.63 Phoenix Suns Atlanta Hawks Detroit Pistons Denver Nuggets Oklahoma City Thunder Orlando Magic Indiana Pacers Utah Jazz 60.82 52.73 50.91 49.25 43.58 41.84 35.61 Minnesota Timberwolv es Washington Wizards New Orleans Pelicans Memphis Grizzlies Charlotte Hornets Average 34.27 32.05 73.66 2019 Attendance Home Road Overall RK TEAM GMS TOTAL AVG PCT GMS AVG PCT GMS AVG PCT 1 76ers 41 94.3 82 19,168 97.5 2 Bulls 41 94.7 82 18,953 95.4 41 17,895 41 17,822 41 18,073 41 18,239 3 Mavericks 41 95.9 838,092 20,441 100.6 823,475 20,084 96.0 820,569 20,013 104.2 812,822 19,824 100.1 805,264 19,640 100.2 803,436 19,596 108.5 82 19,043 100.1 4 Raptors 41 95.7 98.0 82 19,032 82 18,908 5 Heat 41 41 18,176 95.5 97.9 6 Warriors 41 41 18,790 100.0 82 19,193 104.2 Trail Blazers 41 799,345 19,496 100.3 41 17,992 96.1 82 18,753 98.2 N 00 Cavaliers 41 41 92.6 96.1 82 18,490 82 18,284 9 NY Knicks 41 41 93.4 94.7 10 Lakers 41 41 100.3 82 18,929 100.0 17,632 17,566 18,862 18,671 17,474 17,381 11 Celtics 41 41 97.5 98.8 82 18,647 82 17,962 12 Nuggets 41 41 93.6 94.1 13 Spurs 41 41 92.3 82 17,844 95.4 14 Jazz 41 793,337 19,349 99.6 779,087 19,002 95.9 778,877 18,997 99.7 763,584 18,624 100.0 756,457 18,450 94.5 750,616 18,307 98.5 750,546 18,306 100.0 746,323 18,203 100.0 740,392 18,058 100.1 721,692 17,602 101.5 720,024 17,561 93.2 716,996 17,487 86.2 710,327 17,325 90.9 41 17,517 93.0 82 17,911 96.4 15 Thunder 41 41 17,866 94.7 82 18,034 97.3 16 Rockets 41 41 95.0 82 17,989 97.5 17 Bucks 41 41 17,921 18,185 17,659 95.9 98.6 18 Magic 41 41 92.4 92.8 82 17,893 82 17,610 82 17,498 82 17,279 19 Wizards 41 41 17,509 91.8 89.0 20 Clippers 41 41 17,233 92.1 91.5 21 Kings 41 700,975 17,096 97.7 41 17,199 91.1 82 17,148 94.3 22 Pacers 41 689,310 16,812 92.6 41 17,957 93.7 82 17,377 93.1 23 Hornets 86.5 41 92.8 82 17,074 89.7 17,648 17,819 24 Pistons 78.5 41 94.1 85.9 25 Pelicans 93.1 41 17,667 93.4 93.3 41 676,570 16,501 41 675,963 16,486 41 656,183 16,004 41 607,564 15,578 41 628,440 15,327 41 627,543 15,305 26 Grizzlies 86.0 41 93.3 89.8 27 Hawks 81.8 41 17,579 17,786 17,641 93.7 82 17,153 82 16,835 82 16,604 82 16,557 82 16,473 82 16,638 82 16,513 87.8 28 Timberwolves 80.7 41 93.7 87.1 29 Suns 41 83.0 41 17,982 95.3 89.2 627,023 15,293 612,597 14,941 30 Nets 41 84.3 41 18,085 94.7 89.7 31 Leb 0 0 1 0 World 0 o 1 0 Usa 1 0 0 Gia 1 0 0
