Question

Table 14 Average rate of fuel consumption, by year of manufacture by type of vehicle by type of fuel
	Petrol	Petrol - RSE	Diesel	Diesel - RSE	LPG/CNG/dual fuel/hybrid and other	LPG/CNG/dual fuel/hybrid and other - RSE	Total	Total - RSE
	l/100 km	%	l/100 km	%	l/100 km	%	l/100 km	%
2000 and earlier
Passenger vehicles	10.9	2.64	12.2	8.93	16.0	24.49	11.4	2.98
Motor cycles	6.0	6.91	0.0	0.00	0.0	0.00	6.0	6.91
Light commercial vehicles	13.3	3.43	11.9	4.12	15.6	7.94	13.0	2.55
Rigid trucks	35.3	17.55	26.0	4.04	63.0	38.06	26.3	3.96
Articulated trucks	30.4	100.00	53.7	1.91	0.0	0.00	53.7	1.91
Non-freight carrying trucks	16.4	12.14	34.8	15.17	19.3	11.20	34.3	14.95
Buses	14.3	3.63	29.7	4.51	60.0	29.63	29.1	4.48
Total	11.2	2.34	20.4	5.01	16.2	14.77	13.6	2.20
2001 to 2010
Passenger vehicles	10.7	1.80	9.4	6.23	9.8	10.53	10.6	1.71
Motor cycles	5.7	4.05	0.0	0.00	0.0	0.00	5.7	4.05
Light commercial vehicles	13.4	2.97	11.3	1.62	14.2	4.25	12.3	1.55
Rigid trucks	15.8	25.63	27.2	2.76	24.8	13.57	27.2	2.75
Articulated trucks	0.0	0.00	55.6	0.89	64.0	21.59	55.7	0.88
Non-freight carrying trucks	15.0	11.66	38.7	10.23	0.0	0.00	38.2	10.15
Buses	14.7	5.18	28.5	4.31	43.1	16.38	29.7	3.97
Total	10.9	1.64	19.0	3.22	12.0	8.41	13.0	1.25
2011 and after
Passenger vehicles	10.4	2.30	10.1	3.39	10.0	8.74	10.3	1.89
Motor cycles	5.5	3.63	0.0	0.00	0.0	0.00	5.5	3.63
Light commercial vehicles	12.6	4.79	11.1	1.99	13.0	19.52	11.3	1.92
Rigid trucks	0.0	0.00	30.5	4.12	14.6	8.63	30.5	4.12
Articulated trucks	0.0	0.00	57.4	0.87	0.0	0.00	57.4	0.87
Non-freight carrying trucks	16.0	100.00	15.8	12.15	0.0	0.00	15.8	12.05
Buses	17.2	12.22	26.8	5.03	20.0	3.18	25.1	4.38
Total	10.4	2.21	16.8	2.65	10.8	8.25	13.1	1.33
All years
Passenger vehicles	10.6	1.23	10.0	3.02	11.1	8.14	10.6	1.10
Motor cycles	5.6	2.48	0.0	0.00	0.0	0.00	5.6	2.48
Light commercial vehicles	13.2	2.10	11.2	1.27	14.5	3.55	12.0	1.06
Rigid trucks	29.5	22.74	28.0	1.99	44.7	39.25	28.0	1.97
Articulated trucks	30.4	100.00	56.3	0.60	64.0	21.59	56.3	0.60
Non-freight carrying trucks	15.5	7.10	25.8	10.59	19.3	11.20	25.6	10.44
Buses	15.9	7.61	28.0	2.58	35.0	13.41	27.8	2.30
Total	10.8	1.14	18.0	1.93	12.6	6.14	13.1	0.80

I JUST WANT TO IDENTIFY THE PROBLEMS IN THE ABOVE DATA. THANKS

Answer 1

The problems which are identified from the data are as follows:

1. Although the LPG consumption was more among all the vehicles but over the years it was in decreasing trend. So, it means that the eco-friendlier vehicles and fuels are not used over the years.
2. The usage of personal vehicles increases over the years but the use of LPG in the personal vehicles are not used.
3. Diesel fuel is more popular among the vehicles and hence the environmental pollution becomes major problem over the years.
4. The passenger vehicles prefer all the fuels which creates the financial and pollution problem to the country wide.
5. The data is not well manged for the quick analysis.
6. It is the tedious process to predict the results.