Create a survey
Things to do
Produce a questionnaire using word . Include a series of questions with multiple choice answers e.g.
- Do you want a funday? Yes/ No/ Not bothered
- What is the best day?Mon/ Tues/ Wed/ Thurs/ Fri/ Sat/ Sun
- What time of day? 9 am/ 10 am/ 11 am/ 12 am/ 13 pm/ 14 pm
- What activities would you like?
- How long do you want it to last? 2,3,4,5 hours
Create a tally sheet for results
Interpret the results
Give the questionnaires out and when returned analyse data e.g.
Day |
Number of choices |
Monday |
3 |
Tuesday |
2 |
Wednesday |
4 |
Thursday |
5 |
Friday |
10 |
Saturday |
2 |
Sunday |
3 |
Create graphs using excel- select and justify which graph details the information clearer.
e.g. bar chart, scatter graph, line graph
Interpret the results into percentages.
AON Work with and convert between fractions, decimals and percentages
E.g 10/29 x 100=34 % wanted Friday
5/29 x100=17% wanted Thursday
80% said yes to a Funday 15 % weren’t bothered, 5% said no
Copy and paste into powerpoint and comment on data.
Use the data to work out the mean, mode and median.
Median
The median number of choices
2,2,3,3,4,5,10- 2,3,4,5,10 median = 4
Mode
e.g.The most commonly chosen day is Friday with 10 choices
Time of day to start |
Choices |
|
|
9 |
5 |
9x5 |
45 |
10 |
3 |
10x3 |
30 |
11 |
4 |
11x4 |
44 |
12 |
5 |
12x5 |
60 |
13 |
8 |
13x8 |
104 |
14 |
4 |
14x4 |
56 |
Total |
|
|
339 |
Mean
The mean starting time was
339/(5+3+4+5+8+4=29)=11.68 so a wanted mean start time of around 11.45am.
Mode
9,9,9,9,9,10,10,10,11,11,11,11,12,12,12,12,12,13,13,13,13,13,13,13,13,14,14,14,14,
Mode is 13 i.e.most common