1 / 8

1. Open the SPSS data set on which you want to run the alpha analysis

1. Open the SPSS data set on which you want to run the alpha analysis. 2. Request a correlation matrix of the items for which you want an alpha. Ask for cross-products and exclude data pairwise. 3. You’ll get a large table as output. 4. Copy and paste the table to excel.

geordi
Download Presentation

1. Open the SPSS data set on which you want to run the alpha analysis

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. 1. Open the SPSS data set on which you want to run the alpha analysis Calculating AIA Alpha in Excel - M. Parent, 2012

  2. 2. Request a correlation matrix of the items for which you want an alpha. Ask for cross-products and exclude data pairwise. Calculating AIA Alpha in Excel - M. Parent, 2012

  3. 3. You’ll get a large table as output. Calculating AIA Alpha in Excel - M. Parent, 2012

  4. 4. Copy and paste the table to excel Calculating AIA Alpha in Excel - M. Parent, 2012

  5. 5. Delete the extra info—everything except the “covariance” line. Calculating AIA Alpha in Excel - M. Parent, 2012

  6. 6. Delete the bottom left triangle of the matrix (but keep the diagonal). Calculating AIA Alpha in Excel - M. Parent, 2012

  7. 7. Copy and paste the upper right triangle into the excel calculator Calculating AIA Alpha in Excel - M. Parent, 2012

  8. 8. Enter the number of variables into the calculator. Done! Calculating AIA Alpha in Excel - M. Parent, 2012

More Related