A brand manager in a consumer food products organization suspected that several days of the point-of-sale data on the spreadsheet from one grocery chain were missing. The best approach for detecting missing rows in spreadsheet data would be to:
A) Sort on product identification code and identify missing product identification codes.
B) Review store identification code and identify missing product identification codes.
C) Compare product identification codes for consecutive periods.
D) Compare product identification codes by store for consecutive periods.

Question

Quizplus · Accepted Answer

Comparing product identification codes by store for consecutive periods allows the manager to identify any missing data specific to each store over time, which is crucial for detecting missing rows in the dataset.

A Brand Manager in a Consumer Food Products Organization Suspected