Two Way Frequency Excel Spreadsheet:
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
- Modify column and row headings to match your data.
- Input joint frequency data.
- Click the second tab at the bottom of the window to see the automatic calculations.
Type: Educational Software / Tool