这是一个英国的Excel汽车排放数据统计建模分析作业代写，需要生成报告
In 2015 Volkswagen (VW) made the news for all the wrong reasons when they were caught ‘cheating’ the emissions test for their diesel-engine vehicles. To date, the scandal has cost VW more than £25 billion in fines, recalls and production costs.
A supplied datafile by the Vehicle Certification Agency (VCA) provides fuel efficiency and emissions data for over 28,000 vehicles, from 53 manufacturers, from 2015 to 2020.
1. How many Volkswagen vehicles1 have been tested by the VCA?
2. How many Volkswagen C.V. (commercial vehicles) have been tested?
3. How many Volkswagen diesel2 vehicles have been tested?
4. How many vehicles are electric3 vehicles?
5. How many vehicles are diesel-electric hybrids4?
6. How many vehicles are petrol-electric hybrids5?
7. How many Volkswagen vehicles are electric3 vehicles?
8. How many Volkswagen vehicles are diesel-electric hybrids4?
9. How many Volkswagen vehicles are petrol-electric hybrids5?
10. Which year saw the most diesel2 vehicles tested?
11. How many vehicles have a valid6 MPG value?
12. What is the average MPG value7 for Volkswagen vehicles (all fuels), using valid6 data?
13. What is the average MPG value7 for diesel2 Volkswagen vehicles, using valid6 data?
14. How many vehicles do not have a valid6 dB(A) value?
15. How many diesel vehicles do not have a valid6 dB(A) value?
16. Excluding electric-only vehicles, which type of fuel has the lowest CO2 g/km, on average, using valid6 data?
17. Which manufacturer has the highest average CO2 g/km (all fuels), using valid6 data, and what is the value7?
18. Which manufacturer has the highest average CO2 g/km for diesel2 vehicles, using valid6 data, and what’s the value7?
19. Which individual vehicle8 has the highest CO2 g/km?
20. Which individual diesel2 vehicle8 has the highest CO2 g/km?
The number of gears in the transmission of the vehicle is given as a number in the transmission code.
For example, “M5” means the vehicle has 5 gears, “A6” means it has 6 gears, and so on.
21. What is the average7 CO2 g/km for vehicles with 5 gears, using valid6 data?
22. What is the average7 CO2 g/km for vehicles with more than 5 gears, using valid6 data?
23. How many vehicles do not have a number of gears listed in their transmission code?
24. What is the average7 CO2 g/km for the vehicles in task 23, using valid6 data?
