Questionnaire Analysis Process 1 - Setting up

In order for me to analyse my questionnaire I had to use some kind of software to help me to this, so I used Microsoft Excel to assist me. I have chosen Microsoft Excel because there are options to control the type of data or the values that users enter into a cell. So for the qualitative data I collected from my questionnaire, I needed to restrict data entry to a certain range of dates, and limit choices by using a list. This software helped me make pie charts to analyse these. I have uploaded some photos of my procedures.

This screenshot shows how I inserted the data listed in the bottom half of the picture into where the table is by using data validation. 

This screenshot shows how I used the "countif(...)" code to add up all the 'male' answers in this column, continuing to do so with all the other results.

In this screenshot, you can see a vital detail change, which includes the "male" after square number as that will add up all the results which are entered as "male" otherwise it would enter any results entered. I will continue doing this for the rest of the grid.

This screenshot shows that I entered all the data, just have to find 15 people to answer the questions and fill in the results.