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

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ส.ค. 2024
  • How to Analyse LIKERT-SCALE Data Using Regression, Descriptive Statistics and Correlation in Excel and SPSS.

ความคิดเห็น • 92

  • @tarapoudel9506
    @tarapoudel9506 5 วันที่ผ่านมา

    Thank you Sir, this is the video helps me for my research, God bless you 🙏🙏🙏🙏🙏🙏🙏🙏

  • @tiegomotswedi6526
    @tiegomotswedi6526 4 หลายเดือนก่อน +3

    You saved my dissertation life

  • @sanusiakeem9252
    @sanusiakeem9252 ปีที่แล้ว +7

    Thanks for adding values to human life through your transformational teaching. May God reward limitlessly

  • @davidowuamanam1286
    @davidowuamanam1286 3 หลายเดือนก่อน

    The best on TH-cam! Hands down and clear for all to understand. Cheers.

  • @chethanaamukotuwa4015
    @chethanaamukotuwa4015 9 หลายเดือนก่อน +1

    Thanks a lot. Because of this video I did my final year thesis successfully❤

  • @paulodhiambo4719
    @paulodhiambo4719 4 หลายเดือนก่อน

    This clip saved my Dissertation. Keep up the good job

  • @rashikakumari2621
    @rashikakumari2621 2 ปีที่แล้ว +1

    Best video for multiple regression. Thank you so much sir

  • @yvetteburtworthington2540
    @yvetteburtworthington2540 2 ปีที่แล้ว +3

    the explanation of which parametric and nonparametric tests to use is priceless. 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

  • @stuartchitsulo3072
    @stuartchitsulo3072 7 หลายเดือนก่อน

    You have been super in this video. Great job. I got what I was looking for. I thank you.

  • @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.

  • @rashedulislampapon6924
    @rashedulislampapon6924 11 หลายเดือนก่อน

    Sir, I like the way you teach. I become proficient on spss regression analysis.

  • @abdallaabdurrahman2825
    @abdallaabdurrahman2825 2 หลายเดือนก่อน

    This is such a great video! Thank you sir, you just got yourself a new subscriber

  • @betiiberii1698
    @betiiberii1698 2 ปีที่แล้ว

    Excellent Job. God will bless your knowledge!!

  • @ezeadorchikaogochukwu5697
    @ezeadorchikaogochukwu5697 ปีที่แล้ว

    Great lesson, more grace.

  • @madguds
    @madguds ปีที่แล้ว

    Thank you so much for your incredibly wonderful and detailed explanation.

  • @GangsterNerd1
    @GangsterNerd1 ปีที่แล้ว

    Great video, well explained

  • @xasan4492
    @xasan4492 ปีที่แล้ว

    Thank you for sharing knowledge

  • @emmanuelkahilu1992
    @emmanuelkahilu1992 2 ปีที่แล้ว

    Wow, so simplified. This is very educative.

  • @livinusmaimako8517
    @livinusmaimako8517 2 ปีที่แล้ว

    Thanks prof. You have answered my questions. Keep up. We are waiting for time series and panel data. Thanks sir

  • @thuovincent7556
    @thuovincent7556 11 หลายเดือนก่อน

    Thank you. You have saved a life🤗

  • @mkgeidam
    @mkgeidam 2 ปีที่แล้ว

    Thanks for the video @Obezip simple and easy to understand

  • @flavioandrescallecalle5519
    @flavioandrescallecalle5519 3 หลายเดือนก่อน

    muchas gracias me ayudo mucho para mi tesis es genial la explicación

    • @obezipacademy
      @obezipacademy  3 หลายเดือนก่อน

      Me alegra mucho saber que la explicación te fue de ayuda para tu tesis. ¡Mucho éxito con tu trabajo!

  • @kaylieepstein5394
    @kaylieepstein5394 ปีที่แล้ว

    You saved my life thank you so so so much for this

  • @crybaybie
    @crybaybie ปีที่แล้ว

    Thank you so much for helping me understand ❤

  • @siobhan911
    @siobhan911 4 หลายเดือนก่อน

    Lifesaver!

  • @ibrahimisrafilov1248
    @ibrahimisrafilov1248 ปีที่แล้ว

    I absolutely love it

  • @kennydavid4047
    @kennydavid4047 2 ปีที่แล้ว

    Have been expecting this. Thanks alot😊

  • @bigman6845
    @bigman6845 2 ปีที่แล้ว

    brilliant video.

  • @srabonahmad1774
    @srabonahmad1774 5 หลายเดือนก่อน

    Thanks a lot Sir

  • @zoltanhajba2780
    @zoltanhajba2780 ปีที่แล้ว

    Thank you, very detailed. As you can see. As you can see here :D

  • @adaneersido
    @adaneersido ปีที่แล้ว

    thank you very much

  • @krishashah7407
    @krishashah7407 ปีที่แล้ว

    Thank you so much

  • @tobi_josh
    @tobi_josh 3 หลายเดือนก่อน

    Hello Sir,
    Why do we have to use Kolmogorov-Smirnov if our questionnaire are above 100? What is the explanation for this?

  • @seraluna_
    @seraluna_ 2 หลายเดือนก่อน

    Where can I download your powerpoint?

  • @teodoranevinglovschi8845
    @teodoranevinglovschi8845 2 ปีที่แล้ว +1

    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  2 ปีที่แล้ว

      th-cam.com/video/jPNc9SGrQcE/w-d-xo.html

  • @rashikakumari2621
    @rashikakumari2621 2 ปีที่แล้ว

    What is the interpretation of Standard error of estimate in this table?

  • @leonardo7019
    @leonardo7019 ปีที่แล้ว

    shouldn't you recodify variables with more than 2 categories in order to use them in the regression analysis?

  • @taregtareg273
    @taregtareg273 ปีที่แล้ว

    Is it corect to use regression with ordinal data?

  • @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?

  • @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

  • @tekalignloranso7677
    @tekalignloranso7677 10 หลายเดือนก่อน

    Plse make it vedio for determinants of aoplication of SIGTAS system

  • @CriminologyMasterclass
    @CriminologyMasterclass 2 ปีที่แล้ว +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 ปีที่แล้ว +1

      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?

  • @aduseivanessa5686
    @aduseivanessa5686 ปีที่แล้ว

    @obezipacademy please what if some of the variables are normally distributed and some are not?

    • @obezipacademy
      @obezipacademy  ปีที่แล้ว

      The dependent variable has to be normally distributed. More so, majority carries the vote

    • @aduseivanessa5686
      @aduseivanessa5686 ปีที่แล้ว

      So when majority is normally distributed , you use linear regression?

  • @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

  • @mashupotato_
    @mashupotato_ 2 ปีที่แล้ว +1

    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 ปีที่แล้ว +1

      Watch this video on how to Choose Appropriate Statistical Technique for Data Analysis:
      th-cam.com/video/jPNc9SGrQcE/w-d-xo.html
      You can also add Rank correlation analysis to your analysis

  • @firozmp5757
    @firozmp5757 2 ปีที่แล้ว

    Normally distributed data. Use Linear regression

  • @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...

  • @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..

  • @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  ปีที่แล้ว +1

      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

  • @yaregaltayelegesse2267
    @yaregaltayelegesse2267 8 หลายเดือนก่อน

    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  8 หลายเดือนก่อน

      I'll make a video on this soon

    • @obezipacademy
      @obezipacademy  8 หลายเดือนก่อน

      You can watch my video on ordinal regression here : th-cam.com/video/k1jxs2xaUXI/w-d-xo.htmlsi=y4AjiFfGQMeRjRuj

  • @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 ปีที่แล้ว

      th-cam.com/video/k1jxs2xaUXI/w-d-xo.html

  • @mervinchipeta514
    @mervinchipeta514 2 ปีที่แล้ว

    I wish you were my stats teacher

    • @obezipacademy
      @obezipacademy  2 ปีที่แล้ว +1

      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

  • @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.

  • @chimwemwendovi8705
    @chimwemwendovi8705 2 ปีที่แล้ว

    Sir, can you also share the PowerPoint

  • @md.deluwarhoque2423
    @md.deluwarhoque2423 2 ปีที่แล้ว

    Sir, may i request you to kindly share the PPT associated with this analysis and interpretation please?

  • @oliverpatrick3959
    @oliverpatrick3959 2 ปีที่แล้ว

    What do we do if our dataset comprises data that turns out to be both normal and not normal? Which analysis do we use?

  • @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

  • @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  ปีที่แล้ว +1

      Those codes are responses from each respondents.

  • @AvC-wg3fj
    @AvC-wg3fj 3 หลายเดือนก่อน

    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 ปีที่แล้ว

    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?