AQA Large Data Set

3 Regions included in the LDS

- London

- North West

- South West

What are the car makes included in the LDS?

- BMW

- Ford

- Vauxhall

- Volkswagen

- Toyota

(These were the most frequently registered makes)

In what years was the LDS recorded?

2002 and 2016

What are the cautions about using conclusions from the LDS?

Only 5 car makes from 3 regions of the UK.

What were the least popular makes in each year?

Least popular in 2016 - Toyota (Also least popular overall)

Least popular in 2002 - BMW

What were the most popular makes in each year?

Most popular in 2016 - Vauxhall

Most popular in 2002 - Ford

Which car make had the biggest increase in popularity from 2002 to 2016? And which was the only car make that had a decrease?

Biggest increase - Vauxhall

Only decrease - Toyota (1 less)

What were the main changes between 2002 and 2016

- Far more were registered in 2016 than 2002.

- On average, all emissions and engine size (except Toyota) have decreased but all cars became heavier (except for Vauxhall, for which the mean average mass decreases significantly in 2016).

- Larger proportion in diesel cars in 2016 and more company cars.

How many 0kg entries were there in each year?

2002 - 92

2016 - 0

What is the average car mass (ignoring 0kg entries)?

1404kg

What was the heaviest single car

a 2002 Vauxhall (2450kg)

What was the lightest single car?

a 2016 Toyota (925kg)

Why was the Vauxhall car masses more varied than the others?

Mostly due to the fact that of the 5 makes is on average the LIGHTEST IN 2016 (BMW heaviest in 2016), but the HEAVIEST IN 2002 (Data cleaned - Ford lightest in 2002, Not c leaned - Toyota).

Which car on average has the much larger engine size of the 5 makes?

BMW had the much larger engine size.

(Suggesting people who are interested in BMWs may be biased towards large engine sizes).

Which car on average has the smallest engine size of the 5 makes?

Vauxhall had the smallest engine size.

Which car make had an increase in engine size between 2002 and 2016.

Toyota had an increase in engine size.

How many 0 entries are there for engine size?

1

the 1 propulsion type-3 car (2016, BMW)

How many PropulsionTypeID 1 (Petrol) cars are there in the LDS?

About 2400 (Most)

How many PropulsionTypeID 2 (Diesel) cars are there in the LDS?

About 1400 (2nd Most)

How many PropulsionTypeID 8 (Electric/Petrol) cars are there in the LDS?

About 120 (3rd Most)

Why is there only one of each of PropulsionTypeID 3 (Electric) and 7 (Gas/Petrol)?

They are likely mislabelled and should have been put in the categories electric/petrol (3) and petrol (7).

Which cars makes have no electric/petrol cars in 2016?

Ford and Vauxhall despite being the most popular.

What is the order of the mass of fuels, heaviest to lightest?

Electric petrol (Type 8), Diesel (Type 2), Petrol (Type 1)

What fuels release the most CO and CO2 emissions, most to least.

Petrol (Type 1), Diesel (Type 2), Electric-Petrol (Type 8)

What PropulsionTypeID has no 0kg entries.

Type 8. All the 0kgs appear for Type 1 and Type 2 Cars.

Keeper Title ID 1

Male

(BMW seem more popular with males than females in both years)

Keeper Title ID 2

Female

Keeper Title ID 3

(Not used)

Keeper Title ID 4

Unknown (e.g. Rev, Dr etc.)

Keeper Title ID 5

Company

Propulsion Type ID 1

Petrol

Propulsion Type ID 2

Diesel

Propulsion Type ID 3

Electric

Propulsion Type ID 7

Gas/Petrol

Propulsion Type ID 8

Electric/Petrol

Body Type ID 1

2 door saloon

(only two, both Volkswagen)

Body Type ID 2

4 door saloon

Body Type ID 3

Saloon

(only in 2002)

Body Type ID 4

Convertible

(mostly BMWs)

Body Type ID 5

Coupe

(mostly BMWs)

Body Type ID 6

Estate

Body Type ID 13

3 door hatchback

Body Type ID 4

5 door hatchback

Body Type ID 96

Multipurpose vehicle

Reference number

Reference number to index the data (from AQA)

Make

Only 5 of car makes are included in the data base

Propulsion Type ID

A code for the type of fuel used

Body Type ID

A code for the type of car

GovRegion

English region of the current registered user - derived from postcode data.

Keeper Title ID

A code to show the current registered keeper's gender derived from DVLA data giving the keeper's title.

Engine size

Engine capacity in cubic cm

Year Registered

The year in which the vehicle was first registered

Mass

Mass of the vehicle in kg, including the mass (75kg) of the average driver

(Mean 1369.793kg)

CO2

Carbon dioxide emissions from the vehicle g/km.

(Mean 137.629g/km)

(Known for 83% of cars in the whole database)

CO

Carbon monoxide emissions g/km

(Mean 0.346g/km)

(Known for 82% of cars in the whole database)

NOX

Oxides of nitrogen emissions g/km

(Mean 0.063g/km)

(Known for 81% of cars in the whole database)

part

Particulate emissions g/km

(Mean 0.019g/km)

(Only for diesel vehicles; 24% of all cars in the whole database)

(Only four different values in 2016, but a lot more varied in 2002 (enormous outliers))

hc

Hydrocarbon emissions g/km

(Mean 0.053)

(Known for 51% of cars in the whole database)

Why are there blank entries of emission data mean in the LDS?

Emission data was not available for all cars.