How to Analyse LIKERT-SCALE Data Using Regression, Descriptive Statistics and Correlation in Excel and SPSS.
Пікірлер: 92
@tiegomotswedi65263 ай бұрын
You saved my dissertation life
@davidowuamanam12862 ай бұрын
The best on KZfaq! Hands down and clear for all to understand. Cheers.
@sanusiakeem9252 Жыл бұрын
Thanks for adding values to human life through your transformational teaching. May God reward limitlessly
@chethanaamukotuwa40158 ай бұрын
Thanks a lot. Because of this video I did my final year thesis successfully❤
@md.deluwarhoque24232 жыл бұрын
Thank you so much for sharing this so impressive and informative video. I will be watching and learning more from you.
@madguds Жыл бұрын
Thank you so much for your incredibly wonderful and detailed explanation.
@stuartchitsulo30725 ай бұрын
You have been super in this video. Great job. I got what I was looking for. I thank you.
@betiiberii16982 жыл бұрын
Excellent Job. God will bless your knowledge!!
@emmanuelkahilu19922 жыл бұрын
Wow, so simplified. This is very educative.
@rashikakumari26212 жыл бұрын
Best video for multiple regression. Thank you so much sir
@yvetteburtworthington2540 Жыл бұрын
the explanation of which parametric and nonparametric tests to use is priceless. Thank you.
@paulodhiambo47192 ай бұрын
This clip saved my Dissertation. Keep up the good job
@livinusmaimako8517 Жыл бұрын
Thanks prof. You have answered my questions. Keep up. We are waiting for time series and panel data. Thanks sir
@ezeadorchikaogochukwu5697 Жыл бұрын
Great lesson, more grace.
@mkgeidam2 жыл бұрын
Thanks for the video @Obezip simple and easy to understand
@GangsterNerd1 Жыл бұрын
Great video, well explained
@eleemaaireen829111 күн бұрын
It’s really helpful, thank you💙
@sebastiancalderon2172 Жыл бұрын
just found both videos for this subject and omg you saved my life!!! thank you sooo much, such a good explanation
@obezipacademy Жыл бұрын
Many thanks. Why not consider buying our latest book on "Applied Statistics and Research Techniques: A Practical Guide for Data Analysis" that contains much more. See picture on my profile picture
@xasan4492 Жыл бұрын
Thank you for sharing knowledge
@rashedulislampapon692410 ай бұрын
Sir, I like the way you teach. I become proficient on spss regression analysis.
@abdallaabdurrahman2825Ай бұрын
This is such a great video! Thank you sir, you just got yourself a new subscriber
@kennydavid40472 жыл бұрын
Have been expecting this. Thanks alot😊
@kaylieepstein5394 Жыл бұрын
You saved my life thank you so so so much for this
@thuovincent755610 ай бұрын
Thank you. You have saved a life🤗
@crybaybie11 ай бұрын
Thank you so much for helping me understand ❤
@bigman68452 жыл бұрын
brilliant video.
@flavioandrescallecalle5519Ай бұрын
muchas gracias me ayudo mucho para mi tesis es genial la explicación
@obezipacademyАй бұрын
Me alegra mucho saber que la explicación te fue de ayuda para tu tesis. ¡Mucho éxito con tu trabajo!
@zoltanhajba2780 Жыл бұрын
Thank you, very detailed. As you can see. As you can see here :D
@ibrahimisrafilov1248 Жыл бұрын
I absolutely love it
@srabonahmad17743 ай бұрын
Thanks a lot Sir
@adaneersido Жыл бұрын
thank you very much
@krishashah7407 Жыл бұрын
Thank you so much
@leonardo7019 Жыл бұрын
shouldn't you recodify variables with more than 2 categories in order to use them in the regression analysis?
@siobhan9112 ай бұрын
Lifesaver!
@teodoranevinglovschi88452 жыл бұрын
Thank you for such a detailed explanation, really helped me understand. I have the following question which will help me a lot with my thesis: how do I motivate the use of linear regression, given that the final variables introduced are still categorical of some sort? they are not continuous for sure. I do want to use linear regression, where my data is normally distributed, but how can I prove that I can do this? Thanks a lot, would appreciate your response.
@obezipacademy Жыл бұрын
kzfaq.info/get/bejne/oLZ-lpyErNi1k3k.html
@kingsleykanjin3308 Жыл бұрын
The raw variables are in likert scale from SD to SA which is coded from 1-5. What do the mean values you calculated represent? SD? D? or what? Can you explain that to me? Your video will be very useful to me if you can explain this. Thanks
@rashikakumari26212 жыл бұрын
What is the interpretation of Standard error of estimate in this table?
@yaregaltayelegesse2267 Жыл бұрын
when the sig of Shapiro-wilk are greater than . then the data is called normaliy distributed, What about in case of Kolomogorov Smirnov?
@tobi_josh2 ай бұрын
Hello Sir, Why do we have to use Kolmogorov-Smirnov if our questionnaire are above 100? What is the explanation for this?
@mashupotato_2 жыл бұрын
Sir what to statistical test do we use if our data is the following: 1.) not normally distributed 2.) ordinal (likert scale) 3.) 4 independent variables, no dependent variable (descriptive research)
@obezipacademy2 жыл бұрын
Watch this video on how to Choose Appropriate Statistical Technique for Data Analysis: kzfaq.info/get/bejne/oLZ-lpyErNi1k3k.html You can also add Rank correlation analysis to your analysis
@md.deluwarhoque24232 жыл бұрын
Sir, may i request you to kindly share the PPT associated with this analysis and interpretation please?
@emmanuelebodum38 Жыл бұрын
Thanks for this presentation. What if there is autocorrelation indicated from the Durbin_Watson Statistics? How will be corrected? Thanks
@obezipacademy Жыл бұрын
You can try logging your variables and then re-estimate
@kayehermida3752 Жыл бұрын
What am i going to use if my DV is on ratio scale (e.g Profitability 0-20%) and my INV is Ordinal Scale (Likert Scale)?
@obezipacademy Жыл бұрын
ANOVA can handle it. It will treat the independent likert scale variable as categorical variable.
@tekalignloranso76779 ай бұрын
Plse make it vedio for determinants of aoplication of SIGTAS system
@DarkShadow Жыл бұрын
Hello sir I would like to ask a question. Is it okay if my first likert scale data consists of 5 questions while my second likert scale data consists of 12 questions?? thank you.
@obezipacademy Жыл бұрын
It's ok depending on the nature of your instrument. Remember that likert scale should be in an odd number not even number. Eg. 5, 7,9, 11, etc
@DarkShadow Жыл бұрын
@@obezipacademy if that's the case, then I'll add 3 more questions on 2nd likert scale data, thank you.
@DarkShadow Жыл бұрын
@@obezipacademy oh wait, do you mean the amount of the answer options? I am using 5-point likert scale
@ayeahcalvin5172 жыл бұрын
thank you Sir. very educative. Please i cannot find the video on ordinal regression for likert scale items. please can you share the link. checked amongst your videos. maybe i cant make it well.
@obezipacademy2 жыл бұрын
kzfaq.info/get/bejne/oZeaq9Zj3ce5iH0.html
@CriminologyMasterclass2 жыл бұрын
Sir, will you please make a video with the following info: 1. Dependent Variable has 5 indicators, each indicator consist of 5 question 2. Independent Variable has 2 indicators, each indicator consist of 5 question and what test should be use. Thank you
@obezipacademy2 жыл бұрын
Structural equation model(SEM) should suffice here
@md.deluwarhoque24232 жыл бұрын
@@obezipacademy Can you please share one video link, if you have, or make for us with example, to get an effective demonstration and learning please?
@taregtareg27311 ай бұрын
Is it corect to use regression with ordinal data?
@seraluna_Ай бұрын
Where can I download your powerpoint?
@chimwemwendovi87052 жыл бұрын
Sir, can you also share the PowerPoint
@ailsamcintosh6777 Жыл бұрын
Really handy.. But you know there's an AVG function that'll calculate the mean for you, without keying in all the cell refs?
@obezipacademy Жыл бұрын
Yes I know, but not everyone is conversant with that method...
@firozmp5757 Жыл бұрын
Normally distributed data. Use Linear regression
@reputeresearchcentre7755 Жыл бұрын
Thanks so much prof. Any video on effects size ?
@obezipacademy Жыл бұрын
Effect size of what exactly?
@reputeresearchcentre7755 Жыл бұрын
@@obezipacademy I think F square is the measure. Actually I am searching in spss for composite reliability, cronbach;s alpha and construct validity assessment for measurement model; and Q square for predictive relevance measure..
@oliverpatrick3959 Жыл бұрын
What do we do if our dataset comprises data that turns out to be both normal and not normal? Which analysis do we use?
@obezipacademy Жыл бұрын
Majority carries the vote
@oliverpatrick3959 Жыл бұрын
@@obezipacademy If its 2 sets each?
@yaregaltayelegesse22676 ай бұрын
How can we do ordinal regression where the dependent variable and independent variables have large number of items whose observation is collected in likert scale? can we use the transformed mean for analysis of ordinal regression? is there published evidence for that to cite? can you help me in this respect. some people say for non normal data we do not use mean
@obezipacademy6 ай бұрын
I'll make a video on this soon
@obezipacademy6 ай бұрын
You can watch my video on ordinal regression here : kzfaq.info/get/bejne/oZeaq9Zj3ce5iH0.htmlsi=y4AjiFfGQMeRjRuj
@aduseivanessa568611 ай бұрын
@obezipacademy please what if some of the variables are normally distributed and some are not?
@obezipacademy11 ай бұрын
The dependent variable has to be normally distributed. More so, majority carries the vote
@aduseivanessa568611 ай бұрын
So when majority is normally distributed , you use linear regression?
@kwarbai12 жыл бұрын
what do you do when some series are Normally distributed and some are not in the same model?
@obezipacademy2 жыл бұрын
If most of ur series are not normally distributed, you adopt ordinal regression technique
@wekesasanduku89092 жыл бұрын
@@obezipacademy Thank you for the response. I have also benefited from that. Let me hope that if most of my series are normally distributed then I use Linear Regression.
@amamclinton1511 Жыл бұрын
Please why didn’t you multiply the result from the respondent by the ranking values of likert scale (5 4 3 2 1 ) before solving for mean
@zuwairat Жыл бұрын
Why is that necessary if I may ask?
@amamclinton1511 Жыл бұрын
@@zuwairat I learnt that on some other videos on YT
@mervinchipeta5142 жыл бұрын
I wish you were my stats teacher
@obezipacademy2 жыл бұрын
Aww. Don't worry, I'm developing a book on Applied Statistics and Research Techniques...it will ready by first quarter of 2023
@mervinchipeta5142 жыл бұрын
@@obezipacademy excellent am sure you econometrics students enjoy your course. You explain stats with great command and ease
@obezipacademy2 жыл бұрын
I'm sure they do. Many thanks for your complement
@benjaminchamadenga92232 жыл бұрын
@@obezipacademy kindly share your email. Need assistance on data analysis
@matthewvictor9154 Жыл бұрын
Good afternoon I believe the number 1 to 5 are codes for the strongly agreed to strongly disagree Why are we finding the means of this codes and not the mean of the number of respondents
@obezipacademy Жыл бұрын
Those codes are responses from each respondents.
@AvC-wg3fjАй бұрын
You only used Excel to solve for the mean of those data but did not show how to solve for the linear regression. Your title is misleading
@DisappearingBoy201010 ай бұрын
What is your hypotheses for how the variables interact? The analysis has no context without understanding that. This is more of an excel tutorital than a data analysis explanation. And why wouldn't you just do =AVERAGE instead of manually adding and dividing?