# Technology Guide for Teaching Statistics

## Stephanie Casey and Andrew RossMath Dept.Eastern Michigan University

Please note that we (Casey and Ross) are just linking to tutorials that other people have created.

### Activity 2

• 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.

### Activity 3

The usual technologies (Excel, Fathom, etc.) are not relevant to this activity.

### Activity 5

The usual technologies (Excel, Fathom, etc.) are not relevant to this activity.

### Activity 7

The usual technologies (Excel, Fathom, etc.) are not relevant to this activity.

### Activity 8

• 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