Thursday, February 26, 2015

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


TypeRankInstrumentCountAverage
All PB1Tuba15312.02
Avg2Trumpet2829.06
8.473Piccolo2608.93
4Trombone1368.55
5Mellophone1208.40
6Tenor Sax1208.22
7Clarinet1588.01
8Alto Sax2067.51
9Drumline1827.39
10Baritone586.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:

TypeRankInstrumentCountAverageTypeRankInstrumentCountAverage
Fall1Tuba976.93Spring1Tuba565.09
Avg2Trumpet1875.67Avg2Piccolo1103.93
5.033Trombone925.413.443Mellophone433.58
4Piccolo1505.004Trumpet953.39
5Tenor Sax744.935Clarinet613.39
6Mellophone774.816Tenor Sax463.29
7Baritone424.677Alto Sax773.21
8Clarinet974.628Trombone443.14
9Drumline1214.489Drumline612.90
10Alto Sax1294.3010Baritone162.29

I went ahead and looked at break games too:

TypeRankInstrumentCountAverage
Break1Tuba634.50
Avg2Trombone553.24
2.833Trumpet1053.18
4Drumline853.15
5Piccolo943.13
6Clarinet643.05
7Alto Sax722.40
8Tenor Sax302.00
9Baritone121.33
10Mellophone211.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:

TypeRankInstrumentCountAverage
All1Tuba21616.52
Avg2Trumpet38712.24
10.743Piccolo35412.06
4Trombone19111.79
5Clarinet22211.06
6Drumline26710.53
7Tenor Sax15010.22
8Alto Sax2789.91
9Mellophone1419.71
10Baritone708.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:


Instrument1st2nd3rd
Tuba901
Trumpet141
Piccolo022
Trombone005
Clarinet0.510
Drumline010
Tenor Sax011
Alto Sax000.5
Mellophone0.520.5
Baritone101
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:

KeyTypeDescription
WSFallWomen's Soccer
MSFallMen's Soccer
VBFallVolleyball
FHFallField Hockey
WBBothWomen's Basketball (Fall/Spring only)
MBBBreakMen's Basketball
WBBBreakWomen's Basketball (Break only)
BALLSpringSoftball
GYMSpringGymnastics
MLAXSpringMen's Lacrosse
WLAXSpringWomen's Lacrosse

FallSpring
TypeRankInstrumentCountAverageTypeRankInstrumentCountAverage
WS1Trumpet260.79WB1Tuba161.45
Avg2Tenor Sax110.73Avg2Piccolo331.18
0.613Tuba100.710.953Alto Sax241.00
4Trombone120.713Trombone141.00
5Baritone60.675Tenor Sax130.93
6Piccolo170.576Mellophone110.92
7Mellophone90.567Trumpet250.89
8Alto Sax160.538Clarinet150.83
9Drumline130.489Drumline140.67
10Clarinet100.4810Baritone40.57
TypeRankInstrumentCountAverageTypeRankInstrumentCountAverage
MS1Baritone80.89BALL1Tuba121.09
Avg2Mellophone140.88Avg2Clarinet170.94
0.683Trombone140.820.713Piccolo230.82
4Trumpet260.794Tenor Sax100.71
5Tuba110.794Trumpet200.71
6Clarinet140.676Mellophone80.67
7Piccolo190.637Trombone90.64
8Tenor Sax90.608Alto Sax140.58
9Alto Sax170.579Drumline110.52
10Drumline130.4810Baritone20.29
TypeRankInstrumentCountAverageTypeRankInstrumentCountAverage
VB1Tuba231.64GYM1Clarinet120.67
Avg2Piccolo421.40Avg1Mellophone80.67
1.223Trumpet411.240.583Piccolo180.64
4Baritone111.223Tenor Sax90.64
5Tenor Sax181.205Drumline130.62
6Mellophone191.196Baritone40.57
7Trombone201.187Tuba60.55
8Alto Sax351.178Alto Sax120.50
9Clarinet231.108Trumpet140.50
10Drumline271.0010Trombone60.43
TypeRankInstrumentCountAverageTypeRankInstrumentCountAverage
FH1Tuba201.43MLAX1Tuba90.82
Avg2Trumpet341.03Avg2Mellophone80.67
0.933Mellophone161.000.493Piccolo180.64
3Trombone171.003Tenor Sax90.64
5Piccolo280.935Trombone60.43
5Tenor Sax140.935Drumline90.43
7Drumline240.897Alto Sax100.42
8Alto Sax230.778Clarinet70.39
9Clarinet160.769Trumpet100.36
10Baritone60.6710Baritone10.14
TypeRankInstrumentCountAverageTypeRankInstrumentCountAverage
WB1Tuba332.36WLAX1Tuba131.18
Avg2Trumpet601.82Avg2Trumpet260.93
1.583Trombone291.710.713Baritone50.71
4Drumline441.634Alto Sax170.71
5Clarinet341.625Mellophone80.67
6Piccolo441.475Drumline140.67
6Tenor Sax221.477Piccolo180.64
8Alto Sax381.277Trombone90.64
9Baritone111.229Clarinet100.56
10Mellophone191.1910Tenor Sax50.36
Break
TypeRankInstrumentCountAverage
MBB1Tuba493.50
Avg2Drumline722.67
2.253Trombone432.53
4Piccolo732.43
5Clarinet512.43
6Trumpet802.42
7Alto Sax561.87
8Tenor Sax241.60
9Baritone121.33
10Mellophone181.13
TypeRankInstrumentCountAverage
WBB1Tuba141.00
Avg2Trumpet250.76
0.583Trombone120.71
4Piccolo210.70
5Clarinet130.62
6Alto Sax160.53
7Drumline130.48
8Tenor Sax60.40
9Mellophone30.19
10Baritone00.00

No comments:

Post a Comment