Data and Variables in SPSS from Excel spreadsheet

10 pts.
Tags:
Code
Microsoft Excel
SPSS 20.0
have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable - e.g. - invA, invB, invC, etc. rather than just listing the one inv. Is this correct in that the variables are listed separately for each question? I had already entered the variables and other information on the variable view page, but when I transferred the Excel file to the data page, it entered different variables. Any help with this will be appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: