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

Поделиться
HTML-код
  • Опубликовано: 24 дек 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!

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

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

  • @whatisleansixsigmabydr.sal4884
    @whatisleansixsigmabydr.sal4884 10 месяцев назад

    Excellent explanation

  • @EricD_192
    @EricD_192 2 года назад +1

    Best explanation! Thank you!!

  • @aggyigecha5942
    @aggyigecha5942 2 года назад +1

    This was really helpful. Good job

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

  • @Everyjb
    @Everyjb 4 года назад +1

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

  • @kossonouprunelle7576
    @kossonouprunelle7576 3 года назад +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  3 года назад

      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: ruclips.net/video/chgijGUVN7g/видео.html

    • @kossonouprunelle7576
      @kossonouprunelle7576 3 года назад +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  3 года назад

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

  • @richardclarke7950
    @richardclarke7950 3 года назад +1

    Really clear exposition - thanks

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

  • @sombhoog3996
    @sombhoog3996 3 года назад +1

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

  • @divyajacob5553
    @divyajacob5553 3 года назад +1

    Thanks a lot. I tried this. Really helpful

  • @reascharf5377
    @reascharf5377 8 месяцев назад

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

  • @nathanielbughar745
    @nathanielbughar745 4 года назад +1

    You just saved my life. Thank You.

    • @NEDLeducation
      @NEDLeducation  4 года назад

      Hello Nathaniel, glad it was helpful! :)

  • @galymzhankyrykbaev2976
    @galymzhankyrykbaev2976 3 года назад +1

    thank God i met tgis channel!

  • @pragyaagrawal6772
    @pragyaagrawal6772 9 месяцев назад

    super helpful, thank you!

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

  • @SwedishRagers
    @SwedishRagers 3 года назад

    Best video ever on this. Thank you!

  • @ravimaurya2335
    @ravimaurya2335 3 года назад +1

    Thank you so much

  • @montaserhamid7039
    @montaserhamid7039 4 года назад

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

    • @NEDLeducation
      @NEDLeducation  4 года назад

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

  • @khaledgh7086
    @khaledgh7086 3 года назад +1

    thank you very much

  • @gp5607
    @gp5607 4 года назад

    Great V!ideo!!! Thanks alot!

  • @degsewtube8701
    @degsewtube8701 3 года назад +1

    great

  • @vatsal_kanth
    @vatsal_kanth 3 года назад

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