A Google Sheet lists provinces down column A and has January, February and March as columns B, C and D, with an amount in each cell. In the terms of this lesson the sheet has:

Answer

One variable, amount, smeared across three columns named by month

Options - A. One variable, amount, smeared across three columns named by month - B. Three separate variables, one for each month of the quarter, plus the province - C. A tidy layout, since every province has its own row - D. A pivot table, since months across the top summarise the data Why - A. Correct — every cell is an amount; the month is hidden in the column name. Unpivot it into (prov, month, amount) rows before any tool touches it. - B. The three columns hold the same kind of value. If they were different variables, adding a fourth month would not mean adding a column. - C. One row per province is not enough; each row holds three observations, so the record is not the row. - D. A pivot is a summary you build from tidy input; this sheet is data stored in a summary-like shape, which is the problem.