How To Input Data Into Spss From Questionnaire

Download Commodity

Download Article

SPSS is a statistical analysis program that is used in a diverseness of fields, from market researchers to government agencies. Information technology allows you to perform a variety of functions on your information, but you need data before yous can exercise any of that. At that place are several ways to enter information into SPSS, from entering information technology manually to importing information technology from another file.

ane
Define your variables. In gild to enter data using SPSS, you need to have some variables. These are the columns of the spreadsheet when using "Data View", and each 1 will contain information that is still format.
- To define your variables, double-click a column heading "Data View" A carte du jour will appear, allowing you to ascertain the variable.
- When entering a variable Name, it must begin with a letter and capitalization is ignored.
- When choosing the Blazon, you tin choose between "String" (characters) and a diversity of numerical formats.
- See this guide for more than details on defining variables.
2
Create a multiple choice variable. If you are defining a variable that has two or more ready possibilities, you can set labels for the values. For instance, if ane of your variables is whether or non an employee is active, your merely 2 options for that variable might be "Active" and "Erstwhile".^[1]
- Open the Labels section of the Define Variable menu, and create a numbered value for each possibility (e.1000. "ane", "two", etc.).
- For each value, give it a corresponding label (e.m. "Agile", "Former").
- When you enter in the information for that variable, you only take to type "1" or "2" to select the option you want.
Advert
3
Enter your first example. Click the empty cell directly underneath the leftmost column. Enter in the value that matches the variable type into the cell. For instance, if the column is "name", you might enter in an employee'south name.^[2]
- Each row is ane "example", which is referred to as a record in other database programs.
4
Continue filling out variables. Motion to the adjacent empty cell to to the right and fill out the appropriate value. Always fill out one consummate record at a time. For case, if y'all are entering employee records, y'all would enter a single employee'southward name, address, phone number, and salary before moving on to the adjacent employee.
- Make sure that the values you enter match the Type format. For example, entering a dollar value in a Engagement-formatted cavalcade will cause an error.
5
Finish filling out your cases. Later each case is finished, move downwardly to the next row and enter in the next. Make sure each case has an entry for every variable.
- If you decide you need to add another variable, double-click the next open up cavalcade header and create one.
6
Manipulate your data. Once you take finished entering all of your data, you can use the tools built-in to SPSS to start manipulating your data. Some possible examples include:
- Create a frequency table
- Run a regression analysis
- Run an analysis of variance
- Create a scatter plot graph

Advertizing

1
Import an Excel file. When y'all import your data from an Excel file, you volition be automatically creating variables based on the outset row of the spreadsheet. The values of this row volition become the variable names. You can also choose to enter your variables manually.
- Click File → Open → Data...
- Select the .xls format for the "Files of type"
- Browse for and open the Excel file.
- Check the "Read variable names from the first row of the information" box if you want the variable names to be created automatically.
2
Import a comma-separated-value file. This is a patently text file format (.csv) with each entry being separated past a comma. You can set the variables to be created automatically based on the commencement line of the .csv file.
- Click File → Read Text Data...
- Select "All Files (*.*)" for the "Files of type"
- Browse for and open the .csv file
- Follow the prompts to import the file. Make sure that you tell SPSS that the variable names are at the elevation of the file when asked, and that the start case is on line 2.

Advertising

Add New Question

Question

How do I enter data in SPSS?

You lot accept to follow the instructions pace by step. Y'all can look at the book for extra help if needed.

Ask a Question

200 characters left

Include your e-mail address to go a message when this question is answered.

Submit

Advert

Video

Thanks for submitting a tip for review!

Things You'll Demand

IBM SPSS Statistics

Near This Commodity

Article Summary Ten

one. Define your variables.
2. Create a multiple pick variable.
3. Enter your start case.
4. Go along filling out variables.
5. Finish the remaining cases.
6. Dispense the information.

Did this summary help yous?

Cheers to all authors for creating a page that has been read 147,371 times.