How can I organise my data on Excel from a paper-based survey questionnaire with likert scale, close ended, ranking and multiple choice questions?

its better to use SPSS to organize your data because your conceptual framework can be analyzed in SPSS. you cant use excel to get your required results.

 Hello Naveed, 

This is the first quantitative research I am conducting and planning to use Analysis ToolPak on Excel, I haven't use SPSS.

 Is there any reason I wouldn't get results using this tool?  

you are developing regression based model in your research thats why SPSS is more convenient. Its not so much difficul. You can watch some videos on youtube like SPSS for beginners.

if you still face difficulty, i can help you to insert data for you and make a SPSS based template file

Hi, I can help if you develop Excel sheet for your questionnaire data but I need to know which questionnaires you are using and what are the measurement level (nominal, ordinal or ratio/interval) of the variables. In fact I have many templates which I used in my own Master thesis but will need to be modified a bit to suit your need.

Hello Naveed, 

Thank you so much for your help, I'm not considering regression model.

Hello Arif, 

Thank you, the templates would be really helpful! I will classify questions in terms of their level of measurement.

Hi Tamara, I got your survey but I need to know about your hypotheses or questions this survey is going to answer. If you have research questions or hypotheses, then please do share them with me so that we can organize the data in a way that can be analyzed to answer your questions or test hypotheses appropriately. If it is merely a descriptibe study, then its ok but if hypotheses testing,we will have to modify the data slightly without data loss.

Hi All,

I was wondering if anyone from you would be kind enough to help me on entering the data from pretty much same pattern of questionnaire ?

Regards

Saria