7/31/2019 OP Trip Statistics Analysis 2011-2012

1/3

Analysis of Trip Statistics: 2011-2012Created by: Keith Crawford

IntroductionThe purpose of this document is to examine, objectively, which trips ran in the 2010-2011 school

year and then to break that down a bit further based on several different factors. Hopefully this will allowtrip leaders and professional staff to make more informed decisions as they plan future trips. It was also a

good excuse for Keith to geek out with SPSS.

MethodsThis information was gathered from the trip sign-up forms for each semester and compiled into

SPSS 20. Cost per day was calculated using the early bird student price and the number of days wasbased only on full days (if a trip left on Friday at 5pm that was still considered 1 day). The Beginner-oriented variable was determined subjectively through the researchers knowledge of these trips.

Results

How Many Trips Ran? As you can see below, 37 out of 48 trips ran (77.1%).

# %

Did not Run 11 22.9

Did Run 37 77.1

Total 48 100

How Many Trips Were Completely Filled (at max capacity)? 54.2% (26) of our trips were completely

full.

# %

Not Full 22 45.8

Full 26 54.2

Total 48 100.0

7/31/2019 OP Trip Statistics Analysis 2011-2012

2/3

How Much Did Trips Cost (per day)? Most trips (33.3%) were between 31 and 40 dollars per day.

Yellow = top 3 in frequency/percentage.

Cost Range in Dollars, per day # %

0-10 5 10.4

11-20 2 4.2

21-30 7 14.6

31-40 16 33.3

31-50 1 2.1

40 1 2.1

41-50 4 8.3

51-60 9 18.8

61-70 1 2.1

n/a 2 4.2

Total 48 100.0

How Many of Our Trips Were Beginner Oriented? 64.6% (31) of our trips were beginner oriented.

# %

Not Beginner 17 35.4

Beginner 31 64.6

Total 48 100.0

Now, lets dig a bit deeper and try to decipher what MAY have caused trips to fill or not fill.

Are B eginner Trips More Likely to Fill? 9 out of 17 (52.9%) not beginner-oriented trips ran, and 28out of 31(90.32%) beginner-oriented trips ran. Another way to look at this data, 8 out of the 11 (or72.72%) of the trips that did NOT run were NOT beginner-oriented.

Also note, of the 26 trips that completely filled, 20 (76.9%) were beginner-oriented. (No table for this)

So, according to this data, yes, beginner trips are more likely to fill.

Not Beginner-Oriented Beginner-Oriented Total

Did Not Run 8 3 11

Ran 9 28 37

Total 17 31 48

7/31/2019 OP Trip Statistics Analysis 2011-2012

3/3

Are Cheaper Trips More Likely to Fill? This data seems to be a bit less clear. It seems that people

may be willing to be for the higher cost trips, if they are appealing. For example, only 1 trip cost more

than $60 (per day) and it did run (and completely fill within hours of being posted), however 33.3%

percent of the 51-$60 (per day) trips did not run.

0-10 11-20 21-30 31-40 41-50 51-60 61-70

Did Not Run 0 1 3 2 1 3 0

Ran 5 1 4 16 3 6 1

Total 5 2 7 18 4 9 1

ConclusionsFirst, the conclusions drawn from this data are not ways to guarantee trips will fill. Some very

important factors (such as timing within a semester, amount and types of marketing, etc.) were not takeninto account. With the following statement in mind, here are some conclusions that may be drawn fromthis data:

Beginner trips are very popular (note from researcher: especially when marketed well and timedappropriately) and will likely completely fill.

Cost per day does not seem to be an overarching factor, students may be willing to pay if theproduct is worth it.

OP did a good job of filling trips in 2011-2012. The researcher believes that using theinformation contained in this document to coach students when creating trip proposals could

lead to over 90% of trips being filled in the future.