Chi-squared test - testing for relationships between categorical variables (Excel)

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ส.ค. 2024

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

  • @NEDLeducation
    @NEDLeducation  4 ปีที่แล้ว +3

    You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7
    Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation

  • @marcellberto2538
    @marcellberto2538 3 ปีที่แล้ว +6

    I love how you so eloquently not only the essence of a chi-squared test but also the foundation of statistical concepts like degrees of freedom. You’ve done a far better job than the university courses and textbooks I’ve come across. Well done!

    • @NEDLeducation
      @NEDLeducation  3 ปีที่แล้ว

      Hi Marcell, and thanks so much for the kind words. Stay around for more videos in statistics!

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

    Your videos must be compulsary in all universties in the world

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

    You legit just saved my life! This has been so beyond helpful, easy to understand, and engaging. Working on my thesis now doesn't seem so bleak anyone. Thank you thank you thank you :D

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

    Best explanation! Thank you!!

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

    I am watching multiple videos right now and you are amazing.

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

      Hi Pranjal, and glad you are enjoying the channel! Stay tuned for more content over the summer :)

  • @whatisleansixsigmabydr.sal4884
    @whatisleansixsigmabydr.sal4884 6 หลายเดือนก่อน

    Excellent explanation

  • @Everyjb
    @Everyjb 3 ปีที่แล้ว +1

    How does this guy only have 1.7k subs?! Great content!

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

    super helpful, thank you!

  • @sombhoog3996
    @sombhoog3996 3 ปีที่แล้ว +1

    you are a life-saver....the BEST!! thanks so much

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

    This was really helpful. Good job

  • @richardclarke7950
    @richardclarke7950 3 ปีที่แล้ว +1

    Really clear exposition - thanks

  • @nathanielbughar745
    @nathanielbughar745 4 ปีที่แล้ว +1

    You just saved my life. Thank You.

    • @NEDLeducation
      @NEDLeducation  4 ปีที่แล้ว

      Hello Nathaniel, glad it was helpful! :)

  • @divyajacob5553
    @divyajacob5553 3 ปีที่แล้ว +1

    Thanks a lot. I tried this. Really helpful

  • @galymzhankyrykbaev2976
    @galymzhankyrykbaev2976 3 ปีที่แล้ว +1

    thank God i met tgis channel!

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

    Can you do a video on if the two variables are ordinal instead of nominal

  • @SwedishRagers
    @SwedishRagers 3 ปีที่แล้ว

    Best video ever on this. Thank you!

  • @ravimaurya2335
    @ravimaurya2335 3 ปีที่แล้ว +1

    Thank you so much

  • @khaledgh7086
    @khaledgh7086 3 ปีที่แล้ว +1

    thank you very much

  • @montaserhamid7039
    @montaserhamid7039 4 ปีที่แล้ว

    Great Video!!.You saved my day!! Carry On Brother

    • @NEDLeducation
      @NEDLeducation  4 ปีที่แล้ว

      Hi, thanks, glad the video was helpful! :)

  • @zamzamour1069
    @zamzamour1069 3 ปีที่แล้ว +1

    Thank you very much for the explanations. Any reasons behind not using the pivot tables and the formula readily available in Excel for P?

    • @NEDLeducation
      @NEDLeducation  3 ปีที่แล้ว +1

      Hi Zam, and glad the video helped! As for your question, I just wanted to show the process the easiest way possible just using basic functions and not relying on advanced tools. So if you want to compile the contingency tables using pivots, it is absolutely fine.

    • @zamzamour1069
      @zamzamour1069 3 ปีที่แล้ว +1

      @@NEDLeducation Ok! It made me doubt! The video is really very good and to the point.
      Thanks for the effort and quality!

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

    Thank you for the presentation. I have both nominal and ordinal independent variables (4) with (2) ordinal dependent variables . Please which one should i choose between Spearman correlation and Chi-square test to analyze the association or relationship between the variables ? Thanks

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

      Hi, and glad you enjoyed the video! It seems that Chi-squared test is more appropriate in your case. I have got a video on Spearman correlation as well, however, so do check it out if you are interested: th-cam.com/video/chgijGUVN7g/w-d-xo.html

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

      @@NEDLeducation Thank you for your reply. I will check the video about Spearman correlation. Is it possible to have the two analysis in my work? i mean doing chi-square to see the relationship between the 2 nominal independent variables and the dependent variables and use the spearman correlation to see the relationship between the 2 ordinal independent variable and the dependent variable.

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

      @@kossonouprunelle7576 Yes, it is possible, I do not see anything wrong with it as it is.

  • @rizzuz
    @rizzuz 4 ปีที่แล้ว +1

    Hi! What if I want to determine the relationship between a categorical variable and a numerical variable?
    I was tasked to determine the relationship between proportion of times I correctly judged that the test probe was on the list (dependent variable) and the type of cue at study / test cue (independent variable). The data I have are literally just on the proportion of times I guessed correctly and the categories (Weak/Weak, Weak/Strong, Strong/Weak, Strong/Strong, and Lure).
    How will I compute for the correlation?

    • @NEDLeducation
      @NEDLeducation  4 ปีที่แล้ว

      Hi Hannah and many thanks for the question! There is a number of ways to approach this.
      If you want to apply the Chi-squared test, you can separate your numerical variable into quintiles and test for association between quintiles and categorical variables. However, for it to work the best, you need a relatively high number of observations.
      Alternatively, you can use the one-way ANOVA to compare variance of the numerical variable between groups and within groups. If the former is sufficiently high, the effect of the categorical variable can be considered significant.
      Lastly, you can code a set of dummy variables based on your categories and run a simple regression. If the F-stat of the regression is significant, you then can infer that the categorical variable is meaningful in terms of explaining variation. Hope it helps!

  • @futurestradinginunder7minu872
    @futurestradinginunder7minu872 4 ปีที่แล้ว +1

    Excellent video as always! One of the requirements for using the t-test is that the sample be independent. (I think that is correct, and I stated it properly.) Should I be applying Chi-squared test to evaluate independence? Is this similar to testing for autocorrelation? Thanks!

    • @NEDLeducation
      @NEDLeducation  4 ปีที่แล้ว

      Hi and many thanks for the feedback! As for your question, it needn't be that the samples are independent for a t-test. For example, a paired t-test can be used to evaluate the significance of differences on a matched sample (whether the return of one portfolio is greater than the return of another portfolio on a day-by-day basis, for example). So t-test is perfectly applicable even when samples are not independent, you just have to adjust for dependence when calculating the variance. Chi-squared test is mainly used to test independence for categorical variables, however it can also be applied to quantitative data if you sort it into quartiles (for example, are returns below zero and above zero of two portfolios are associated). Hope it helps!

  • @gp5607
    @gp5607 4 ปีที่แล้ว

    Great V!ideo!!! Thanks alot!

  • @degsewtube8701
    @degsewtube8701 3 ปีที่แล้ว +1

    great

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

    Insightful or not?
    Ho = not insightful
    watch video = hypothesis testing
    null hypothesis rejected. 99% confidence.