Data Insights: Table Analysis Flashcards

A table reports a 'percent change' column for revenue. A value of -12% in a row means:

Answer: That row's revenue decreased by 12% relative to the prior period

A negative percent change indicates a decline of that magnitude from the base.

To test 'the company with the largest market share also had the largest profit,' you must:

Answer: Find the row with the maximum market share and confirm it also holds the maximum profit

Both maxima must coincide in the same single row for the statement to be true.

When a table contains a 'rank' column, sorting by rank ascending will:

Answer: Order rows from rank 1 to the lowest rank

Ascending sort by rank lists the top-ranked item first.

A statement claims 'the ratio of column A to column B is greater than 2 for every row.' To verify, you:

Answer: Check each row to ensure A divided by B exceeds 2

A 'for every row' claim requires confirming the ratio condition in all rows.

If a column of values appears already sorted in the original table, the safest assumption is:

Answer: It may have been sorted for presentation, but you should still verify before relying on order

Apparent order should be confirmed, since only one column can be sorted at a time.

A table gives total units and total revenue per product. Average price per unit for a product is found by:

Answer: Dividing that product's revenue by its units

Average unit price equals revenue divided by quantity sold.

Why might a statement be 'False' even though part of it matches the table?

Answer: A compound statement is only true if all of its conditions hold

If any condition in a combined claim fails, the whole statement is false.