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.