Grouping Likert Questionnaire Items into Continuous Variables for Correlation and Regression

This tutorial demonstrates how you can group your Likert Scale item statements into continuous variables before testing hypotheses.

[@Elusiv3Pastry]

I'm in the dissertation phase of my PhD and not one professor has shown me how to do this, not even in my stats classes! Thank you SO much for this video!

[@Dr.Okolie]

Thank you for finding the video helpful. Please share and like the tutorial. Best wishes.

[@kristoflancelot3167]

same here..

[@humbefidelis8405]

Great job Dr. you have been inspiring me over here.

[@Dr.Okolie]

Glad to hear this. Thank you very much

[@user-my4ze4kl1c]

Thank you so much for saving my life Dr. Okolie. I can't thank you enough..

[@Dr.Okolie]

Thank you for finding the video helpful

[@koinonia247]

Dr Okolie, you are a great teacher.

[@Dr.Okolie]

Thank you very much for finding the video tutorial helpful. Pls, share and like

[@kgnesta]

Geez! This is what i have been struggling with. Now i have just done it easily! Thanks so much. You rock!

[@Dr.Okolie]

Thank you very much for finding the tutorial helpful. Pls, share and like. Best wishes.

[@Luckisto]

The explanation is spot on but the calibration of the instrument is wrong. Be careful!

[@ifeanyiagunwa2408]

Great Job Dr. Okorie. This was helpful.

[@Dr.Okolie]

Glad it was helpful!

[@philipmaimba1365]

On this day, March 3, 2024. You have saved my life. I was totally confused on how to do correlation analysis with my linkert scale data

[@Dr.Okolie]

Thank you very much for finding the video helpful. Pls, share and like the video. You may also find this video kzbin.info/www/bejne/lXjFenWqnJqsfZI helpful

[@inusahsulemana4608]

thanks soo much i have been straggling with this issue for a long time. God bless you

[@Dr.Okolie]

Thank you. Please share and like the video

[@byebyeworld999]

Thank you Dr Okolie, this is the most detailed explanation I have ever seen😭

[@Dr.Okolie]

Glad it was helpful! Thank you very much. Pls, like and share

[@emrize5408]

Thank you so much Sir. Being a scholar of Agricultural Extension Education in India I have been struggling since the last few weeks for analysing likert scale data using SPSS as there is no course that gives insight to it. It's a life saving lecture video. I appreciate your efforts.

[@Dr.Okolie]

Thank you for finding the video helpful. Pls, share and like the video. Best wishes!

[@hanankhalifa2589]

Omg your amazing! Thank you for taking the time to teach us

[@Dr.Okolie]

Thank you so much for watching the video. Please, like and share the video. Best wishes

[@oluwababatunmise4073]

You are an amazing human Sir... Thank you very much

[@Dr.Okolie]

Thank you too for watching. Please share and like the video

[@neXGenAcad]

So insightful. Thank you

[@Dr.Okolie]

Thank you very much for finding the tutorial helpful. Pls, like the tutorial and share to others who may find it useful.

[@oceansanjana768]

thank you so much you help me a lot with my project work very easily and understandable

[@Dr.Okolie]

Thank you very much for finding the video helpful. Please, like and share the video

[@aishnaadhin7985]

You saved me. Thank you!

[@Dr.Okolie]

Glad I could help! Thank you so much for watching the video. Please share and like.

[@goodmanobad8769]

Hi Dr Okolie, thank you for the explicit tutorials. With your videos, I have evade enriching someone on something I can now do effortlessly. Please, I would like you to make a video on one-way ANOVA, to complement the once you have done already. Thank you.

[@Dr.Okolie]

Thank you very much. I'll do the video soon.

[@Emeka241]

Very incisive. I'm sharing with my students

[@Dr.Okolie]

Thank you very much. I am happy you find the video tutorial helpful. Thank you for also sharing with your students. Best wishes

[@rhoslynsagpang1006]

Thank you for this a big help

[@Dr.Okolie]

Glad it helped. Pls, like and share the video

[@CynthiaOkolie-nq4gj]

Thanks for the great video

[@Dr.Okolie]

Glad you enjoyed it

[@hanumanthm6289]

Thank you very much. Life saver 👍🤚

[@Dr.Okolie]

Thank you. Glad it was helpful

[@user-gd5or1sl5z]

This is great, thanks.

[@Dr.Okolie]

Thank you.

[@user-jn5ln1gk3x]

you have gained a subscriber sir you have gained a subscriber sir 🖖

[@Dr.Okolie]

Thank you very much for subscribing yo my channel. Best wishes

[@axmedkaabbe7863]

Thank you so much

[@Dr.Okolie]

Thank you too. It's a pleasure!

[@EdutObona]

thank you once again for this impactful lecture, Dr Ugochukwu. please, i will like to ask if you have a video on how to answer research questions using regression analysis. if you do, kindly let me know and if you dont, could you do one?

[@Dr.Okolie]

Thanks for watching the tutorial video. Pls, like and share. Regarding your question, I feel that research questions are better answered using descriptive statistics. You can check my video in Likert Scale data analysis. Regression analysis is better conducted to test hypotheses. You can check my video tutorials on multiple regression analysis too. They're well detailed. Once again, thank you for finding the video helpful.

[@EdutObona]

I have watchted several of your videos and have subscribed and shared accordingly. I must also say here that i actually benefited so much from one of your videos on regression analysis. However, i want to ask you again: Can i use regression to do data analysis when i have multiple independent sub-variables and multiple dependent sub-variables as well? or what is the best statistical tool to use in that situation? Waiting for your kind reply. Thanks@@Dr.Okolie

[@Dr.Okolie]

@@EdutObona Thank you for enjoying the videos. Yes, you can have dependent and independent variables with several sub-constructs. For example, the regression analysis videos showed that the independent variable (support) was decomposed into three sub-constructs of Parent, friends and teacher support. Same can also be done for dependent variable. You can have both variables decomposed into several other sub-constructs in one study as long as your motives are theoretically and practically justified.

[@MrFreyTV]

Is it okay to use Spearman rho?

[@hekmatullahmuzaffari4625]

Hello! I rank the A 1, B 2, C3... For the grades of school children and their habit of breakfast are 1 for every day, 2 for most days, 3 for rarely.... 5 never... This ranks are correct? it right to find the correlation...?

[@Insights4UToday]

Great

[@Dr.Okolie]

Thank you so much

[@nifemijohn1630]

Hi Dr, am trying to do the grouping but is not responding

[@SleepyJackrabbit-cu4ty]

dr. okolie, is this allowed? is there a source where we can verify that this practice is legal/allowed?

[@bhairabtalukdar4093]

Make a video on probit model analysis in spss

[@ngantruongnguyenhoang4783]

Hi, thank you so much for the tutorials. It is very useful. Can I also ask you one thing. I thought it would be ordinal data instead of scale in the Measure section in SPSS. Can you explain a bit here. Thank you very much

[@Dr.Okolie]

From long years of experience, whether you select ordinal or scale under the section can't affect anything. Please, feel free

[@ngantruongnguyenhoang4783]

@@Dr.Okolie thank you very much for your reply! Appreciated

[@touhidurtonmoy4950]

Dear Prof., I have a question. Even after calculating the mean of individual items of likert scale variables, it's not normally distributed(I've found it in my dataset). So how can we run the parametric tests (Pearson correlation, Linear regression) with these mean scores, where the primary condition of running parametric test is having normally distributed variables? Please reply.

[@Dr.Okolie]

I will suggest a few things. First, you may transform the data with a function to force the data to be normally distributed. Again, if your sample size is relatively small, you may consider running a non-parametric analysis. Second, you may trace the actual respondent whose responses are causing the data not to be normally distributed, and then, remove it from the dataset. This option may apply if you have a larger dataset. I'll recommend you watch kzbin.info/www/bejne/ipavkI2hmp12qM0 by Math Guy Zero. His tutorial explains how you can deal with a dataset that is not normally distributed. Hope this helps.

[@touhidurtonmoy4950]

You're right sir. My dataset is small. That's why at first I performed Spearman correlation, but found no significant results. All of my hypothesis were rejected. Then after watching this video I performed Pearson correlation & linear regression on my likert scale variables, and found statistically significant results. 3 out of 4 hypothesis were accepted this time. Thanks a lot to you sir. My concern is that, how I'll justify it to my thesis? Is this analysis valid? I need your opinion sir, plz.

[@maremomphahlele4499]

Do you by any chance have any published article or a book that we can reference the method from?

[@Dr.Okolie]

The video is a reference source.

[@ramaco_789]

Hi Dr.Okolie.I am from Mumbai.I teach research methodology,I just love all your sessions.Can you take online sessions for my students?I am from Mumbai

[@Dr.Okolie]

Sure. Yes I can.

[@olewuezidevice1774]

Thank you very much sir on this. I really really appreciate. Please I have a question. After the whole grouping and stat analysis how to I perform the test of Hypothesis, like the actual test of the hypothesis? Is there a video please kindly attach link to the reply

[@olewuezidevice1774]

Like which set of data do I use for the test, please don't be offended by the question

[@Dr.Okolie]

Thank you very much for finding the video helpful. You can watch this for hypotheses testing kzbin.info/www/bejne/oXa4l2Npga2cjqs

[@nnodatulomah4312]

I have a concern about how the instrument is calibrated as a measuring tool and zeroed. Again the instrument maximum scores it can measure. The illustration described in this video has a few issues of concerns, the undecided has code better than a statement response better than undecided so how do we reconcile this in terms of values assigned?

[@nnodatulomah4312]

Can we have a chat on this please privately?

[@Dr.Okolie]

@@nnodatulomah4312 Thank you very much for expressing your concerns. Pls, use my contact on the tutorial to WhatsApp me. We can talk about your concerns for clarity.

[@Luckisto]

That is my concern I flagged on another video by Dr Okolie: kzbin.info/www/bejne/q3nXloJ8hJ1ng68 The "undecided" seems to be causing some serious confusion leading to what I may call "wrong" interpretation and results. In my opinion, "undecided" should carry no weight on the scale, thus it would be better to either use "neither agree nor disagree" or remove it from the Likert scale. Otherwise the result are unreliable.

[@Dr.Okolie]

@@Luckisto Thank you for your comments. What is the meaning of "neither agree nor disagree" as you recommended in your writing? When somebody didn't agree or disagree on something, what does it mean?

[@Dr.Okolie]

@@Luckisto Again, if you are undecided on something, it is also a response.

[@BolutifeA]

Thank you for the explanation, can this be done on excel?

[@Dr.Okolie]

Thank you film watching the tutorial. I have not done that using excel before.

[@serenayben9660]

Amazing thanks. I have a problem interpreting the data output. Do you provide private help about that? Like can I share my data output and help me write conclusions. Just thought I'd seek help since am watching tutorials for a week now (cry)

[@Dr.Okolie]

you can email me [e-mail]

[@florianawassong9756]

Hello thank for the tutorial I have a problem Please I try to evaluate thé motivation of Drinking on some participant and for it a use the« DMQR-SF » which is a questionnary of 12 questions and each questions hav 5 items with point ( never = 1 pt, somestimzs =2 pt , half of times =3 pt, much of times =4 pt , everytimes =5 pt) , and each questions Belong to one of the 4 main reason Why thé participant drink alcohol ( expl: questions 1,5,8>social reason; question 3,6,10>Forget problem….etc at the end of questionnary we sum the point of participant in each main reason and thé main reason which has thé Highest score its thé reason Why thé participant drink alcool Now i try to do it on SPSS, i Créate variable for each main reason , i sum , i create another variable who show me the highest score between thé 4 with command » Max « but thé way is that this last variable dont show me Where thé highest score come from…i am force to go and see thé other 4 variable to see where it comme from it really not good because i have more than 1000 participant… it will be well if you have a solution who show me where thé highest score Côme from so that injust make a fréquency table I Hope you can help me Thank you in advance !

[@rezerochan5145]

Sir I have a question, what do I do if my questionnaire have two part likert scale questions (first part is disagree-agree scale and the second part is never-always scale) but all those will be used for one variable only. How do i check its reliability and how do I group it?? I would very much appreciate your help

[@Dr.Okolie]

Thank you. Whatever you call your rating scale (e.g., Strongly agree, always, never, not about me, etc.) doesn't matter. You can check the reliability coefficients following my tutorial. Also, you can group them to continuous variables as I did in the video. Best wishes.

[@rezerochan5145]

Thank you so much for your help sir!@@Dr.Okolie God bless you

[@EnawgawMinichl]

Is There The Difference Between Mean Result And The Computing result?

[@Dr.Okolie]

I didn't get your question correctly. You can rephrase the question for clarity

[@EnawgawMinichl]

The Mean Result Of the Variable is similar or not with when computing the variable

[@kristoflancelot3167]

is this method used in any research paper. please provide the source in need to provide justification.

[@Dr.Okolie]

Thank you. The video can also serve as a reference source

[@user-ex7ms5yt1l]

Please, why did you use pearson not spearman correlation although the data are ordinal

[@Luckisto]

After the conversion, the data changes from ordinal to continuous hence become fit for parametric tests.

[@Dr.Okolie]

Thanks for your quick reply to the question. Best wishes

[@nnodatulomah4312]

How are you sure the transformation correctly yielded a continuous variable?

[@Dr.Okolie]

@@nnodatulomah4312 Thanks for your comment. The video clearly explains how you can transform Likert scale dataset into continuous variables. I encourage you to watch the video again carefully. Thanks

[@TaraGhimite]

Sir, please could you help me I need likert questionnire for coping strategies for lonliness, please

[@Dr.Okolie]

Please, search Google for several validated measurement scales on coping strategies for loneliness

[@aftabhussain5858]

Great.but background voice is disturbing

[@Dr.Okolie]

Ok next time, I'll improve. Thank you

[@bbfghdut]

Dr Okolie do you have any email we can reach you?

[@Dr.Okolie]

Thanks. [e-mail] and [e-mail]

[@Dr.Okolie]

Thank you. [e-mail] and [e-mail]

[@devwhatsappstatus3387]

Thank you very much sir. I have one question If i have one more variable gender or qualifications of the respondent along with this data.and i want to run chi square test for this variable gender with all 10 items then how to do it?will you please explain this?

[@Dr.Okolie]

Thank you for watching the tutorial. Pls, i'll make a Chi-Square tutorial to explain this well. The video will be uploaded soon.

[@devwhatsappstatus3387]

@@Dr.Okolie Thank you sir and waiting for your valuable guidance