Google Sheets: Performing a Chi-Squared Test

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ก.ย. 2024

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

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

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

  • @maxcullen3160
    @maxcullen3160 4 ปีที่แล้ว +24

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

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

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

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

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

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

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

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

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

      Glad that you found it useful, Nicole!

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

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

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

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

  • @user-su6rx1of8r
    @user-su6rx1of8r 10 หลายเดือนก่อน +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?

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

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

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

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

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

      Wanna send me your IA😂😂

  • @_aleda_
    @_aleda_ 6 หลายเดือนก่อน

    I can't thank you enough for this video.

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

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

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

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

  • @hamoodi3772
    @hamoodi3772 4 ปีที่แล้ว +2

    This video helped a ton! Thank you so much !

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

      Glad it was useful, Mohammad!

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

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

    Thank you, your video helped me a lot.

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

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

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

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

    This was soo helpful thank you so much 🙏🏾

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

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

    What a video man

  • @mohamed.montaser
    @mohamed.montaser 3 ปีที่แล้ว

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

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

    This is a lifesaver!

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

      Thanks, Joshua. Glad to be of help!

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

    This is great thank you soooooo much

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

    What if one Of the numbers is zero?

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

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

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

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

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

    Thank you

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

    Excelent!