Google Sheets: Performing a Chi-Squared Test

Поделиться
HTML-код
  • Опубликовано: 21 янв 2025

Комментарии • 41

  • @nate78910
    @nate78910 Год назад +2

    thank you sir. three years later and you are saving my grade!

  • @maxcullen3160
    @maxcullen3160 5 лет назад +25

    No joke you saved my IA! Thank you so much!

    • @strangerist2
      @strangerist2  5 лет назад +4

      Glad to be of help, Max. Hope you get a good grade!

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

    THANK YOU SO MUCH, you have single handedly saved me from failing physics, if I ever get into my dream school I will come back and thank you 😃!!!

  • @georgewilliam9118
    @georgewilliam9118 4 года назад +4

    Thank you so much. You explained it in a way where I completely understood everything that you where saying and could follow along with my own chi square test

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

      My pleasure, George! I'm glad that you found it helpful.

  • @SamiaAfif-OXF.Student
    @SamiaAfif-OXF.Student Год назад +1

    Hello, thank you for the video. What about if the test statistics check is not the same as the one found before. What should I do?

  • @manishachoudhary1938
    @manishachoudhary1938 6 месяцев назад

    Literally thanks alot
    I am trying to find the p value from last 1week
    You made it possible for me
    Thankyou so much❤

  • @NikNak-19
    @NikNak-19 4 года назад +3

    I'm so glad I found this. Thank you for posting! It all makes sense now!

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

      Glad that you found it useful, Nicole!

  • @maxbelmar2360
    @maxbelmar2360 4 года назад +3

    Thank you SO much! I have been working on my IA and this video was so helpful. Really appreciate it!

  • @samarachaplain
    @samarachaplain 4 года назад +2

    thank you eleven bottles this saved me and my ia!!!!!!!!!!! so helpful and came at the perfect time

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

      Glad to be of help, Samara. And that's quite an honour!

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

      Wanna send me your IA😂😂

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

    Wow you are such a good English native speaker!!!

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

    Hello, I have a 2x2 table and was wondering if you could elaborate on the correction you mentioned.

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

    this was really helpful! but my p-value is 0 so when I tried to check if it was correct it showed an error, what do I do there?

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

    hello, i have some zeroes in my table, so i cannot run the chi square test, can you help? idk what to do, have a dissertation due on monday thanks @eleven bottles

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

      Hi, presumably you mean you have zeros in your "observed values" table. That shouldn't be a problem unless it causes to to have too many low (less than 5) "expected values". It's not really a problem about the spreadsheet, more about the conditions for the test, so I suggest you read up on the theory behind it. One thing you could do is to combine rows and/or columns that only have a few responses, but I can't help much without more information.

  • @_aleda_
    @_aleda_ 10 месяцев назад

    I can't thank you enough for this video.

  • @mohamed.montaser
    @mohamed.montaser 3 года назад

    can you explain the calculation you did when you created the expected table?

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

    Thanks... Proper explanation.... You made my day easy

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

    Thank you- very helpful video! what happens if the p-value in the "check" is different?

    • @strangerist2
      @strangerist2  2 года назад +2

      Thank you! Sorry to tell you that, if the two values aren't the same, then you've probably made a mistake in the formulas, and you'll have to check each one. Sorry!

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

    THANK YOU!! it helped me so much!!!

  • @hamoodi3772
    @hamoodi3772 5 лет назад +2

    This video helped a ton! Thank you so much !

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

    Hi there. I've tried this, however, I have some observed value cells that have the value of 0. Since I cannot divide by 0 what should I do?

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

    What if one Of the numbers is zero?

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

      That's more about the test methodology that the spreadsheet. If an observed value is 0 it might not be a problem, but if an expected value is 0 then there might be a problem with your data collection. You should probably just ignore the row/column of the table which has nothing in it.

  • @caesumisrude
    @caesumisrude 3 года назад +4

    Thank you! I needed to understand this test for some statistics I need in my master's thesis. This video made it possible for me to perform and understand the chi test. I have one question though, do you recommend any alternative to chi test for tables bigger than 2x2, which have observed values lower than 1? I cannot find anything that I could do in Excel.

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

    Thank you, your video helped me a lot.

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

    This was soo helpful thank you so much 🙏🏾

  • @satishkasalwar7930
    @satishkasalwar7930 2 года назад

    What a video man

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

    Thank you so much for this video!!! The explanation was quite simple and straight forward!

  • @joshuaagpawa4098
    @joshuaagpawa4098 5 лет назад +3

    This is a lifesaver!

    • @strangerist2
      @strangerist2  5 лет назад

      Thanks, Joshua. Glad to be of help!

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

    This is great thank you soooooo much

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

    Thank you

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

    Excelent!