Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The chart above is used to answer the questions below. DA9 Data analytics can help Broadway theatre analysts understand ticket trends and opportunities. As chair
The chart above is used to answer the questions below.
DA9 Data analytics can help Broadway theatre analysts understand ticket trends and opportunities. As chair of training for a national professional association, you are organizing a training conference in New York City. Among necessary costs such as meals, conference facility rental, and entertainment, you want to keep the cost as reasonable as possible. Each year, the conference participants have enjoyed attending a Broadway show which is included with the conference registration fee. One challenge for you is to examine show ticket prices and select a popular show. Two factors that indicate the popularity of shows are total revenue and attendance. You have waited until a couple of weeks before the conference to examine these factors. A table containing gross revenue, attendance, and the percent of capacity of attendees from 29 Broadway shows for the week ending March 8, 2020 are presented here. Attendance Current Week Gross Gross Revenue Previous Week $ 1,503,738 $ 1,598,947 Average Ticket Price Show % of Capacity 100% WEST SIDE STORY 2020 108.03 1,002,597 75.44 90% ALADDIN HARRY POTTER AND THE CUI 77.33 99% WICKED 13,920 13,290 12,863 12,479 12,391 12,323 1,092,063 838,927 1,202,090 1,414,594 925,094 994,703 1,254,306 1,186,505 798,610 100.51 90% 95.76 88% THE LION KING FROZEN 2018 64.81 81% 1,023,780 11,373 90.02 90% BEETLEJUICE HAMILTON 2,688,721 1,077,912 2,696,189 1,571,114 10,756 $ 249.97 102% MOULIN ROUGE! 10,416 145.42 1,514,717 1,225,999 98% 80% TINA - THE TINA TURNER MUS 1,320,766 10,004 122.55 TO KILL A MOCKINGBIRD 9,811 126.13 91% 1,237,497 $920,904 775,193 1,132,279 $1,015,750 AIN'T TOO PROUD 9,364 98.35 80% MEAN GIRLS 778,089 8,873 87.37 88% THE PHANTOM OF THE OPER 652,565 639,216 8,856 73.69 68% 797,781 804,636 8,418 94.77 100% 801,671 845,496 96.29 93% COME FROM AWAY JAGGED LITTLE PILL SIX THE BOOK OF MORMON DEAR EVAN HANSEN 8,326 8,066 109.70 99% 884,878 929,168 896,885 897,000 965,733 116.73 98% 7,960 7,638 981,271 128.47 98% Attendance Current Week Average Ticket Price % of Capacity 100% 13,920 108.03 13,290 75.44 90% 12,863 77.33 Gross Show Gross Revenue Previous Week WEST SIDE STORY 2020 $ 1,503,738 $ 1,598,947 ALADDIN 1,002,597 1,092,063 HARRY POTTER AND THE CUI 994,703 838,927 WICKED 1,254,306 1,202,090 THE LION KING 1,186,505 1,414,594 FROZEN 2018 798,610 925,094 BEETLEJUICE 1,023,780 1,077,912 99% 12,479 100.51 90% 12,391 95.76 88% 12,323 64.81 81% 11,373 90.02 90% HAMILTON 2,688,721 2,696,189 10,756 $ 249.97 102% MOULIN ROUGE! 1,571,114 10,416 145.42 98% 1,514,717 1,225,999 1,320,766 10,004 122.55 80% TINA - THE TINA TURNER MUS TO KILL A MOCKINGBIRD AIN'T TOO PROUD 1,237,497 9,811 126.13 91% 1,132,279 $1,015,750 9,364 98.35 80% $920,904 775,193 778,089 8,873 87.37 88% MEAN GIRLS THE PHANTOM OF THE OPER 652,565 639,216 8,856 73.69 68% 94.77 100% 96.29 93% 109.70 99% 116.73 98% 128.47 98% 147.04 101% 82.15 75% 66.95 67% COME FROM AWAY 797,781 804,636 8,418 JAGGED LITTLE PILL 801,671 845,496 8,326 SIX 884,878 896,885 8,066 THE BOOK OF MORMON 929,168 897,000 7,960 DEAR EVAN HANSEN 981,271 965,733 7,638 HADESTOWN 1,086,478 1,016,675 7,389 CHICAGO 536,991 546,842 6,537 THE MINUTES 419,765 437,237 6,270 GIRL FROM THE NORTH COUI 477,388 503,694 6,156 THE INHERITANCE 430,157 409,086 5,328 HANGMEN 357,100 139,321 1,542 COMPANY 2020 779,588 DIANA 376,471 THE LEHMAN TRILOGY 188,126 WHO'S AFRAID OF VIRGINIA V 344,818 Source: https://www.broadwayleague.com/research/grosses-broadway-nyc/#weekly_grosses 77.55 79% 80.74 70% 231.58 83% 102% 86% 100% 94% a. Sort the data in the data table above in order of the largest to smallest attendance. Create a tree map visualization for the top 16 shows based upon ticket prices for the week of March 8, 2020. Include a descriptive chart title. b. Create a second tree map visualization, again sorted by attendance, for the top 16 shows based upon the largest attendance for the week ending March 8, 2020. Include a descriptive chart title. DA9 Data analytics can help Broadway theatre analysts understand ticket trends and opportunities. As chair of training for a national professional association, you are organizing a training conference in New York City. Among necessary costs such as meals, conference facility rental, and entertainment, you want to keep the cost as reasonable as possible. Each year, the conference participants have enjoyed attending a Broadway show which is included with the conference registration fee. One challenge for you is to examine show ticket prices and select a popular show. Two factors that indicate the popularity of shows are total revenue and attendance. You have waited until a couple of weeks before the conference to examine these factors. A table containing gross revenue, attendance, and the percent of capacity of attendees from 29 Broadway shows for the week ending March 8, 2020 are presented here. Attendance Current Week Gross Gross Revenue Previous Week $ 1,503,738 $ 1,598,947 Average Ticket Price Show % of Capacity 100% WEST SIDE STORY 2020 108.03 1,002,597 75.44 90% ALADDIN HARRY POTTER AND THE CUI 77.33 99% WICKED 13,920 13,290 12,863 12,479 12,391 12,323 1,092,063 838,927 1,202,090 1,414,594 925,094 994,703 1,254,306 1,186,505 798,610 100.51 90% 95.76 88% THE LION KING FROZEN 2018 64.81 81% 1,023,780 11,373 90.02 90% BEETLEJUICE HAMILTON 2,688,721 1,077,912 2,696,189 1,571,114 10,756 $ 249.97 102% MOULIN ROUGE! 10,416 145.42 1,514,717 1,225,999 98% 80% TINA - THE TINA TURNER MUS 1,320,766 10,004 122.55 TO KILL A MOCKINGBIRD 9,811 126.13 91% 1,237,497 $920,904 775,193 1,132,279 $1,015,750 AIN'T TOO PROUD 9,364 98.35 80% MEAN GIRLS 778,089 8,873 87.37 88% THE PHANTOM OF THE OPER 652,565 639,216 8,856 73.69 68% 797,781 804,636 8,418 94.77 100% 801,671 845,496 96.29 93% COME FROM AWAY JAGGED LITTLE PILL SIX THE BOOK OF MORMON DEAR EVAN HANSEN 8,326 8,066 109.70 99% 884,878 929,168 896,885 897,000 965,733 116.73 98% 7,960 7,638 981,271 128.47 98% Attendance Current Week Average Ticket Price % of Capacity 100% 13,920 108.03 13,290 75.44 90% 12,863 77.33 Gross Show Gross Revenue Previous Week WEST SIDE STORY 2020 $ 1,503,738 $ 1,598,947 ALADDIN 1,002,597 1,092,063 HARRY POTTER AND THE CUI 994,703 838,927 WICKED 1,254,306 1,202,090 THE LION KING 1,186,505 1,414,594 FROZEN 2018 798,610 925,094 BEETLEJUICE 1,023,780 1,077,912 99% 12,479 100.51 90% 12,391 95.76 88% 12,323 64.81 81% 11,373 90.02 90% HAMILTON 2,688,721 2,696,189 10,756 $ 249.97 102% MOULIN ROUGE! 1,571,114 10,416 145.42 98% 1,514,717 1,225,999 1,320,766 10,004 122.55 80% TINA - THE TINA TURNER MUS TO KILL A MOCKINGBIRD AIN'T TOO PROUD 1,237,497 9,811 126.13 91% 1,132,279 $1,015,750 9,364 98.35 80% $920,904 775,193 778,089 8,873 87.37 88% MEAN GIRLS THE PHANTOM OF THE OPER 652,565 639,216 8,856 73.69 68% 94.77 100% 96.29 93% 109.70 99% 116.73 98% 128.47 98% 147.04 101% 82.15 75% 66.95 67% COME FROM AWAY 797,781 804,636 8,418 JAGGED LITTLE PILL 801,671 845,496 8,326 SIX 884,878 896,885 8,066 THE BOOK OF MORMON 929,168 897,000 7,960 DEAR EVAN HANSEN 981,271 965,733 7,638 HADESTOWN 1,086,478 1,016,675 7,389 CHICAGO 536,991 546,842 6,537 THE MINUTES 419,765 437,237 6,270 GIRL FROM THE NORTH COUI 477,388 503,694 6,156 THE INHERITANCE 430,157 409,086 5,328 HANGMEN 357,100 139,321 1,542 COMPANY 2020 779,588 DIANA 376,471 THE LEHMAN TRILOGY 188,126 WHO'S AFRAID OF VIRGINIA V 344,818 Source: https://www.broadwayleague.com/research/grosses-broadway-nyc/#weekly_grosses 77.55 79% 80.74 70% 231.58 83% 102% 86% 100% 94% a. Sort the data in the data table above in order of the largest to smallest attendance. Create a tree map visualization for the top 16 shows based upon ticket prices for the week of March 8, 2020. Include a descriptive chart title. b. Create a second tree map visualization, again sorted by attendance, for the top 16 shows based upon the largest attendance for the week ending March 8, 2020. Include a descriptive chart titleStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started