1 / 20

Questionnaire Development: SPSS and Reliability

Questionnaire Development: SPSS and Reliability. Personality Lab October 8, 2010. Open Google Docs Spreadsheet. Download Spreadsheet to Desktop in Excel Format. Save to Desktop. Get Data Ready for Analysis: Open in Excel. Verify responses are numbers Column headings are questions-- revise.

napua
Download Presentation

Questionnaire Development: SPSS and Reliability

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Questionnaire Development: SPSS and Reliability Personality Lab October 8, 2010

  2. Open Google Docs Spreadsheet

  3. Download Spreadsheet to Desktop in Excel Format

  4. Save to Desktop

  5. Get Data Ready for Analysis: Open in Excel • Verify responses are numbers • Column headings are questions-- revise

  6. Getting Data into SPSS • Open SPSS • Click “cancel” on opening screen

  7. Getting Data into SPSS • File > Open > Data

  8. Getting Data into SPSS • Change “files of type” to Excel

  9. Getting Data into SPSS • Open your spreadsheet, Click “OK”

  10. Getting Data into SPSS • Spreadsheet Opens

  11. Save SPSS File • Save as type – make sure it is “.sav”

  12. Reverse Coding Items • Transform > Recode into same variables • Select items to reverse code • Click on “Old and New Values”

  13. Reverse Coding Items • If 4 point scale • Old value enter 4, new value enter 1, click “add” • Old value enter 3, new value enter 2, click “add” • When finished click continue to reverse other items • Click OK when all items reverse coded

  14. Running Reliability Analysis • Analyze > Scale > Reliability Analysis • Select items for analysis • Click “Statistics” and check “item” and “scale if item deleted” • Click continue • Click OK • See Output

  15. Running Reliability Analysis

  16. Output from Reliability Analysis

  17. Interpret Output • Case Processing Summary – N is # of Test Takers • Reliability Statistics – Cronbach’s Alpha is our stat, .50-.60 marginal, .61-.70 good, .71-85 very good • Item Statistics – average response for all test takers • Item total Statistics – use to determine which items stay, get dropped

  18. Item Total Statistics • If reliability goes up after deleting item, bad item • If reliability goes down after deleting item, good item • See item total correlations • Q3 good item, Q2 bad item

  19. Revise Questionnaire • Use best judgment to exclude items • Drop a couple of items, rerun reliability analysis, check results • Drop more items, check results, Cronbach’s Alpha go up or down? • Pick final set of items • Run Reliability Analysis with final set of items • If good reliability, use questions for your questionnaire

  20. Update Questionnaire • Include subset of old questionnaire items • Include validity questionnaire items • Check for typos • Submit to friends and family