exciting findings

26 01 2010

total # of bike commuters vs. non bike commuters

I’ve been using excel as a tool to better understand my survey data and here are a few hard facts–check out these graphs to the right. I must first admit—this information is REALLY REALLY exciting! Ok–so…Of my total population of 686 people surveyed (note; there were a total of 726 responses to the survey however data from 40 responder was eliminated due to incomplete data rendering it useless)60% of respondents were cycling commuters. 40% were not. This is represented in the purple graph.

breakdown of non commuters

I then wanted to breakout the non commuters to understand whether those people had ever considered riding. This is represented by the green graph. As you can see, I looked at people who owned bikes, and those who didn’t own bikes–this may provide some context for why some didn’t commute via bike. If you look closely, you can see that a total of 33% of non commuters were bike owners. I broke this out to see, of those bike owning, non bike commuters, which ones have ever considered riding to campus. 23% have considered.

The question is: what is stopping them? If you total up, of the 40% of non cycling commuters to Pratt, 59% of those responders have considered riding to campus (36% of non bike owners + the 23% of bike owners). With just this little bit of data, we can conclude from this information that there is huge potential for increasing bike use on the Pratt campus. 59% of the non commuters–that’s huge!

Now what…? More survey analysis! Who knew I could love excel so much?





and the survey says…

20 10 2009

Excerpt from preliminary survey results

Excerpt from preliminary survey results

…A lot! There has been a total of 674 people respond (as of midnight last night) to the survey. I’m not totally sure yet but I

Excerpt from preliminary survey results

believe that is about a 14% to 15% response rate. To the left is some of the raw data to date. I’m now working on ways to get the survey results in in a presentable format. I am also at the point where I HAVE to get a website together to begin pulling this all of this together. The survey ends on Friday though I believe I have received most of my responses. It is my hope that next week I can begin telling students about the results…somehow. I have sent out a MEMO to EC, ER, DJ, DrA, and WS and have not had any response as of yet. The MEMO included an invitation to the Nov. 5th Design Jam which is in still in the basic planning stage. It has been a real challenge bringing all stakeholders to one table. I have yet to succeed though people are thinking/talking about it. It seems that the best way to communicate is via email however I am finding this form of communication to be limiting.

I am struggling with coordinating everything correctly, making sure all stakeholders are included while also trying to continue moving the project forward. CJ has given me the names of a few people/students to reach out to and have yet to have the time. I hope to do that today. It is clear that there is a strong interest from students on the issues presented in the survey however, what is critical now is getting the information in a form to begin making formal recommendations to the administration. I hope to be able to do this after the Design Jam though without their participation in the Jam, I’m not sure how comprehensive my recommendations will be. Their feedback is crucial. I’m considering moving forward with the Jam preparations invitations this week regardless and seeing what sort of feedback receive from all parties.

I need to get CW back in the game from SGA as he is an important ally. I’m preparing for a meeting with CJ to go over the survey results and hopefully he can provide me with advice on moving forward and keeping the momentum going. After that–I will reach back out to CW to give him an update and see how we can begin working together on the Jam. Maybe another meeting with DrA is necessary? I’m not sure… I will also be sending out a follow-up to my MEMO today (exactly one week after the first email was sent). Should I not receive a response, I may need to change gears a bit…





PSA…now i need to get the survey out

6 10 2009

There needs to be a big push of momentum to get people to begin recognizing that something is going on around biking on campus. I’m hoping this survey will help get the word out. Things have been pushed back a few weeks but the time it is giving me is allowing me to get all my ducks in a line (I think I’ve just always wanted to say that phrase–even if it makes no sense here)… And now—our very own Public Service Announcement. ¬†Thanks BC! TO, you’re fantastic! Thanks for being an awesome sport and lending your acting abilities.





draft usage survey

23 09 2009

Draft Usage Survey

Draft Usage Survey