Survey
I started off by Planning the things i wanted to find out such
as:
Which of my proposed activities the people asked liked the most.
List
of what i wanted to find out (0225)
I then used that to create my Draft
Questionnaire (0201) which I then tested and asked for Comments
(0221).
I then used those Comments (0221) to create a Final Questionnaire (0222). I checked that my questions were not biased and that they could all be analysed in my spreadsheet, except part of question 3 (the Why? part) as I would not include this in my spread sheet. I would keep the answers to find out why they preferred that option. I also checked that there was enough space to answer questions.
Once I collected the data I entered it into the spreadsheet:
Spreadsheet
Value View (0223) | Spreadsheet Formulae View (0224)
I have found out that:
- That the activity the people surveyed attend in Kingswood is:
Sport.
And that the activity the people surveyed attend out side Kingswood
is also: Sport.
- That overall the people I surveyed voted in favor of the Music
Group/Band (44%) instead of the
Drama Group which got 33% and the Workshops which got 23%.
But i also found out that Males preferred the Workshops but the
females, 11-13's and 14-15's still preferred the music group/band.
- I also found out that 36% of the people asked would be prepared
to spend £3 to £4 followed closely by 30% for the £1.50
to £2.50
option. They least like to pay £4.50 - £5.50 or £6.00 which both
got 10%. Also
males would rather pay: £3 to £4 or £1.50 to £2.50
which both got 26%. And
females would rather pay: £3 to £4 which got a massive
48%.
- I also found out that 36% of the people asked would be prepared
to travel 1 to 2 miles followed closely by 28% for
the option 3 to 5 miles. Also males would rather travel: 1 to
2 miles which got 40%. And females would rather travel 3 to 5
miles which got 35%.
You can see the graphs created here..
(pop up window).