In the dataset, how many Petrol cars are there (PropulsionTypeID 1)?

In the dataset, how many Petrol cars are there (PropulsionTypeID 1)?

• A. About 2400
• B. About 1400
• C. About 120
• D. About 3000

Answer: (A)

The question tests how to identify a specific category in a dataset and count how many records belong to it. Petrol cars are labeled with PropulsionTypeID equal to 1. To determine how many there are, filter the data to only those rows where PropulsionTypeID is 1, then count them. Doing this yields about 2400, so there are roughly two and a half thousand Petrol cars in this dataset. You can verify with a simple filter-and-count in a spreadsheet or a COUNT query in a database.

The question tests how to identify a specific category in a dataset and count how many records belong to it. Petrol cars are labeled with PropulsionTypeID equal to 1. To determine how many there are, filter the data to only those rows where PropulsionTypeID is 1, then count them. Doing this yields about 2400, so there are roughly two and a half thousand Petrol cars in this dataset. You can verify with a simple filter-and-count in a spreadsheet or a COUNT query in a database.