No video :(

Google Sheets: Performing a Chi-Squared Test

Подписаться 478

Просмотров 86 тыс.

50% 1

This video explains how to perform a Chi-Squared test of independence on a two-way table using Google Sheets. The techniques will also work on other spreadsheets.
The intended audience is IBDP mathematics students, particularly those taking the Mathematical Studies course or the new "Applications & Interpretation" course from 2019.
The video shows how to calculate the test statistic without using the built-in functions.

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@nate78910 Год назад

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

@manishachoudhary1938 15 дней назад

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

@maxcullen3160 4 года назад

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

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

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

@georgewilliam9118 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 4 года назад

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

@Nlink2012 3 года назад

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

@strangerist2 3 года назад

Glad that you found it useful, Nicole!

@dansmagicalcreations2162 3 года назад

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 😃!!!

@maxbelmar2360 3 года назад

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

@strangerist2 3 года назад

Glad to be of help!

@lampistand 2 месяца назад

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

@richardhiggins4843 3 года назад

This was soo helpful thank you so much 🙏🏾

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

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

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

Thank you, your video helped me a lot.

@hamoodi3772 4 года назад

This video helped a ton! Thank you so much !

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

Glad it was useful, Mohammad!

@user-su6rx1of8r 9 месяцев назад

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?

@thraiamercadejas_ 2 года назад

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

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

I can't thank you enough for this video.

@miguelgrageda1 2 года назад

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

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

This is great thank you soooooo much

@amihearts4230 Год назад

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?

@caesumisrude 2 года назад

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.

@samarachaplain 3 года назад

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

@strangerist2 3 года назад

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

@nikolutkauskas5126 3 года назад

Wanna send me your IA😂😂

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

What a video man

@keyshlanarvaez6921 2 года назад

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

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

@Stalinbiotech 2 года назад

Thank you

@jenyladyfuentesgamboa8558 2 года назад

Excelent!

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

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

@joshuaagpawa4098 4 года назад

This is a lifesaver!

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

Thanks, Joshua. Glad to be of help!

@clarke6814 2 года назад

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

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

@jyotiradityavirdi5075 2 года назад

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 2 года назад

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.

@wekicksome 2 года назад

What if one Of the numbers is zero?

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

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.