For this excesise show all the excel formulas of the Pivot Tables generated. The
ID: 3325307 • Letter: F
Question
For this excesise show all the excel formulas of the Pivot Tables generated. The "Past Events" table has been added.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 products that you sell: programs, food, and merchandise. In this excersice, please show the excel formulas of the Pivot Tables generated. The 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 appriopriately named worksheet. For each question select the answer from the drop-down list that is closest to the answer you found in your analysis.
Concert
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?Explanation / Answer
Answer
Question 1 - Which type of event (Concert, Sporting Event, or Other Event) has the largest average attendance?
Pivot Table :
Row Labels
Average of Attendance
Concert
15457.61538
Other Event
14656.7
Sporting Event
14843.40741
Grand Total
14965.76
Hence Highest average attendance is for Concert Type of Event
Question 2 – For only those events with “Excellent” crowd sizes, how much total merchandise revenue was earned?
Pivot Table
Row Labels
Sum of Merchandise
Excellent
7267018
Fair
12486471
Good
16232935
Poor
3349627
Grand Total
39336051
Hence merchandise revenue earned for events with excellent crowd sized is 7267018
Question 3 – What percent of events with “Fair” Crowd Size were sporting events?
Pivot Table :
Count of Event
Column Labels
Row Labels
Concert
Other Event
Sporting Event
Grand Total
Excellent
5
2
5
12
Fair
9
10
20
39
Good
8
7
21
36
Poor
4
1
8
13
Grand Total
26
20
54
100
Total number of events with Fair crowd size : 39 , out of those number of sporting events are 20.
Hence percent of sporting event in fair crowd size events are (20/39)*100 = 51.28%
Question 4 – What percent of all concerts had a crowd size of “Excellent”?
Answer
Pivot
Row Labels
Concert
Other Event
Sporting Event
Grand Total
Excellent
5
2
5
12
Fair
9
10
20
39
Good
8
7
21
36
Poor
4
1
8
13
Grand Total
26
20
54
100
Total No of Concers 26 . Out of those 5 got excellent crowd size.
Hence percent of all concerts had a crowd size of “Excellent” is (5/26)*100 =19.23%
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?
Pivot
Row Labels
Sum of Food
Concert
3934614
Other Event
3309923
Sporting Event
8179691
Grand Total
15424228
Dollars generated in Concert= 3934614 Dollars generated in other event = 3309923
Hence 624691 (3934614-3309923) more dollars in Food sales have been generated at Concerts than Other Events (not including Sporting Events) for Events in the sample
Row Labels
Average of Attendance
Concert
15457.61538
Other Event
14656.7
Sporting Event
14843.40741
Grand Total
14965.76
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.