Excel and SPSS: LIKERT-SCALE Data Analysis Using Regression in Excel and SPSS

  Рет қаралды 90,838

Obezip Academy

Obezip Academy

2 жыл бұрын

How to Analyse LIKERT-SCALE Data Using Regression, Descriptive Statistics and Correlation in Excel and SPSS.

Пікірлер: 92
@tiegomotswedi6526
@tiegomotswedi6526 3 ай бұрын
You saved my dissertation life
@davidowuamanam1286
@davidowuamanam1286 2 ай бұрын
The best on KZfaq! Hands down and clear for all to understand. Cheers.
@sanusiakeem9252
@sanusiakeem9252 Жыл бұрын
Thanks for adding values to human life through your transformational teaching. May God reward limitlessly
@chethanaamukotuwa4015
@chethanaamukotuwa4015 8 ай бұрын
Thanks a lot. Because of this video I did my final year thesis successfully❤
@md.deluwarhoque2423
@md.deluwarhoque2423 2 жыл бұрын
Thank you so much for sharing this so impressive and informative video. I will be watching and learning more from you.
@madguds
@madguds Жыл бұрын
Thank you so much for your incredibly wonderful and detailed explanation.
@stuartchitsulo3072
@stuartchitsulo3072 5 ай бұрын
You have been super in this video. Great job. I got what I was looking for. I thank you.
@betiiberii1698
@betiiberii1698 2 жыл бұрын
Excellent Job. God will bless your knowledge!!
@emmanuelkahilu1992
@emmanuelkahilu1992 2 жыл бұрын
Wow, so simplified. This is very educative.
@rashikakumari2621
@rashikakumari2621 2 жыл бұрын
Best video for multiple regression. Thank you so much sir
@yvetteburtworthington2540
@yvetteburtworthington2540 Жыл бұрын
the explanation of which parametric and nonparametric tests to use is priceless. Thank you.
@paulodhiambo4719
@paulodhiambo4719 2 ай бұрын
This clip saved my Dissertation. Keep up the good job
@livinusmaimako8517
@livinusmaimako8517 Жыл бұрын
Thanks prof. You have answered my questions. Keep up. We are waiting for time series and panel data. Thanks sir
@ezeadorchikaogochukwu5697
@ezeadorchikaogochukwu5697 Жыл бұрын
Great lesson, more grace.
@mkgeidam
@mkgeidam 2 жыл бұрын
Thanks for the video @Obezip simple and easy to understand
@GangsterNerd1
@GangsterNerd1 Жыл бұрын
Great video, well explained
@eleemaaireen8291
@eleemaaireen8291 11 күн бұрын
It’s really helpful, thank you💙
@sebastiancalderon2172
@sebastiancalderon2172 Жыл бұрын
just found both videos for this subject and omg you saved my life!!! thank you sooo much, such a good explanation
@obezipacademy
@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
@xasan4492 Жыл бұрын
Thank you for sharing knowledge
@rashedulislampapon6924
@rashedulislampapon6924 10 ай бұрын
Sir, I like the way you teach. I become proficient on spss regression analysis.
@abdallaabdurrahman2825
@abdallaabdurrahman2825 Ай бұрын
This is such a great video! Thank you sir, you just got yourself a new subscriber
@kennydavid4047
@kennydavid4047 2 жыл бұрын
Have been expecting this. Thanks alot😊
@kaylieepstein5394
@kaylieepstein5394 Жыл бұрын
You saved my life thank you so so so much for this
@thuovincent7556
@thuovincent7556 10 ай бұрын
Thank you. You have saved a life🤗
@crybaybie
@crybaybie 11 ай бұрын
Thank you so much for helping me understand ❤
@bigman6845
@bigman6845 2 жыл бұрын
brilliant video.
@flavioandrescallecalle5519
@flavioandrescallecalle5519 Ай бұрын
muchas gracias me ayudo mucho para mi tesis es genial la explicación
@obezipacademy
@obezipacademy Ай бұрын
Me alegra mucho saber que la explicación te fue de ayuda para tu tesis. ¡Mucho éxito con tu trabajo!
@zoltanhajba2780
@zoltanhajba2780 Жыл бұрын
Thank you, very detailed. As you can see. As you can see here :D
@ibrahimisrafilov1248
@ibrahimisrafilov1248 Жыл бұрын
I absolutely love it
@srabonahmad1774
@srabonahmad1774 3 ай бұрын
Thanks a lot Sir
@adaneersido
@adaneersido Жыл бұрын
thank you very much
@krishashah7407
@krishashah7407 Жыл бұрын
Thank you so much
@leonardo7019
@leonardo7019 Жыл бұрын
shouldn't you recodify variables with more than 2 categories in order to use them in the regression analysis?
@siobhan911
@siobhan911 2 ай бұрын
Lifesaver!
@teodoranevinglovschi8845
@teodoranevinglovschi8845 2 жыл бұрын
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
@obezipacademy Жыл бұрын
kzfaq.info/get/bejne/oLZ-lpyErNi1k3k.html
@kingsleykanjin3308
@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
@rashikakumari2621
@rashikakumari2621 2 жыл бұрын
What is the interpretation of Standard error of estimate in this table?
@yaregaltayelegesse2267
@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_josh
@tobi_josh 2 ай бұрын
Hello Sir, Why do we have to use Kolmogorov-Smirnov if our questionnaire are above 100? What is the explanation for this?
@mashupotato_
@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)
@obezipacademy
@obezipacademy 2 жыл бұрын
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.deluwarhoque2423
@md.deluwarhoque2423 2 жыл бұрын
Sir, may i request you to kindly share the PPT associated with this analysis and interpretation please?
@emmanuelebodum38
@emmanuelebodum38 Жыл бұрын
Thanks for this presentation. What if there is autocorrelation indicated from the Durbin_Watson Statistics? How will be corrected? Thanks
@obezipacademy
@obezipacademy Жыл бұрын
You can try logging your variables and then re-estimate
@kayehermida3752
@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
@obezipacademy Жыл бұрын
ANOVA can handle it. It will treat the independent likert scale variable as categorical variable.
@tekalignloranso7677
@tekalignloranso7677 9 ай бұрын
Plse make it vedio for determinants of aoplication of SIGTAS system
@DarkShadow
@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
@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
@DarkShadow Жыл бұрын
@@obezipacademy if that's the case, then I'll add 3 more questions on 2nd likert scale data, thank you.
@DarkShadow
@DarkShadow Жыл бұрын
@@obezipacademy oh wait, do you mean the amount of the answer options? I am using 5-point likert scale
@ayeahcalvin517
@ayeahcalvin517 2 жыл бұрын
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.
@obezipacademy
@obezipacademy 2 жыл бұрын
kzfaq.info/get/bejne/oZeaq9Zj3ce5iH0.html
@CriminologyMasterclass
@CriminologyMasterclass 2 жыл бұрын
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
@obezipacademy
@obezipacademy 2 жыл бұрын
Structural equation model(SEM) should suffice here
@md.deluwarhoque2423
@md.deluwarhoque2423 2 жыл бұрын
@@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?
@taregtareg273
@taregtareg273 11 ай бұрын
Is it corect to use regression with ordinal data?
@seraluna_
@seraluna_ Ай бұрын
Where can I download your powerpoint?
@chimwemwendovi8705
@chimwemwendovi8705 2 жыл бұрын
Sir, can you also share the PowerPoint
@ailsamcintosh6777
@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
@obezipacademy Жыл бұрын
Yes I know, but not everyone is conversant with that method...
@firozmp5757
@firozmp5757 Жыл бұрын
Normally distributed data. Use Linear regression
@reputeresearchcentre7755
@reputeresearchcentre7755 Жыл бұрын
Thanks so much prof. Any video on effects size ?
@obezipacademy
@obezipacademy Жыл бұрын
Effect size of what exactly?
@reputeresearchcentre7755
@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
@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
@obezipacademy Жыл бұрын
Majority carries the vote
@oliverpatrick3959
@oliverpatrick3959 Жыл бұрын
@@obezipacademy If its 2 sets each?
@yaregaltayelegesse2267
@yaregaltayelegesse2267 6 ай бұрын
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
@obezipacademy
@obezipacademy 6 ай бұрын
I'll make a video on this soon
@obezipacademy
@obezipacademy 6 ай бұрын
You can watch my video on ordinal regression here : kzfaq.info/get/bejne/oZeaq9Zj3ce5iH0.htmlsi=y4AjiFfGQMeRjRuj
@aduseivanessa5686
@aduseivanessa5686 11 ай бұрын
@obezipacademy please what if some of the variables are normally distributed and some are not?
@obezipacademy
@obezipacademy 11 ай бұрын
The dependent variable has to be normally distributed. More so, majority carries the vote
@aduseivanessa5686
@aduseivanessa5686 11 ай бұрын
So when majority is normally distributed , you use linear regression?
@kwarbai1
@kwarbai1 2 жыл бұрын
what do you do when some series are Normally distributed and some are not in the same model?
@obezipacademy
@obezipacademy 2 жыл бұрын
If most of ur series are not normally distributed, you adopt ordinal regression technique
@wekesasanduku8909
@wekesasanduku8909 2 жыл бұрын
@@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
@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
@zuwairat Жыл бұрын
Why is that necessary if I may ask?
@amamclinton1511
@amamclinton1511 Жыл бұрын
@@zuwairat I learnt that on some other videos on YT
@mervinchipeta514
@mervinchipeta514 2 жыл бұрын
I wish you were my stats teacher
@obezipacademy
@obezipacademy 2 жыл бұрын
Aww. Don't worry, I'm developing a book on Applied Statistics and Research Techniques...it will ready by first quarter of 2023
@mervinchipeta514
@mervinchipeta514 2 жыл бұрын
@@obezipacademy excellent am sure you econometrics students enjoy your course. You explain stats with great command and ease
@obezipacademy
@obezipacademy 2 жыл бұрын
I'm sure they do. Many thanks for your complement
@benjaminchamadenga9223
@benjaminchamadenga9223 2 жыл бұрын
@@obezipacademy kindly share your email. Need assistance on data analysis
@matthewvictor9154
@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
@obezipacademy Жыл бұрын
Those codes are responses from each respondents.
@AvC-wg3fj
@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
@DisappearingBoy2010
@DisappearingBoy2010 10 ай бұрын
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?
How to Calculate the Range of LIKERT-SCALE Data
11:14
Obezip Academy
Рет қаралды 4,1 М.
Analyze Likert Scale Data this way as Ordinal Measure in SPSS
17:37
Titocan Mark Solutions
Рет қаралды 14 М.
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 78 МЛН
Русалка
01:00
История одного вокалиста
Рет қаралды 6 МЛН
Normality Test with Likert Scale Data in SPSS
20:06
Ugochukwu Chinonso Okolie
Рет қаралды 17 М.
Likert scale survey data analysis and interpretation on Excel and SPSS
1:09:35
EViews: LIKERT-SCALE Data Regression Analysis using EViews
20:20
Obezip Academy
Рет қаралды 2,4 М.
SPSS: How to Analyse and Interpret LIKERT-SCALE Questionnaire Using SPSS
31:03
The BEST way to analyse Likert scale surveys
14:58
Mohamed Benhima
Рет қаралды 26 М.
Multiple Regression (Hierarchical) with 5 point Likert Scale Data in SPSS.
1:01:32
Ugochukwu Chinonso Okolie
Рет қаралды 17 М.
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 78 МЛН