How to import, code and analyze 5 point LIKERT SCALE ITEMS from Google form into SPSS
Вставка
- Опубліковано 12 вер 2024
- To import, code, and analyze Likert scale data from Google Forms into SPSS, follow these steps:
1. Export Data from Google Forms:
- After collecting responses, go to the Google Forms Responses tab.
- Click on the Google Sheets icon to view the responses in a spreadsheet.
- Download the spreadsheet as a .csv file by selecting File -Download Comma Separated Values (.csv).
2. Import Data into SPSS:
- Open SPSS and go to File - Open - Data.
- Select the .csv file you downloaded and click Open.
- Ensure that the first row in the import options is set as variable names.
3. Coding the Likert Scale:
- If your Likert scale items are not already numerically coded (e.g., "Strongly Agree" as 5), you’ll need to recode them.
- In SPSS, go to Transform - Recode into Different Variables....
- Select the Likert scale variable, give it a new name, and click Old and New Values.
- Enter the old (text) values and the corresponding new (numeric) values. Click 'Add' after each one.
- Click `Continue` and then `OK` to create the recoded variable.
4. Analyzing Likert Scale Data
- Descriptive Statistics: Go to Analyze - Descriptive Statistics - Frequencies to get a frequency distribution for each Likert item.
- Reliability Analysis: To check the internal consistency of the scale, go to Analyze - Scale -Reliability Analysis and select Cronbach’s Alpha.
- Factor Analysis: If you want to explore underlying dimensions, use Analyze - Dimension Reduction - Factor`.
5. Interpreting Results
- Interpret the descriptive statistics to understand the central tendency (mean) and variability (standard deviation) of responses.
- Use the Cronbach’s Alpha result to assess the reliability of your scale (α greater than 0.7 is generally considered acceptable).
- Factor analysis can help you identify underlying constructs represented by your Likert scale items.