Excel Instructions: Test of Independence Using Technology
Next we will use Excel to calculate the expected counts:
- Create a table for expected counts with the same row and column headings as the one above, and use the formula Expected Count = (Column Total * Row Total)/Table Total.