Math Dept.

Eastern Michigan University

- Fathom: see "Work with Case Tables" and "Work with Summary Tables" in Fathom Help.
- Excel: use a PivotTable to convert a case table to a contingency table: Chi-sq. in Excel, Pt. 1: Making the contingency table
- TI-84: use the program "CROSSTAB"; search for CROSSTAB inside ti84plus.pdf and calculator.pdf. It generates the joint, marginal, and conditional relative frequencies for you.

- Fathom:
- To compute the joint and marginal relative frequencies in a Summary Table: right click where it says "S1=count" and choose Edit Formula. Inside the formula editor, press the "divide" button. Then, in the scrolling list, choose Special->grandTotal; double-click on it so it becomes the denominator. The formula should be: count()/grandTotal. Then click OK.
- To compute the conditional relative frequencies in a Summary Table: right click where it says "S1=count" and choose Edit Formula. Inside the formula editor, in the scrolling list, choose Special->columnProportion or rowProportion as needed; double-click on it so it replaces the "count" formula, then click OK.

- Excel: you can compute the joint, marginal, and conditional relative frequencies by changing what the pivot table shows: To see how to show each cell as a percent of the column total (or row total, or grand total): Chi-sq. in Excel, Pt. 1: Making the contingency table Note that when it computes percents of column totals, it still has a column in the right margin of the table that shows the marginal relative frequencies. These are not the same as the sum of each row. In our classroom materials we put NA in those positions.

- Excel:
- Comparative bar chart (note: it's important to use the column or row relative frequencies)
- Create a Stacked Column or Bar Chart (note: it's important to use the counts or joint relative frequencies, not the column or row relative freq.)
- Mosaic plots (what Fathom calls a Ribbon plot) are not available in Excel.

- Fathom: Working with Categorical Data
- TI-84: for comparative bar charts, use the program GROUPBAR; search for GROUPBAR inside calculator.pdf

- Excel: Computing the Expected version of the table (note that this video uses view 2 of computing Expected values, but switches rows and columns) Chi-sq. in Excel, Pt. 2: Calculating expected frequencies
- Fathom: See "Test for Independence from Raw Data" in the Fathom Help file.
- Fathom: To compute the Expected frequencies in a Summary Table: right click where it says "S1=count" and choose Edit Formula. Inside the formula editor, in the scrolling list, choose Special->expected; double-click on it so it replaces the "count" formula, then click OK.
- TI-83/TI-84: Use Chi-Square (X^2) Test for Contingency Table, or see Independence Calc Notes pdf file

- Excel: The setup for resampling in Excel is fairly involved. Ask your instructor for the resampling template that the authors made.
- Fathom: see "Use Scrambling to Test for Independence" in the Fathom Help file