A two-way table shows the frequency of data which satisfies two variables. Each row represents one variable, and each column represents another.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

Two-Variable Data Table. Setting Up a Two-Variable Data Table: List one set of values horizontally and the other set vertically. Enter the formula above the vertical list of values.

In this KS1 Maths article you'll learn how to read data tables and tally charts. We also have KS1 videos, a quiz and lots of examples.

Key Points Discrete data is categorical data, rather than continuous measurements. It can be treated as continuous data, but ...