Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are the owner of a small business that manages the program, food, and merchandise sales at the Excel Center, where the local professional
You are the owner of a small business that manages the program, food, and merchandise sales at the Excel Center, where the local professional basketball team plays. In addition to basketball games, the Excel Center hosts dozens of events a year. Your company handles all sales inside the arena. There are three major products you sell: programs, food, and merchandise. You have randomly selected sales and attendance data from a number of past events to help build your model. This data can be found on the "Past Events" worksheet. You have classified each event as a "Sporting Event," "Concert," or "Other Event." You have also classified each event by the attendance at that event as "Poor" (less than 10,000 people in attendance), "Fair" (between 10,000 and 15,000 people in attendance), "Good" (between 15,000 and 20,000 people in attendance), or "Excellent" (more than 20,000 people in attendance). Complete the tasks to build each of the PivotTables described. Make sure you create a new Pivot Table when a task asks you to construct a Pivot Table; place that Pivot Table on an appropriately named worksheet. For each question, select the answer from the drop-down list that is closest to the answer you found in your analysis. PivotTable Questions Question 1 - Which type of event ("Concert," "Sporting Event," or "Other Event") has the largest average attendance? Question 2 - For only those events with "Excellent" crowd sizes, how much total merchandise revenue was earned? Question 3 - What percent of events with "Fair" crowd sizes were sporting events? Question 4-What percent of all concerts had a crowd size of "Excellent"? Question 5 - How much more money from food sales has been generated at concerts than at other events, not including sporting events, for events in the sample? - 1 2 3 Event 4 1123 Fair 5 1125 Good 6 1214 Good 7 1217 Fair 8 1322 Good 9 1416 Fair 10 1419 Excellent 11 1621 Fair 12 1713 Good 13 1716 Good 14 1723 Good 15 1919 Good 16 2119 Fair 17 2317 Good 18 2321 Poor 19 2322 Fair 20 2416 Fair 21 2418 Poor 22 2419 Excellent 23 2523 Fair 24 2524 Excellent 25 2527 Fair 26 2615 27 2620 28 2621 29 2919 30 2921 Good 31 2924 Fair 32 3121 Good Crowd Size Excellent Excellent Poor Excellent Randomly Selected Past Events Attendance 11055 19689 16657 11383 15334 12081 20082 10643 18421 18485 17012 16884 14350 15901 8789 13629 13331 8569 21016 13281 21538 12465 20611 20145 8800 20999 15443 10848 19953 Programs Food $28,190 $76,722 $168,538 $113,409 $74,457 $239,861 $32,100 $181,217 $102,584 $70,191 $106,836 $246,808 $39,486 $139,210 $128,947 $223,078 $63,219 $187,992 $35,045 $204,484 $29,040 $128,318 $35,014 $72,181 $34,187 $221,183 $63,544 $131,659 $59,968 $211,250 $95,583 $161,172 $35,047 $106,084 $56,323 $305,362 $23,109 $113,951 $119,536 $79,153 $176,430 $58,018 $30,096 $97,645 $123,390 $67,149 $91,983 $98,598 $68,620 $129,228 $142,101 $166,125 $234,689 $87,032 $223,639 $237,822 $172,483 $265,774 Merchandise $146,037 $499,116 $351,629 $271,826 $618,267 $407,975 $561,292 $448,070 $615,814 $251,396 $137,967 $695,621 $569,552 $244,557 $103,798 $457,253 $419,527 $117,310 $774,860 $454,210 $987,087 $121,160 $581,642 $283,843 $292,336 $893,927 $177,749 $72,356 $906,265 Type Sporting Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Sporting Event Concert Sporting Event Sporting Event Other Event Concert Concert Sporting Event Other Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Concert Other Event Sporting Event Sporting Event Sporting Event Concert Other Event Other Event Concert 5559 33 3216 Good 34 3920 Poor 35 3922 Excellent 36 4122 Fair 37 4416 Excellent 38 4422 Fair 39 4520 Good 40 4719 Fair 41 4819 Fair 42 4820 Good 43 4919 Fair 44 5114 Good 45 5119 Fair 46 5125 Fair 47 5218 Fair 48 5223 Good 49 5317 Fair 50 5323 Excellent 51 5425 Good 52 5520 Good 53 5619 Good 54 5620 Good 55 5714 Fair 56 5720 Poor 57 5821 Fair 58 5916 Good 59 5927 Fair 60 6216 Poor 61 6423 Fair 62 6522 Fair 63 6619 Poor 64 6625 Excellent 18903 9074 20498 11573 21249 11257 19235 13275 13378 18449 13725 15710 11382 12437 14828 18468 13952 20051 19744 19205 16309 15234 14435 9173 14906 19484 10847 8675 11434 11306 8830 21934 7511550 $147,632 $34,390 $53,705 $87,608 $170,417 $99,624 $25,006 Ye $157,840 $123,769 $304,190 $63,420 $320,010 $150,394 $181,194 $96,775 $206,423 $216,407 $71,233 $217,426 $127,934 $19,382 $13,512 $44,093 $80,291 $41,946 $61,235 $18,656 $125,241 $46,856 $84,520 $71,102 $117,641 $120,406 $113,011 $120,707 $201,312 $138,405 $154,990 $129,826 $273,863 $62,953 $137,159 $116,845 $117,149 $80,980 $41,737 $71,698 $77,741 $27,551 $37,476 $48,709 $64,105 $31,347 $196,529 $200,502 $63,477 $86,008 $198,932 $82,871 $131,947 $74,321 $62,296 $87,770 $133,578 $504,710 $288,281 $565,335 $213,175 $127,919 $413,132 $483,760 $300,679 $526,424 $126,007 $199,562 $238,321 $195,087 $126,236 $661,625 $378,963 $602,308 $555,012 $560,927 $701,367 $492,043 $609,512 $467,550 $309,680 $498,606 $812,678 $285,276 $339,193 $72,949 $77,785 $175,276 $911,138 CUTTECTE Sporting Event Sporting Event Sporting Event Sporting Event Other Event Sporting Event Sporting Event Sporting Event Concert Other Event Sporting Event Sporting Event Sporting Event Other Event Concert Sporting Event Concert Sporting Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Sporting Event Sporting Event Concert Sporting Event Concert Other Event Other Event Sporting Event Concert 65 6627 Fair 66 6712 Good 67 6722 Fair 68 6820 Poor 69 6821 Fair 70 6917 Fair 71 7120 Fair 72 7215 Good 73 7216 Good 74 7320 Fair 75 7618 Good 76 7714 Good 77 7821 Fair 78 7822 Good 79 7919 Fair 80 8213 Fair 81 8216 Good 82 8220 Good 83 8221 Poor 84 8223 Good 85 8319 Fair 86 8418 Good 87 8523 Fair 88 8524 Excellent 89 8815 Fair 90 8823 Fair 91 8914 Excellent 92 8916 Good 93 8921 Good 94 9127 Poor 95 9220 Good 96 9421 Fair 97 9423 Good 11879 19774 10582 8627 13029 13004 12217 18696 16938 13861 15925 18782 12453 19820 14174 11515 16560 16116 9469 17639 12817 17723 13497 21799 13596 11375 21663 18469 16811 8414 15448 13303 17784 $95,270 $90,874 $152,655 $137,232 $10,899 $84,339 $25,191 $99,987 $88,467 $112,571 $54,617 $207,804 $57,176 $157,721 $144,707 $288,479 $18,462 $124,325 $25,920 $188,371 $20,225 $102,398 $30,051 $247,735 $60,646 $109,213 $106,235 $121,695 $69,169 $48,593 $129,830 $100,564 $57,761 $56,092 $21,789 $60,967 $91,375 $66,051 $52,073 $43,111 $158,140 $83,665 $125,746 $53,261 $105,973 $64,520 $157.744 $215,445 $75,193 $136,289 $176,309 $114,291 $135,997 $122,787 $97,122 $70,859 $268,346 $183,002 $81,900 $197,567 $197,249 $96,495 $113,673 $189,701 $89,396 $252.355 $149,913 $817,062 $176,931 $352,499 $488,718 $81,145 $538,037 $364,198 $364,675 $426,503 $162,913 $389,727 $462,878 $696,277 $84,335 $70,357 $620,669 $488,798 $181,994 $543,458 $420,526 $97,831 $491,291 $152,811 $525,078 $282,783 $872,152 $472,437 $383,795 $162,306 $194,645 $112,942 $726.832 Other Event Concert Sporting Event Concert Concert Other Event Concert Sporting Event Sporting Event Sporting Event Other Event Sporting Event Concert Sporting Event Other Event Other Event Concert Sporting Event Sporting Event Sporting Event Sporting Event Other Event Sporting Event Other Event Concert Sporting Event Concert Sporting Event Sporting Event Sporting Event Other Event Other Event Concert 98 9515 Good 99 9520 Good 100 9717 Poor 101 9720 Poor 102 9818 Fair 103 9922 Poor 19791 18932 9893 8276 11471 8100 $48,290 $67,587 $40,363 $23,504 $71,694 $51,516 $252,929 $286,820 $77,363 $59,835 $163,462 $123,444 $390,872 $112,077 $387,113 $279,067 $166,674 $360,774 Sporting Event Other Event Concert Sporting Event Sporting Event Concert
Step by Step Solution
★★★★★
3.46 Rating (162 Votes )
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