Pls i need help. I have and excel file containing data of 150 respondents. Each of which reponded to 8 questions. Also they choose from either '' yes'' '' no'' or '' i do not know''
Pls all i want is how i can use SPSS to determine how many respondents got all 8 questions correctly, how many score 7 over 8, or 6 over 8 and so on. Pls if u know how pls help me out. Givr mr the steps to follow. its really urgent.

can't you just use Excel? I don't think SPSS is the answer to your queries.

SPSS answers your questions but then again, why do you want to export from excel to SPSS again?

A using ecel cos am running other analysis. Pls hw can i use excel?

@dorox10

Could not set up a tutorial so i got you two relevant links. Take a look at these two tutorials and complement with SPSS bundled help:

1. Import excel into SPSS Import Excel into SPSS

2. Scoring multiple choice questions in SPSS Score multi choice questions in SPSS

The second link has applicable code which is clarified in the comments section.

Doing same in Excel will require the use of string functions or writing VBA code. The choice is yours. However, based on the size of your data i may suggest excel. but if further statistical analysis of the data may be required, or you may need to add more data, then SPSS may be a more better choice.

Best wishes.