Tutorials › AP Statistics › Reading a Data Table: Rows, Columns, and Cases

Variables and investigative questions · Tutorial 7 of 1000

Reading a Data Table: Rows, Columns, and Cases

Practice reading rows and columns to identify the cases, variables, and table size without mistaking a label or a repeated value for a new case.

Beginner 8 min read

What You'll Learn

  • Identify the case represented by each row in a data table.
  • Count cases by counting data rows, not the header row.
  • Identify variables from the information recorded in columns.
  • Distinguish an identifier from a variable describing a case.
  • Count cases and variables even when some entries are blank or repeated.
  • Check whether a table’s rows consistently represent the same kind of case.

Introduction: Reading a Table’s Structure

In Identifying the Observational Unit, you learned to ask what one row describes. In What Is a Variable in Statistics, you learned to identify the individuals and the variables recorded about them. A data table makes those ideas visible: each row usually represents one case, and each column usually records one kind of information about the cases.

This tutorial uses “case” for one individual or observational unit represented in the data. A case might be a student, a plant, a day, or an event, depending on the question. A variable is a characteristic recorded for each case. The entries inside the table are the values of those variables for particular cases.

A careful table reading begins with the title or description, then checks the row labels and column headings. Ask what one data row represents, which columns describe the cases, and how many data rows and variables are present. These checks help prevent a common error: counting headings, labels, or individual cells as though they were cases or variables.

Definition: In a typical data table, a case is represented by a data row, a variable is represented by a column that records a characteristic of the cases, and a value is an entry for one case on one variable. The header row names the columns; it is not itself a data case.

Rows, Columns, and the Header

The first task is to establish what one row represents. If every row describes one student, the cases are students. If the rows instead describe classrooms, then the cases are classrooms—even if the table includes a column giving the number of students in each classroom. Use the table’s description and the information in a row together; do not guess from a column heading alone.

Next, read the column headings. A heading such as “Weekly practice hours” names a variable, and the cells below it contain that variable’s values for the cases. A heading such as “Travel method” names another variable. As in Categorical Versus Quantitative Variables, the values can be categorical or quantitative; that classification does not change the basic row-and-column structure.

Some tables include a student number or code so that rows can be told apart. An identifier is useful for referring to a case, but it does not necessarily describe a characteristic we want to study. It is helpful to distinguish recorded columns from study variables: a table may have a column for an identifier as well as columns for the variables of interest. If a question asks how many columns are shown, count the identifier column. If it asks how many study variables are being examined, do not automatically count the identifier as one.

The header row also matters for counting. It tells you what each column means, but it is not an extra student, plant, or event. To count cases, count the data rows below the header. To count variables, identify the columns that record characteristics of those cases, keeping any identifier separate when appropriate.

Worked Example: An Eight-Student Study Table

A teacher records information for eight students who took part in a study-planning activity. The table includes a student code to distinguish the rows, along with three characteristics recorded for each student.

Student codeTravel methodPractice hours last weekConfidence rating
S01Bus3.5Good
S02Walk2.0Very good
S03Bike4.0Fair
S04Bus1.5Good
S05Car3.0Excellent
S06Walk2.5Fair
S07Bus5.0Very good
S08Bike2.0Good

Identify the cases: Each data row describes one student. The cases are the eight participating students, labeled S01 through S08. Counting the data rows gives 8 cases. The heading row is not a ninth case.

Identify the recorded columns: There are four column headings: Student code, Travel method, Practice hours last week, and Confidence rating. So the table displays four columns of information. One is an identifier, the student code; the other three record characteristics of the students.

Count the study variables: If the question is asking about characteristics being recorded for the study, there are three study variables: travel method, practice hours last week, and confidence rating. The student code helps identify each case, but the digits and letters in the code do not measure a student characteristic. In this table, we can therefore report both counts precisely: 8 cases and 3 study variables, plus 1 identifier column.

Read a value in context: The entry “3.5” in S01’s row and the Practice hours last week column means that student S01 recorded 3.5 practice hours last week. The value is not a separate case or variable; it is one student’s value on one variable.

Answer: The table contains eight student cases. It shows three study variables and a student-code identifier. Counting the header as a case or treating each cell as a variable would give the wrong description.

Count the Data Rows, Not the Distinct Answers

Two students may have the same value on a variable. That does not merge their rows or make them a single case. If three students all report “Bus,” there are still three student cases; “Bus” is simply a value that occurs three times in the Travel method column.

Likewise, the number of cases is not the number of different values in a column. A table of eight students may show only four distinct travel methods. It still has eight cases because it describes eight students. The number of distinct categories can be useful for summarizing a categorical variable, but it answers a different question from “How many cases are in the table?”

A quick structure check is to look down each column and across each row. Down a column, you should be reading values of the same variable. Across a row, you should be reading information about the same case. If that pattern is not clear, revisit the table title and headings before counting.

Worked Example: Counting Cases in a Garden Log

A community garden records a few details about six volunteers. Each row represents one volunteer. Read the table and identify the cases, the recorded variables, and the number of cases. Notice that “Watering” appears more than once.

Volunteer codeAssigned taskMinutes on task
V1Watering20
V2Weeding35
V3Watering15
V4Harvesting40
V5Watering25
V6Weeding30

Cases: Each row represents one volunteer, so the cases are the six volunteers. There are six data rows beneath the header, giving 6 cases.

Columns and variables: The table has three recorded columns. Volunteer code is an identifier; Assigned task and Minutes on task are the two variables describing the volunteers’ work. Thus, there are two study variables and one identifier column.

Repeated value: “Watering” appears in three rows, for V1, V3, and V5. Those are three different cases with the same value on Assigned task. Counting just the three task names that appear—Watering, Weeding, and Harvesting—would count distinct values, not cases.

Answer: There are 6 volunteer cases, 2 study variables, and 1 identifier column. Repeated task values do not change the number of cases.

When a Table Has a Blank Entry

A blank cell does not automatically remove its row from the table. If the row still represents a case, count it as a case even if one variable’s value was not recorded. The column heading still identifies a variable, even when one or more entries in that column are missing. Be clear about what was recorded and what was left blank rather than filling in an unstated value.

This is another reason to count the rows and columns separately. A missing entry affects what is known about one case on one variable; it does not, by itself, change how many cases the table represents or how many variables the table includes. If the table’s description says a row is incomplete or excluded, use that information when explaining the cases.

Worked Example: A Missing Entry in a Reading Log

A school club records the reading format and minutes spent reading for five students. One student has no minutes recorded. Each data row still corresponds to a student in the log.

Student codeReading formatMinutes reading
R1Print25
R2Audio40
R3Print
R4Digital30
R5Audio20

Cases: There are five data rows, R1 through R5. Since each row represents one student, the table contains 5 student cases. The blank cell for R3 does not make that student’s row disappear.

Variables: There are two study variables: Reading format and Minutes reading. Student code identifies the rows, so it is an identifier rather than a study variable. The table has three recorded columns in total.

Describe the blank accurately: R3 has a recorded value of Print for Reading format, but the Minutes reading entry is blank. We cannot state how many minutes R3 read from this table. We should not treat the blank as zero, because the table does not say that the student read for zero minutes.

Answer: The table represents 5 students and includes 2 study variables plus an identifier column. One value is missing, but the number of cases and the number of variables remain the same.

A Reliable Table-Reading Routine

Use a short, repeatable routine whenever you encounter a data table. It is useful in later work because a graph or summary is only meaningful if you know what the cases and variables are. This routine also helps you describe a data set precisely before calculating anything.

1
Read the title or description.
Find out what the table is about and what one row is intended to represent.
2
Name the cases.
State the kind of individual or observational unit in the data rows, such as students or volunteers.
3
Read the column headings.
Identify which columns record characteristics and whether any column is only an identifier.
4
Count rows and variables separately.
Count data rows for cases, excluding the header. Count study-variable columns, explaining separately whether an identifier is included.
5
Check entries and blanks.
Use a cell’s row and column to describe its meaning. Notice repeated values and blank entries without confusing them with cases or variables.

Common Mistakes and AP Exam Tips

  • Counting the header row as a case. Column names label the information below them. A full-credit response counts only the data rows as cases.
  • Calling a column a case. A column records a variable; the rows represent the cases in a typical case-by-variable table. State what one row describes to show you have identified the cases.
  • Counting repeated values as one case. Cases are counted by rows, not by the number of distinct answers. Different students remain different cases even when their recorded values match.
  • Counting an identifier as a study variable without explanation. A code can be a recorded column, but it usually serves to label or locate a case rather than describe a characteristic of interest. Distinguish total columns from study variables when the question could mean either.
  • Treating a blank as zero. A blank means that no value is shown, not that the value is zero. Report the missing entry without inventing a value.
  • Giving only a number without context. Instead of writing “8 and 3,” say “The table contains 8 student cases and 3 study variables, plus a student-code identifier.” That phrasing tells the reader what each count means.

On an AP response, precise wording matters even in a simple table-reading question. Name the cases, identify the variables, and make counts explicit. If there is an identifier or a blank entry, mention it so the reader can tell exactly what you counted.

Key takeaway: In a typical data table, rows represent cases and columns record variables. Count data rows—not the header or distinct repeated values—and distinguish study variables from an identifier column when describing how many of each are shown.

Check Your Understanding

For each question, use the table’s row and column structure to explain your answer.

  1. A table has one header row and 12 data rows, each describing a different house. How many cases does it contain, and what does one case represent?
  2. A table has columns for a participant code, favorite music genre, and minutes spent practicing. How many recorded columns are shown? How many study variables are shown if the code is used only to identify participants?
  3. Seven students are listed, and four of them have “Bus” in the Travel method column. How many student cases are there? What does the repeated value tell you?
  4. A five-row table describes five plants and has one blank entry in the Height column. How many cases and variables are represented if the table also has a Light condition column? Should the blank be read as a height of zero?
  5. Write one clear sentence describing a table with eight student rows, three study-variable columns, and one student-code column.