Data Insights: Table Analysis Flashcards

A table lists employees with salary and years of service. To test 'the highest-paid employee also has the most years of service,' you should:

Answer: Sort by salary to find the top earner, then check that person's service years against the maximum

Identify the top earner, then verify their service equals the column maximum.

A statement says 'no product had both high price and high return rate.' How is this best checked?

Answer: Sort by price, then within high-priced products confirm none also have high return rates

Filter to high-price rows and confirm the second condition fails for all of them.

When a table column can be sorted ascending or descending, the range of that column is found by:

Answer: Subtracting the smallest value from the largest value

Range equals maximum minus minimum, both visible at the sorted ends.

A claim states 'at least one country exceeds the average GDP shown.' Is this necessarily true?

Answer: Yes, unless all values are identical, some value must be above the mean

Unless every value is equal, at least one value lies above the average.

To evaluate 'fewer than 25% of items are out of stock,' you would:

Answer: Count out-of-stock items and compare to one-quarter of the total items

Compare the qualifying count against 25% of the row total.

A table shows monthly sales for several stores. To determine which store had the most consistent sales, you would look for:

Answer: The store whose monthly values vary the least (smallest spread)

Consistency means low variability, so the smallest spread of values wins.

If two statements in a question can be evaluated independently, you should:

Answer: Judge each one separately using only the relevant table data

Each statement is scored on its own and may have a different verdict.