Hi .. i just have one question ... by computing cronbach alpha for 10 constructs in spss, i have got different CR values from the same set of data using the approach in this video (AMOS + your excel sheet) ...!!!! actually 9 constructs were the same ... but in one construct i got Cronbach alpha in spss of 0.42 and CR 0.72 in your excel sheet .... i wonder if you know why ? thanx in advance
Wow! That is very different. I suggest using my new tool and new method. See the "Validity during CFA made easy" video. Usually CR and CA are very similar (if not identical).
@Gaskination i have used the new one as in your other video .... still the same problem ... on your tool it gives CR 0.721 on the SPSS it gives 0.424 ... i should not that the other constructs are ok except an additional construct where on new excel tool is 0.513, old excel tool is 0.65 SPSS is 0.14, !!! i tend to think the SPSS is true because i can see that this construct is unreliable by looking at the item responses . am left with one question, why some constructs are OK while 1 or 2 not ?
@Gaskination i have used the new tool.... SPSS Cronbach = 0.42 , old Excel tool= 0.72 , new excel tool = 0.72. on other construct i have SPSS Cronbach = 0.14 , Old Excel tool = 0.65, new excel tool = 0.513 ... the later construct of 0.14 reliability, i am sure its very unreliable from observing the items responses ... but why on 2 constructs i get the inconstant output while the others are ok ...?
This baffle me. The code is not very robust. It may be something as silly as the name of the factors. What are the labels of the factors? If they are something like "CR" "AVE" "ASV" or "MSV" or "e12" etc., then their might be problems.
Are you looking at Composite Reliability in SPSS, or Critical Ratio, or Cronbach's Alpha? The algorithms for Composite Reliability and Chronbach's Alpha are different, and Critical Ratio is a very different algorithm. Also, Chronbach's Alpha is very sensitive to the number of items per factor.
Hi James, We had a bug in the statstool package the correlation matrix does not fully appear and I copied the script that you can see below, please help.
Hi again James, I just solved my own question :) Well, this is a good opportunity to say once again how helpful you have been and also so generous in sharing your knowledge with us strugglers :) I really cannot thank you enough.
Hi James, I have managed to learn how to do CFA with AMOS thanks to you. I am tto trying do the discriminant validity using AMOS now . I have managed to get stuck at the point where I cannot access the 'correlation' from the output. All I get when I click on the estimates then scalers is Regression weights, standardised regression weights and variances. I know I am probably leaving something out in the Analyze properties table.... but what? Please would you help me? Thank you.
Thank you, James. I am sure that the combination of your 'handy dandy stats tool package', the video tutorials, the wiki and the powerpoints will be very useful to me and others! :)
Hi. What does "my handy dandy stats tools package" means? Is it a macro you have made? If it is not a macro you have made, which is the name of that 'handy dandy' tool? Without that information the video is useless to others than your students. Thanks! and greetings!
Hi .. i just have one question ... by computing cronbach alpha for 10 constructs in spss, i have got different CR values from the same set of data using the approach in this video (AMOS + your excel sheet) ...!!!! actually 9 constructs were the same ... but in one construct i got Cronbach alpha in spss of 0.42 and CR 0.72 in your excel sheet .... i wonder if you know why ? thanx in advance
mhdamro 1 month ago
@mhdamro
Wow! That is very different. I suggest using my new tool and new method. See the "Validity during CFA made easy" video. Usually CR and CA are very similar (if not identical).
Gaskination 1 month ago
@Gaskination i have used the new one as in your other video .... still the same problem ... on your tool it gives CR 0.721 on the SPSS it gives 0.424 ... i should not that the other constructs are ok except an additional construct where on new excel tool is 0.513, old excel tool is 0.65 SPSS is 0.14, !!! i tend to think the SPSS is true because i can see that this construct is unreliable by looking at the item responses . am left with one question, why some constructs are OK while 1 or 2 not ?
mhdamro 1 month ago
@Gaskination i have used the new tool.... SPSS Cronbach = 0.42 , old Excel tool= 0.72 , new excel tool = 0.72. on other construct i have SPSS Cronbach = 0.14 , Old Excel tool = 0.65, new excel tool = 0.513 ... the later construct of 0.14 reliability, i am sure its very unreliable from observing the items responses ... but why on 2 constructs i get the inconstant output while the others are ok ...?
mhdamro 1 month ago
@mhdamro
This baffle me. The code is not very robust. It may be something as silly as the name of the factors. What are the labels of the factors? If they are something like "CR" "AVE" "ASV" or "MSV" or "e12" etc., then their might be problems.
Gaskination 1 month ago
check your googlemail ..
mhdamro 1 month ago
@mhdamro
Are you looking at Composite Reliability in SPSS, or Critical Ratio, or Cronbach's Alpha? The algorithms for Composite Reliability and Chronbach's Alpha are different, and Critical Ratio is a very different algorithm. Also, Chronbach's Alpha is very sensitive to the number of items per factor.
Gaskination 1 month ago
@Gaskination on SPSS i am looking at cronbach alpha under "reliability statistics"
mhdamro 1 month ago
Hi James, We had a bug in the statstool package the correlation matrix does not fully appear and I copied the script that you can see below, please help.
Next
Cells.Find("Validity Concerns").Insert shift:=xlDown
If Cells.Find("Validity Concerns").Offset(1, 0).Value = "" Then Cells.Find("Validity Concerns").Value = "No Validity Concerns - Wahoo!"
Range("K2").Activate
Range("K1").Value = " "
End Sub
HSYARATAN 2 months ago
@HSYARATAN
The correlation matrix should have been fully built by that point in the code. Try placing a single quote mark (apostrophe) before this line:
If Cells.Find("Validity Concerns").Offset(1, 0).Value = "" Then Cells.Find("Validity Concerns").Value = "No Validity Concerns - Wahoo!"
If it still doesn't work, feel free to email me separately at james. eric. gaskin@ gmail. com
Gaskination 2 months ago
Hi again James, I just solved my own question :) Well, this is a good opportunity to say once again how helpful you have been and also so generous in sharing your knowledge with us strugglers :) I really cannot thank you enough.
nilgunsuphi 2 months ago
@nilgunsuphi
Glad it works. I HIGHLY recommend doing it this other way described in my "Validity during CFA made easy" video.
James
Gaskination 2 months ago
Hi James, I have managed to learn how to do CFA with AMOS thanks to you. I am tto trying do the discriminant validity using AMOS now . I have managed to get stuck at the point where I cannot access the 'correlation' from the output. All I get when I click on the estimates then scalers is Regression weights, standardised regression weights and variances. I know I am probably leaving something out in the Analyze properties table.... but what? Please would you help me? Thank you.
nilgunsuphi 2 months ago
thanks for everything, you have been really helpful, I really appreciate all your work and it is great that you share it with other people.
bananabahama 4 months ago
@bananabahama
You're welcome!
Gaskination 4 months ago
Thank you, James. I am sure that the combination of your 'handy dandy stats tool package', the video tutorials, the wiki and the powerpoints will be very useful to me and others! :)
gdemarchis 7 months ago
Hi. What does "my handy dandy stats tools package" means? Is it a macro you have made? If it is not a macro you have made, which is the name of that 'handy dandy' tool? Without that information the video is useless to others than your students. Thanks! and greetings!
gdemarchis 7 months ago
@gdemarchis I've pasted the link in the video now. Thanks for the encouragement.
Gaskination 7 months ago
Hi, thanks for the video. May I know where can I obtain the Excel spreadsheet you used? Thanks.
alainchong88 10 months ago