Here you can download an Excel spreadsheet that could be useful to you, SEMers
If you use Structural Equations Models (SEM) for your research, you probably need to compute some values by hand.
With SEM Stats (ok, this isn't a very original name), you can forget your hands & let Excel do the hard work for you.
Click here to download SEM Stats (version 1.3)
Some people may need to right click & select 'save as'
What this Excel file does:* Chi-square comparison test
* Computation of the lambda & uniqueness for a latent variable with 1 indicator
* Computation of the GammaHat (Steiger, 1980)
* Computation of RMSEA (& a 90% confidence interval)
* Computation of Rho vc (AVE) & Jöreskog's rho, to assess validity & reliability of a latent variable
* Computation of Cronbach's alpha and "What if..." (I add or remove some items)
What this Excel file will never do:
* Help you build a good model
If you want to know more about me:
Michaël Korchia, my website