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,...

PIVOT

Extracted text: 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 PivotTable when a task asks you to construct a PivotTable; 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 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?