From that data we can conclude that ‘if a motorbike was in an accident, then it is more likely to be serious than ones containing cars’. However, we could not conclude that motorbikes were more likely to be in accidents in general than cars, since this would require us to know how many motorbikes and cars were on the road’.
Similarly, we could not conclude france phone number list that Fords and Vauxhalls (the two makes which were involved in the most accidents) were more dangerous than say Bentleys or Kawasaki motorbikes.
They were involved in a much larger number of accidents but there are obviously more of them on the road.
To do this type of analysis we would need to be able to compare the number of accidents involving a vehicle of type X with the number of vehicles of type X that were on the road.
For our traffic accident data, we only have the make and model information of the vehicles that were involved up until 2014, so we shall use that year as our example.
The data in the MOT system (5) has details on all of the MOTs that took place in a given year, together with some information about each of the vehicles. From this we can get a good idea of the number of cars of each make that are on the road in a given year, with the results easily obtainable in a cube as shown below.
We can then output this cube as a tab-delimited file using the Output wizard, and copy this file so that it is accessible to the accident system.
Fortunately, the variable values of the ‘Make’ in the MOT system and the ‘Vehicle Make’ in the accident system are the same so we can look up the value from the data file above in the traffic accident system.
Cube vehicles with test in 2014
-
- Posts: 10
- Joined: Sun Dec 22, 2024 8:53 am