Conducting a chi square test on a pivot table in Microsoft Excel

How to produce a pivot table and test its percentages with a chi-square in Microsoft Excel 2010. Part of the free Excel Stats Minicourse at mtweb.mtsu.edu/kblake.

[@bartazar01]

God bless you, man. This is what I came for. Very nice explanation. You helped me a great deal.

[@ritwiktrivedi]

This video helped a lot. If your stuck with chi square test analysis... watch this... and you'll be unstuck.

[@varnagyzsombor]

Nice, clear cut tutorial on sensible data.

[@somcana]

Short and sweet. Thanks

[@hannahkrupa1208]

This was so helpful! Thank you

[@michaelnielsen3672]

what a legend. so clear.

[@jenniferfinn2796]

❤❤❤❤

[@adat1988]

professional and very helpful

[@rothergaudiel2549]

Thank you very much! :)

[@ezquerzelaya]

I think this is a ridiculously basic question, but in my case I've got a table clearly indicating that x and y have no cause-effect relation (it's very evenly distributed), yet the expected value is tremendously close to the observed value, so my chisqr test gives me a very low value. What does this mean?