Summary Statistics and Splits for Pep Bands Attendance for Each Section

Immediate disclaimer: the following conclusions are drawn from the data from the 2013-14 school year.

The ultimate goal of analyzing this pep band data is to determine the number of times the average Marching Tar Heel plays TAG (UNC's fight song) throughout their college career. I've been sampling all sporting events that the band has performed at that I've been to this year (so far, 36), and only need the figures from a softball gig to complete those findings.

But first, using the scanner data from 2013-14, I can generate some summary statistics and splits (breakdowns by section and gig type) for the volunteer rates for each type of pep band gig by calculating the average number of gigs a player goes to.

Overall, the average marching band member attended 8.47 gigs between fall and spring, which results in a rate of 0.47 volunteer gigs over the course of year (since 8 were required: 5 in fall and 3 in spring).
Note: the 4th gig in the spring is the spring football game, which is not included since the entire band performs at it.

What about only those who volunteer for more than their required gigs? The average "volunteer" went to 11.53 gigs over the course of the year, meaning I only tallied those who went to more than 5 in the fall and/or more than 3 in the spring. So, these volunteers attended an extra 3.53 gigs each.

The ultimate question is which section volunteers the most? I determined this based on how many gigs the average player in each section went to, and the Tubas come in first - by a wide margin. The average tuba player went to 12.02 pep band gigs, which is more than the average "volunteer".

Type	Rank	Instrument	Count	Average
All PB	1	Tuba	153	12.02
Avg	2	Trumpet	282	9.06
8.47	3	Piccolo	260	8.93
	4	Trombone	136	8.55
	5	Mellophone	120	8.40
	6	Tenor Sax	120	8.22
	7	Clarinet	158	8.01
	8	Alto Sax	206	7.51
	9	Drumline	182	7.39
	10	Baritone	58	6.95

One point worth mentioning is that the smaller the section, the more the effects of outliers are heightened. For example, in the case of the tubas, only a handful of players have to volunteer frequently to greatly change the average (in this case, 5-6, which is half the section). In the fall and spring the tubas remain on top, but some of the rankings in the middle change:

Type	Rank	Instrument	Count	Average		Type	Rank	Instrument	Count	Average
Fall	1	Tuba	97	6.93		Spring	1	Tuba	56	5.09
Avg	2	Trumpet	187	5.67		Avg	2	Piccolo	110	3.93
5.03	3	Trombone	92	5.41		3.44	3	Mellophone	43	3.58
	4	Piccolo	150	5.00			4	Trumpet	95	3.39
	5	Tenor Sax	74	4.93			5	Clarinet	61	3.39
	6	Mellophone	77	4.81			6	Tenor Sax	46	3.29
	7	Baritone	42	4.67			7	Alto Sax	77	3.21
	8	Clarinet	97	4.62			8	Trombone	44	3.14
	9	Drumline	121	4.48			9	Drumline	61	2.90
	10	Alto Sax	129	4.30			10	Baritone	16	2.29

I went ahead and looked at break games too:

Type	Rank	Instrument	Count	Average
Break	1	Tuba	63	4.50
Avg	2	Trombone	55	3.24
2.83	3	Trumpet	105	3.18
	4	Drumline	85	3.15
	5	Piccolo	94	3.13
	6	Clarinet	64	3.05
	7	Alto Sax	72	2.40
	8	Tenor Sax	30	2.00
	9	Baritone	12	1.33
	10	Mellophone	21	1.31

Note: In 2013-14, there were extra break game opportunities, since all men's basketball games during the fall semester were volunteer.

This brings us to these final totals for all break games plus fall and spring pep bands:

Type	Rank	Instrument	Count	Average
All	1	Tuba	216	16.52
Avg	2	Trumpet	387	12.24
10.74	3	Piccolo	354	12.06
	4	Trombone	191	11.79
	5	Clarinet	222	11.06
	6	Drumline	267	10.53
	7	Tenor Sax	150	10.22
	8	Alto Sax	278	9.91
	9	Mellophone	141	9.71
	10	Baritone	70	8.29

Each section in the band has their own strengths regarding attendance at the different types of gigs. The following table shows the number of times each section ranks 1st/2nd/3rd over all the different types of gigs:

Instrument	1st	2nd	3rd
Tuba	9	0	1
Trumpet	1	4	1
Piccolo	0	2	2
Trombone	0	0	5
Clarinet	0.5	1	0
Drumline	0	1	0
Tenor Sax	0	1	1
Alto Sax	0	0	0.5
Mellophone	0.5	2	0.5
Baritone	1	0	1
0.5 in case of tie

Finally, here the splits for every section for every type of pep band gig, both for fall and spring:

Key	Type	Description
WS	Fall	Women's Soccer
MS	Fall	Men's Soccer
VB	Fall	Volleyball
FH	Fall	Field Hockey
WB	Both	Women's Basketball (Fall/Spring only)
MBB	Break	Men's Basketball
WBB	Break	Women's Basketball (Break only)
BALL	Spring	Softball
GYM	Spring	Gymnastics
MLAX	Spring	Men's Lacrosse
WLAX	Spring	Women's Lacrosse

Fall						Spring
Type	Rank	Instrument	Count	Average		Type	Rank	Instrument	Count	Average
WS	1	Trumpet	26	0.79		WB	1	Tuba	16	1.45
Avg	2	Tenor Sax	11	0.73		Avg	2	Piccolo	33	1.18
0.61	3	Tuba	10	0.71		0.95	3	Alto Sax	24	1.00
	4	Trombone	12	0.71			3	Trombone	14	1.00
	5	Baritone	6	0.67			5	Tenor Sax	13	0.93
	6	Piccolo	17	0.57			6	Mellophone	11	0.92
	7	Mellophone	9	0.56			7	Trumpet	25	0.89
	8	Alto Sax	16	0.53			8	Clarinet	15	0.83
	9	Drumline	13	0.48			9	Drumline	14	0.67
	10	Clarinet	10	0.48			10	Baritone	4	0.57
Type	Rank	Instrument	Count	Average		Type	Rank	Instrument	Count	Average
MS	1	Baritone	8	0.89		BALL	1	Tuba	12	1.09
Avg	2	Mellophone	14	0.88		Avg	2	Clarinet	17	0.94
0.68	3	Trombone	14	0.82		0.71	3	Piccolo	23	0.82
	4	Trumpet	26	0.79			4	Tenor Sax	10	0.71
	5	Tuba	11	0.79			4	Trumpet	20	0.71
	6	Clarinet	14	0.67			6	Mellophone	8	0.67
	7	Piccolo	19	0.63			7	Trombone	9	0.64
	8	Tenor Sax	9	0.60			8	Alto Sax	14	0.58
	9	Alto Sax	17	0.57			9	Drumline	11	0.52
	10	Drumline	13	0.48			10	Baritone	2	0.29
Type	Rank	Instrument	Count	Average		Type	Rank	Instrument	Count	Average
VB	1	Tuba	23	1.64		GYM	1	Clarinet	12	0.67
Avg	2	Piccolo	42	1.40		Avg	1	Mellophone	8	0.67
1.22	3	Trumpet	41	1.24		0.58	3	Piccolo	18	0.64
	4	Baritone	11	1.22			3	Tenor Sax	9	0.64
	5	Tenor Sax	18	1.20			5	Drumline	13	0.62
	6	Mellophone	19	1.19			6	Baritone	4	0.57
	7	Trombone	20	1.18			7	Tuba	6	0.55
	8	Alto Sax	35	1.17			8	Alto Sax	12	0.50
	9	Clarinet	23	1.10			8	Trumpet	14	0.50
	10	Drumline	27	1.00			10	Trombone	6	0.43
Type	Rank	Instrument	Count	Average		Type	Rank	Instrument	Count	Average
FH	1	Tuba	20	1.43		MLAX	1	Tuba	9	0.82
Avg	2	Trumpet	34	1.03		Avg	2	Mellophone	8	0.67
0.93	3	Mellophone	16	1.00		0.49	3	Piccolo	18	0.64
	3	Trombone	17	1.00			3	Tenor Sax	9	0.64
	5	Piccolo	28	0.93			5	Trombone	6	0.43
	5	Tenor Sax	14	0.93			5	Drumline	9	0.43
	7	Drumline	24	0.89			7	Alto Sax	10	0.42
	8	Alto Sax	23	0.77			8	Clarinet	7	0.39
	9	Clarinet	16	0.76			9	Trumpet	10	0.36
	10	Baritone	6	0.67			10	Baritone	1	0.14
Type	Rank	Instrument	Count	Average		Type	Rank	Instrument	Count	Average
WB	1	Tuba	33	2.36		WLAX	1	Tuba	13	1.18
Avg	2	Trumpet	60	1.82		Avg	2	Trumpet	26	0.93
1.58	3	Trombone	29	1.71		0.71	3	Baritone	5	0.71
	4	Drumline	44	1.63			4	Alto Sax	17	0.71
	5	Clarinet	34	1.62			5	Mellophone	8	0.67
	6	Piccolo	44	1.47			5	Drumline	14	0.67
	6	Tenor Sax	22	1.47			7	Piccolo	18	0.64
	8	Alto Sax	38	1.27			7	Trombone	9	0.64
	9	Baritone	11	1.22			9	Clarinet	10	0.56
	10	Mellophone	19	1.19			10	Tenor Sax	5	0.36
Break
Type	Rank	Instrument	Count	Average
MBB	1	Tuba	49	3.50
Avg	2	Drumline	72	2.67
2.25	3	Trombone	43	2.53
	4	Piccolo	73	2.43
	5	Clarinet	51	2.43
	6	Trumpet	80	2.42
	7	Alto Sax	56	1.87
	8	Tenor Sax	24	1.60
	9	Baritone	12	1.33
	10	Mellophone	18	1.13
Type	Rank	Instrument	Count	Average
WBB	1	Tuba	14	1.00
Avg	2	Trumpet	25	0.76
0.58	3	Trombone	12	0.71
	4	Piccolo	21	0.70
	5	Clarinet	13	0.62
	6	Alto Sax	16	0.53
	7	Drumline	13	0.48
	8	Tenor Sax	6	0.40
	9	Mellophone	3	0.19
	10	Baritone	0	0.00