This Excel spreadsheet allows the educator to input data into a two way frequency table and have the resulting relative frequency charts calculated automatically on the second sheet. This resource will assist the educator in checking student calculations on student-generated data quickly and easily.

Steps to add data: All data is input on the first spreadsheet; all tables are calculated on the second spreadsheet

1. Modify column and row headings to match your data.
2. Input joint frequency data.
3. Click the second tab at the bottom of the window to see the automatic calculations.