Need help with this pivot table. Willing to pay if needed. Thank you.

PivotTable Questions Enable Macros to Begin Assignment PT1 PT2 This assignment file relies on a set of macros to handle submission and scoring. Before you may PT3begin the assignment, you must enable macros in this workbook. Depending the version of Excel and the security settings, you may see a prompt similar to those below.PT4 If you have already dismissed the prompt, you may need to close this workbook PT5 it again. and open Past Events 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 event a year. Your company handles all sales made inside the arena. There are three major product groups that 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 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 in attendance), Fair (between 10,000 and 15,000 in attendance), Good (between 15,000 and 20,000 in attendance), or Excellent (more than 20,000 in attendance). Complete the tasks by building each of the PivotTables described. Make sure that you create a new PivotTable when a task as 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? 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 Size were sporting events? Question 4 - What percent of all concerts had a crowd size of \"Excellent\"? Question 5 - How many more dollars in Food sales have been generated at Concerts than Other Events (not including Sporting Events) for Events in the sample? Concert $2 million se sales at etball games, de the arena. You have d your d each event attendance 0 in n 20,000 in ure that you otTable on an wn list that is Crowd Size Data Excellent Type Sum - Event Sum - Attendance Sum - Programs Sum - Food Sum - Merchandise Concert 23401 107150 $628,173 $989,374 $4,439,165 Other Event 12940 43048 $236,468 $588,356 $280,730 Sporting Event 15899 101387 $515,696 $1,153,124 $2,547,124 Total Result 52240 251585 $1,380,336 $2,730,854 $7,267,018 Fair Good Sum - Event Sum - Attendance Sum - Programs Sum - Food Sum - Merchandise Sum - Event 49671 118446 $513,635 $1,177,851 $4,822,689 42249 62618 122365 $609,940 $1,255,154 $969,178 44240 101305 249763 $1,102,298 $2,403,784 $6,694,600 116484 213594 490574 $2,225,873 $4,836,790 $12,486,468 202973 Poor Sum - Attendance Sum - Programs Sum - Food Sum - Merchandise Sum - Event Sum - Attendance 141007 $858,424 $1,334,646 $5,806,905 32675 35295 118932 $457,280 $1,334,754 $1,009,189 2321 8789 379789 $1,800,030 $3,866,849 $9,416,840 48366 70605 639728 $3,115,733 $6,536,250 $16,232,934 83362 114689 Total Sum - Event Total Sum - Attendance Sum - Programs Sum - Food Sum - Merchandise $154,546 $432,741 $1,439,579 $63,544 $131,659 $103,798 $307,143 $755,932 $1,806,250 $525,233 $1,320,333 $3,349,626 147996 122119 282054 552169 401898 293134 801544 1496576 Total Sum - Programs Total Sum - Food Total Sum - Merchandise $2,154,778 $1,367,232 $3,725,166 $7,247,176 $3,934,613 $3,309,923 $8,179,690 $15,424,226 $16,508,338 $2,362,895 $20,464,814 $39,336,047 Randomly Selected Past Events Event 1123 1217 1416 1621 2119 2322 2416 2523 2527 2924 4122 4422 4719 4819 4919 5119 5125 5218 5317 5714 5821 5927 6423 6522 6627 6722 6821 6917 7120 7320 7821 7919 8213 8319 8523 8815 8823 9421 9818 Crowd Size Attendance Fair 11055 Fair 11383 Fair 12081 Fair 10643 Fair 14350 Fair 13629 Fair 13331 Fair 13281 Fair 12465 Fair 10848 Fair 11573 Fair 11257 Fair 13275 Fair 13378 Fair 13725 Fair 11382 Fair 12437 Fair 14828 Fair 13952 Fair 14435 Fair 14906 Fair 10847 Fair 11434 Fair 11306 Fair 11879 Fair 10582 Fair 13029 Fair 13004 Fair 12217 Fair 13861 Fair 12453 Fair 14174 Fair 11515 Fair 12817 Fair 13497 Fair 13596 Fair 11375 Fair 13303 Fair 11471 Programs $28,190 $32,100 $70,191 $39,486 $35,014 $59,968 $95,583 $23,109 $79,153 $67,149 $87,608 $99,624 $19,382 $13,512 $80,291 $61,235 $18,656 $46,856 $120,406 $80,980 $71,698 $27,551 $48,709 $64,105 $95,270 $10,899 $88,467 $54,617 $57,176 $25,920 $60,646 $69,169 $48,593 $21,789 $91,375 $52,073 $43,111 $64,520 $71,694 Food $76,722 $181,217 $68,620 $139,210 $72,181 $211,250 $161,172 $113,951 $142,101 $172,483 $63,420 $150,394 $96,775 $206,423 $71,233 $127,934 $125,241 $84,520 $113,011 $200,502 $86,008 $82,871 $74,321 $62,296 $90,874 $84,339 $112,571 $207,804 $157,721 $188,371 $109,213 $215,445 $75,193 $122,787 $70,859 $183,002 $81,900 $89,396 $163,462 Merchandise $146,037 $271,826 $407,975 $448,070 $569,552 $457,253 $419,527 $454,210 $121,160 $72,356 $213,175 $413,132 $300,679 $526,424 $199,562 $195,087 $126,236 $661,625 $602,308 $467,550 $498,606 $285,276 $72,949 $77,785 $149,913 $176,931 $488,718 $81,145 $538,037 $426,503 $462,878 $84,335 $70,357 $420,526 $491,291 $525,078 $282,783 $112,942 $166,674 Type Sporting Event Sporting Event Sporting Event Concert Concert Sporting Event Sporting Event Sporting Event Other Event Other Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Sporting Event Other Event Concert Concert Sporting Event Sporting Event Sporting Event Other Event Other Event Other Event Sporting Event Concert Other Event Concert Sporting Event Concert Other Event Other Event Sporting Event Sporting Event Concert Sporting Event Other Event Sporting Event 20082 21016 21538 20611 20145 20999 20498 21249 $106,836 $56,323 $119,536 $176,430 $58,018 $97,645 $53,705 $170,417 $120,707 $196,529 $66,051 $158,140 $1,380,336 15334 10643 16884 14350 21016 21538 20999 19953 13378 14828 13952 15234 19484 8675 21934 19774 8627 13029 12217 12453 16560 13596 21663 17784 9893 8100 15458 20051 21934 21799 21663 251585 Sporting Event Sporting Event Sporting Event Concert Concert Sporting Event Sporting Event Sporting Event Other Event Other Event Sporting Event Sporting Event Sporting Event Concert Sporting Event Sporting Event Other Event Concert Concert Sporting Event Sporting Event Sporting Event Other Event Other Event Other Event Sporting Event Concert Other Event Concert Sporting Event Concert Other Event Other Event Sporting Event Sporting Event Concert Sporting Event Other Event Sporting Event 17012 8789 12465 15443 10848 21249 18449 12437 11434 11306 11879 13004 15925 14174 11515 17723 21799 15448 13303 18932 14657 11055 19689 16657 11383 12081 20082 18421 18485 15901 13629 13331 8569 13281 20611 20145 8800 18903 9074 20498 11573 11257 19235 13275 13725 15710 11382 18468 20051 19744 19205 16309 14435 9173 14906 10847 8830 10582 18696 16938 13861 18782 19820 16116 9469 17639 12817 13497 11375 18469 16811 8414 19791 8276 11471 14907