A3.2 Count Responses and Purchases

After entering the data, we confirmed that all of the respondents answered each item of the survey. To do this, we highlighted A153:BI153 and entered “=COUNT(A2:BI151)” to make sure there were 150 responses for each item. We clicked on C154 and entered “=SUM(C2:C151)” to count the number of two-passenger models, while we clicked on D154 and entered “=SUM(D2:D151)” to count the number of three-passenger models.

Data is missing if a column's count is less than the size of the sample.

Get Top Market Strategy now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.