@luluko4162 Thanks for your kind words. Now, as you develop your career over the next few years, it's up to you to use reliable measures whenever you need to measure something!
You are a greaaaat teacher sir, much love and respect Can't believe how effective you could put it in less than 10 minutes with a lot of examples. Awesome awesome awesome
Thank you so much for simplifying! We have so many videos out there that are very complicated with their wording I tend to lose interest. However, you explained so well! Thank you! I am feeling more confident now with this subject.
Hi David. I've collected a retest response of few questionnaire that I had used to determine attitude of parents on e-Learning. I have a set of 20 respondents who were given a questionnaire at different time period. Now, I've two Excel sheet based on their response. How do I club this data in a single Excel file so as to upload in SPSS and analyze? The questionnaires had 4 drop-down options to choose from and I've coded them as 1,2,3,4 based on their response on both Excel sheets.
Hi Kamonasish, A lot depends if you can match the respondents' responses at Time 1 with their responses at Time 2. If each questionnaire identifies if it was completed by Respondent 1, Respondent 2, etc., then you need to keep all of Respondent 1's responses on one line in Excel. You will have a total of 20 lines and as twice as many columns as you had questions (Time 1 responses plus Time 2 responses). If you cannot match Time 1 responses with the Time 2 responses, You need to put the 40 responses in 40 different rows. You will need to add a column to indicate if it was Time 1 or Time 2 (e.g., put a 1 or 2 in the new column to indicate if it was from Time 1 or Time 2). You can do this through copying pasting, making sure that you have the respondents in rows and the questions in columns.
@@DavidDunaetz Thank you. I have identified every respondents answers. As per your suggestion, I have, now, 20 rows and and 20 columns (For T1, I have 20 rows and 10 columns and for T2, I have 20 rows and 10 columns). Now, in SPSS, once I import this data, I'll have to click Analyze> Correlate> Bivariate>select all variables and check Pearson's coefficient, two-tailed test, Flag significant correlations, and click OK. The resulting table will have 1 diagonally and Pearson coefficients and Sig (2-tailed) value. Is my understanding correct? For interpretation of this table, I may have to watch your video on correlations. Right?
@@DavidDunaetz In addition to my previous clarification, do I have to check the correlation value of respondent 1's reply to the same question at T1 and T2? I need not bother about other column values? I watched your video on 'Interpreting Correlation' but did not understand how do I look at it on SPSS output.
Many of the correlations in your table of correlations will not be meaningful. It sounds you are primarily interested in how Question 1 at Time 1 correlates with Question 1 at Time 2, how Question 2 at Time 1 correlates with Question 2 at Time 2, etc. Other correlations may be interesting also.
Honestly, amazing! I am incredibly thankful. My brain was exploding before with my text book Now it is calm and you are an amazing teacher, thank you!
@luluko4162 Thanks for your kind words. Now, as you develop your career over the next few years, it's up to you to use reliable measures whenever you need to measure something!
You are a greaaaat teacher sir, much love and respect
Can't believe how effective you could put it in less than 10 minutes with a lot of examples. Awesome awesome awesome
Thank you so much for simplifying! We have so many videos out there that are very complicated with their wording I tend to lose interest. However, you explained so well! Thank you! I am feeling more confident now with this subject.
This is so helpful!
Soooo well explained.
Great explanation professor 😀 take care
This was great!
Very good explanation. Thank you sir!
Fantastic! Thank you so much!
Thank you very much! 😊
Thank you very much for the detailed explanation 🙏
Glad it was helpful!
thank you so much! i really enjoyed the video
Thank you, very helpful!
I'm glad you found it useful.
Hi David. I've collected a retest response of few questionnaire that I had used to determine attitude of parents on e-Learning. I have a set of 20 respondents who were given a questionnaire at different time period. Now, I've two Excel sheet based on their response. How do I club this data in a single Excel file so as to upload in SPSS and analyze? The questionnaires had 4 drop-down options to choose from and I've coded them as 1,2,3,4 based on their response on both Excel sheets.
Hi Kamonasish,
A lot depends if you can match the respondents' responses at Time 1 with their responses at Time 2.
If each questionnaire identifies if it was completed by Respondent 1, Respondent 2, etc., then you need to keep all of Respondent 1's responses on one line in Excel. You will have a total of 20 lines and as twice as many columns as you had questions (Time 1 responses plus Time 2 responses).
If you cannot match Time 1 responses with the Time 2 responses, You need to put the 40 responses in 40 different rows. You will need to add a column to indicate if it was Time 1 or Time 2 (e.g., put a 1 or 2 in the new column to indicate if it was from Time 1 or Time 2).
You can do this through copying pasting, making sure that you have the respondents in rows and the questions in columns.
@@DavidDunaetz Thank you. I have identified every respondents answers. As per your suggestion, I have, now, 20 rows and and 20 columns (For T1, I have 20 rows and 10 columns and for T2, I have 20 rows and 10 columns). Now, in SPSS, once I import this data, I'll have to click Analyze> Correlate> Bivariate>select all variables and check Pearson's coefficient, two-tailed test, Flag significant correlations, and click OK. The resulting table will have 1 diagonally and Pearson coefficients and Sig (2-tailed) value. Is my understanding correct? For interpretation of this table, I may have to watch your video on correlations. Right?
@@DavidDunaetz In addition to my previous clarification, do I have to check the correlation value of respondent 1's reply to the same question at T1 and T2? I need not bother about other column values? I watched your video on 'Interpreting Correlation' but did not understand how do I look at it on SPSS output.
That sounds correct!
Many of the correlations in your table of correlations will not be meaningful. It sounds you are primarily interested in how Question 1 at Time 1 correlates with Question 1 at Time 2, how Question 2 at Time 1 correlates with Question 2 at Time 2, etc. Other correlations may be interesting also.
Beepbeep, you are perfect to me!
Beep Beep wants me to let know that he would like to share one of his chocolate chip cookies with you.