Chi Square Test for Independence Using Excel || Data Analysis in MS Excel

Data Analysis in MS Excel Playlist:
• Data Analysis in MS Excel
Business Statistics Playlist:
• Business Statistics
Math in the Modern World Playlist:
• Mathematics in the Mod...
Integral Calculus in Filipino Playlist: • Integral Calculus in F...
Plane Trigonometry Playlist:
• Plane Trigonometry
#MATHuklasanWithSirRam #ChiSquare #DataAnalysisinMSExcel

[@faucin440]

Thank you for the link, Sir Ram!

[@katherinejessicam.estabill8503]

Thank you po

[@gellasan]

Thank you for this, sir Ram! question po regarding making the null hypothesis for Chi Square. Ang Ho po ba lagi a 'no relationship between two variables'? Salamat po ulet!

[@johnkevinpadro7819]

Hi Sir @Mathuklasan with Sir Ram, saan po ba makakuha yun data na ginamit mo Sir?

[@indujav6897]

Does the value change when it is performed in spss software..!?

[@MathuklasanwithSirRam]

Not necessarily, as long as you will not round off the values. Here's the link of my SPSS tutorial for additional reference :) Thanks! kzbin.info/www/bejne/qIrCpK2nlphsi5o

[@mariaaimeerodriguez8181]

Good afternoon, Sir! Thank you very much for this explanation. May I ask permission if I can request for the copy of data? Will just use it po for educational purposes. Thank you very much po.

[@usmankhalid9370]

Can you this test or goodness of fit or any other test to on lottery to check if their selection has been biased or not?

[@suzettesaniel4343]

I got lost in the degrees of freedom. If I have five groups (courses), then my df should just be 4 right?

[@mid0rri411]

sir does this still apply if my Ho is testing whether there is a significant difference?

[@edemardelavin1226]

hello sir, saan yung reference natin na pag ang chi square ay less than sa critical value, then the would answer be reject the hypothesis? yung iba kasing video tutorial pag less than yung chi square sa critical value kailangan daw i reject si null hypothesis? medyo confusing po ano po ang tama?

[@11stem2lactaotaoianrenz3]

Paano po kung parehas ng 0.05 ung p value and level of significance?

[@trisandaffa]

Sir, my observed value have 0 score. And I cannot make the chi square test because if I do that with 0 score it will be error, what should I do? Thank you sir, hope you will answer this question cause I’m really confused😭

[@MathuklasanwithSirRam]

If you mean 0in one of the cells po, you may adjust your range kung numerical po gamit nyo to identify the frequency (like Age). Kung categorical nman po, Try nyo po omit ung may zero na cell then icombine sa ibang cells.

[@ongcarmelaa.4296]

Hi po. Paano pag maraming categories?

[@MathuklasanwithSirRam]

If you mean number of groups per category, ok lng po basta more than 2 at ung expected table ay laging greater than 5 po ang value.

[@adyli]

@@MathuklasanwithSirRam pano po pag less than 5 yung value ng ibang cells sa unexpected table? Ibang test na po ba? based on what I've research po kasi yung applicable na test po kasi samin is Chi-squared since 30 respondents lang po kami pero marami variables. (Gender & Frequency of SHS Exposure)

[@alyzzughh]

@@MathuklasanwithSirRam Hello Sir, same question po, paano po kapag less than 5 na yung value in one of the cells in expected data? Hindi na po ba applicable ang Chi-Square test? And if not, anong test na po ang gagamitin as alternative? Thank you po Sir, your response will be appreciated 💜🙏