2016 Automobile Quality Brand Reported Defects/100 vehicles Country of Origin Rank Acura 122 Japan 25 Audi 110 Germany 15 BMW 94 Germany 5 Buick 96 United States 7 Cadillac 112 United States 17 Chevrolet 95 United States 6 Chrysler 115 United States 20 Dodge 117 United States 22 Fia 174 Italy 32 Ford 102 United States 11 GMC 103 United States 12 Honda 119 Japan 24 Hyundai 92 Korea 3 Infiniti 103 Japan 13 Jaguar 127 United Kingdom 27 Jeep 113 United States 18 Kia 83 Korea 1 Land Rover 132 United Kingdom 30 Lexus 96 Japan 8 Lincoln 96 United States 9 Mazda 127 Japan 28 Mercedes-Benz 111 Germany 16 Mini 127 United Kingdom 29 Mitsubishi 116 Japan 21 Nissan 101 Japan 10 Porsche 84 Germany 2 Ram 114 United States 19 Scion 123 United States 26 Smart 216 Germany 33 Subaru 118 Japan 23 Toyota 93 Japan 4 Volkswagen 104 Germany 14 Volvo 152 Sweden 312-9) In the Excel le Automobile Quality, search for and add a new column for the country of origin for each brand. Then sort the data from the lowest to highest by number of problems per 100 vehicles using the sort capability in Excel. What conclusions can you reach