A B C D E F G Randomly Selected Past Events 1 2 3 vent 4 123 5 125 Crowd Size 6 214 7 217 8 322 9 416 10 419 Attendance 11474 20435 17288 11815 15915 12539 20843 11046 19119 19186 17657 17524 14894 Fair Good Good Fair Good Fair Excellent Fair Good Good Good Good Fair Good Poor Fair Fair Poor Excellent Fair Excellent Fair Excellent Excellent Poor Excellent Good Fair Good Good 11 621 12 713 13 716 14 723 15 919 16 119 17 317 18 321 19 322 20 416 21 418 22 419 23 523 24 524 25 527 26 615 27 620 28 621 29 919 30 921 31 924 32 121 33 216 34 920 35 922 36 122 37 416 38 422 39 520 40 719 41 819 42 820 43 919 44 114 45 119 46 125 47 218 48 223 49 317 50 323 16504 9122 14146 13836 8894 21812 13785 22355 12938 21392 20908 9134 21795 16028 11259 2071 19619 9418 21275 12012 22054 11684 19964 13778 Programs $29,259 $174,925 $77,279 $33,317 $106,472 $72,851 $110,886 $40,983 $133,834 $65,615 $36,373 $30,141 $36,341 $35,483 $65,953 $62,240 $99,206 $36,376 $58,457 $23,985 $124,066 $82,152 $183,117 $60,217 $31,237 $ 101,347 $ 128,066 $69,695 $95,469 $153,228 $35,694 $55,740 $90,928 $176,876 $ 103,400 $25,953 $20,116 $14,024 $45,765 $83,335 $43,536 $63,556 $19,362 $48,632 $73,797 $ 124,969 $125,282 $143,651 $134,747 $65,338 $121,273 $84,050 $43,319 $74,415 $80,688 $28,596 $38,896 $50554 Food $79,629 $117,707 $248,951 $188,086 $102,334 $71,220 $256,161 $144,486 $231,533 $195,117 $212,234 $133,182 $74,916 $229,566 $136,649 $219,256 $167,280 $110,105 $316,936 $118,270 $134,126 $147,487 $172,420 $243,583 $90,330 $232,115 $246,836 $179,020 $275,847 $ 163,822 $128,460 $315,719 $65,823 $332,139 $156,093 $188,061 $100,443 $214,246 $224,608 $73,932 $225,667 $132,782 $129,987 $87,723 $ 122,100 $117,294 $208,942 $160,865 $284,243 $142,357 $121,590 $208,101 $65,883 $89,267 $206,471 $86,012 $136,948 $77 137 Merchandise $151,571 $518,032 $364,956 $282,128 $641,700 $423,438 $582,565 $465,052 $639,153 $260,924 $143,196 $721,985 $591,137 $253,826 $107,732 $474,583 $435,426 $121,755 $804,227 $471,425 $1,024,498 $125,752 $603,686 $294,601 $303,416 $927,807 $184,485 $75,098 $940,613 $523,839 $299,207 $586,761 $221,254 $132,767 $428,789 $502,094 $312,074 $546,376 $130,782 $207,125 $247,353 $202,482 $131,020 $686,701 $393,326 $625,135 $576,046 $582,186 $727,948 $510,691 $632,613 $485,270 $321,417 $517,503 $843,478 $296,088 $352,048 $75 713 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 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 Fvent Poor Excellent Fair Excellent Fair Good Fair Fair Good Fair Good Fair Fair 51 425 13885 19148 14245 16306 11814 12909 15390 19168 14481 20811 20492 19933 16927 15811 14982 9521 15471 20223 11258 9004 11867 Fair Good Fair Excellent Good Good Good Good Fair Poor Fair Good Fair Poor 52 520 53 619 54 620 55 714 56 720 57 821 58 916 59 927 60 216 61 423 Fair B D E F G Fair Excellent Good Good Good Good Fair Poor Fair Good Fair Poor Fair Fair Poor Excellent Fair Good Fair Poor 49 317 50 323 51 125 52 520 53 519 54 520 55 714 56 720 57 321 58 916 59 527 60 216 61 123 62 522 63 519 64 525 65 527 66 712 67 722 68 320 69 321 70 217 71 120 72 215 73 216 74 320 75 518 76 714 77 321 78 322 79 919 80 215 81 216 82 220 83 221 84 223 85 319 86 118 87 523 88 524 89 315 90 323 91 914 92 916 93 21 94 127 95 220 96 121 97 123 98 515 99 520 100 717 101 720 102 318 103 22 104 105 106 Fair Fair Fair Good Good Fair Good Good Fair Good Fair Fair Good Good Poor Good Fair Good Fair Excellent Fair 14481 20811 20492 19933 16927 15811 14982 9521 15471 20223 11258 9004 11867 11734 9165 22765 12330 20523 10983 8954 13523 13497 12680 19405 17580 14386 16529 19494 12925 20571 14711 1951 17187 16727 9828 18308 13303 18395 14009 22625 14112 11806 22484 19169 17448 8733 16033 13807 18458 20541 19649 10268 8589 11906 8407 $124,969 $125,282 $143,651 $134,747 $65,338 $121,273 $ 84,050 $43,319 $74,415 $80,688 $28,596 $38,896 $50,554 $66,534 $32,535 $203,977 $98,880 $158,441 $11,312 $26,145 $91,820 $56,687 $59,343 $150,192 $19,162 $26,902 $20,991 $31,190 $62,944 $110,262 $71,791 $50,435 $134,751 $104,375 $59,950 $58,217 $22,615 $63,278 $94,838 $68,555 $54,046 $44,745 $164,134 $86,835 $130,513 $55,279 $109,989 $66,965 $163,722 $50,120 $ 70,148 $41,893 $24,395 $74,411 $53,468 $117,294 $208,942 $160,865 $284,243 $142,357 $121,590 $208,101 $65,883 $89,267 $206,471 $86,012 $136,948 $77,137 $64,657 $91,097 $138,641 $94,319 $142,433 $87,535 $ 103,776 $116,837 $215,680 $163,699 $299,413 $129,037 $195,510 $106,279 $257,124 $113,352 $126,307 $223,610 $78,042 $141,454 $182,991 $ 118,622 $141,151 $127,441 $100,803 $73,544 $278,516 $189,938 $85,004 $ 205,054 $204,724 $100,153 $117,981 $196,892 $92,784 $261,919 $262,515 $297,690 $80,296 $62,103 $169,657 $128,122 $625,135 $576,046 $582,186 $727,948 $510,691 $632,613 $485,270 $321,417 $517,503 $843,478 $296,088 $352,048 $75,713 $80,733 $ 181,919 $945,670 $ 155,595 $848,028 $183,637 $365,859 $507,240 $84,220 $558,428 $378,001 $378,496 $442,667 $169,087 $404,497 $480,421 $722,666 $87,532 $73,024 $644,193 $507,324 $ 188,892 $564,055 $436,464 $ 101,539 $509,911 $ 158,603 $544,978 $293,500 $905,207 $490,343 $398,341 $168,457 $202,022 $117,223 $754,379 $405,686 $116,325 $401,785 $289,643 $172,991 $374,447 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 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 Sporting Event Other Event Concert Sporting Event Sporting Event Concert Fair Excellent Good Good Poor Good Fair Good Good Good Poor Poor Fair Poor , 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, Fair, Good, or Excellent. Complete the tasks to build each of the PivotTables described. Make sure you create a new PivotTable when a task asks you to construct a PivotTable; and place that PivotTable 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? Ques 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