Average Variance Extracted and Composite Reliability after Factor Analysis using SPSS and Excel 

This is just so helpful! I loved the way you organized your explanation visually, going through the lambda squared all along. I wish I can also be a great storyteller, such as you. Thank you.

DR grande you are saving our PhD ! BIG THANKS

this was great and very helpful. calculating AVE and CR is always such a pain. now I will have a go to file for every time I need to calculate them again. thanks!

This video was helpful, I liked that he broke down the steps. It seemed a little easier to grasp than some of the other videos in SPSS.

thaaaaaaaaaaanks alot for your kind help, slow speed of your teaching, and full explanation of each factor and formula. thanks a lot. you helped me alot. I could never compute AVE and CR without youuuuuuuuuu

Might be stupid question, but how do you know that the first four factors load under composite 1?

This is a very simple explaination. The video was helpful

Thank you very much, this was easy to understand and helpful.

Thank you for the nice video! It is quite helpful but I would like to ask you about some more details, especially about your default properties when doing the factor analysis: 1) Why did you work with "principal component analysis" instead of "principal axis factoring"? To what extent does it make any difference when calculating AVE and CR (if so)? 2) You mentioned that you use "Varimax" rotation but I wonder if you have checked or unchecked "unrotated factor analysis" in the "descriptives" section? I would be very happy about some detailed insights and your reply. Thank you very much in advance, Sue

Hi i got solution cannot be rotated, thus I cannot get my rotated component result. Do you know how to solve this issue?

unbelievably helpful. greatly appreciated

Thank you so much for this video, all your work is always so helpful, and easy to understand. I have one question and it is about using the correlates in the factors. What do you do when you have a negative number? In that case lamda will be lower because the sum will include a negative number. Thank you in advance.

Thank you for the video but I am wondering if there is another formula for calculating the composite reliability

Thank you Dr. Grande. It helps me a lot. Do you happen to have video of how to interpreted it as well?

Thank you for this video, Dr. Grande.

You explained it into details. OMG Thank you! It helps a lot!

Thank you for this video, Dr. Grande. Very informative. I have a question, though. I see that the composite reliability is calculated only for the items loading in the first component. Should it be calculated similarly including all the items for a reliability analysis of the whole instrument? Thanks in advance

many thanks for the great video! can discriminatory validity be calculated in the same way?

Do you might have a similar video presenting how to run the same tests using stata?

Very Helpful Video. Thanks for Sharing

thank you so much sir..... It was great help.... Please also tell how to interpret the values after calculation

That's quite helpful... Thankyou Dr Grande.

Thank you for the video Dr. Grande, it was very helpful. My question is what do I do if I am using previously established scales for my data and the factors in these scales have cross/ complex loadings? (I am attempting to run the EFA to calculate the AVE to compare with a scale that I developed.) Should I: 1. Alter these previously used scales by deleting items with cross loadings until they are usable 2. Can I calculate the AVE with the main/higher loadings per factor (although this seems to give a small AVE)

Hi, thank you so much for posting this video. I've used it to calculate the composite reliability. Is there a way to also calculate the 95% confidence intervals for the CR in excel? Many thanks

Thank you very much Sir

in 2:30 what did he say? how do we choose the 4 items?

when i performed factor loading with SPSS received output as "Only one component was extracted. The solution cannot be rotated" Any mistake happded

Thank you for the video. It's really helpful.

Marvellous (Y)

Thankyou so much ❤️

Thank you - this was super helpful!

Thank you very much. It is so helpful

Dear, Dr. Grande. I have a question. Is it correct to use the cross-loading method to assess for discriminant validity when the CFA is run under CB-SEM (e.g., ML, WLS, WLSMV)?

Hi Dr. Grande, please could you menton why just took the 1 thru 4 items instead of all column?

Hello can you tell me.thw interpretation of the composite rebility interpretation

very helpful, thanks!!!

Awesome video and very helpful!

Great ! Thank you

Why don't u make stat videos dr

thank you!!!!!