Large Data Set

Question 1

In order to clean the data, you would have to ___________ ?

Answer 1

Remove all car’s with mass “0”

Question 2

How many registered makes of car are there?

Answer 2

5

Question 3

Name the regions the owners live in

Answer 3

• London
• North West
• South West

Question 4

2 years of manufacture that are considered

Answer 4

2002 and 2016 (emissions scandal happened between these years)

Question 5

5 propulsion types

Answer 5

1. Petrol
2. Diesel
3. Electric
4. Gas/petrol
5. Electric/petrol

Question 6

5 keeper titles

Answer 6

1. Male
2. Female
3. (Not used)
4. Unknown (Rev, Dr etc)
5. Company

Question 7

Units for engine size

Answer 7

cubic cm

Question 8

Units for mass

Answer 8

kg (includes 75kg mass of average driver)

Question 9

Gas emissions units

Answer 9

g/km

Question 10

5 emissions considered

Answer 10

1. Carbon dioxide
2. Carbon monoxide
3. Oxides of nitrogen (NO and NO2)
4. Particulates
5. Hydrocarbons

Question 11

Which cars have values for particulate emissions?

Answer 11

Only diesel vehicles

Question 12

What is the most common body type of car?

Answer 12

5 door hatchback

Question 13

What is the least common body type of car?

Answer 13

2 door saloon

Question 14

What is the least common make of car?

Answer 14

Toyota

Question 15

What is the most common make of car?

Answer 15

Ford (closely followed by Vauxhall)

Question 16

2 limitations of the LDS for comparing emissions in 2002 to 2016 in England

Answer 16

• Not all makes of car are included in the database
• Not all English regions are included

Question 17

Which emissions are known for every car in the data set?

Answer 17

None of them

Question 18

5 makes of car

Answer 18

1. BMW
2. Ford
3. Toyota
4. Vauxhall
5. Volkswagen

Question 19

Which types (e.g. petrol) of car are the least common?

Answer 19

Electric and gas/petrol (only 1 of each)

Question 20

Which keeper title ID isn’t used in the data set?

Answer 20

3