Question: H9 X V fx A B C D E F G H Percent Manufacturer Model Sales (March Sales (March change in 2011) 2010) sales from



H9 X V fx A B C D E F G H Percent Manufacturer Model Sales (March Sales (March change in 2011) 2010) sales from 2010 Honda Accord 33,616 29, 120 15.44% Nissan Altima 32,289 24,649 31.00% Toyota Camry 31,464 36,251 -13.21% Honda Civic 31,213 22,463 38.95% Toyota Corolla/Matrix 30,234 29,623 2.06% Ford Fusion 27,566 22,773 21.05% Hyundai Sonata 22,894 18,935 20.91% Hyundai Elantra 19,255 8,225 134.10% Toyota Prius 18,605 11,786 57.86% Chevrolet Cruze/Cobalt 18, 101 10,316 75.47% Chevrolet Impala 18,063 15,594 15.83% Nissan Sentra 17,851 8,721 104.69% Ford Focus 17, 178 19,500 -11.91% Volkswagen Jetta 16,969 9, 196 84.53% Chevrolet Malibu 15,551 17,750 -12.39% Mazda 3 12,467 11,353 9.81% Nissan Versa 11,075 13,811 -19.81% Subaru Outback 10,498 7,619 37.79% Kia Soul 10,028 5, 106 96.40% Ford Fiesta 9,787 0Question 2 1 pts In the dataset presented in Question 1, In Column H, we want to make a new variable: "Compared with Impala'I This Variable compares the sales volumes of all cars in March 2010 with the sales volume of \"Chevrolet Impala sales volume in March 2010". In case each car's sales volume in March 2010 is less than Impala's sales in March 2011, it prints "Less," and else, it prints "More." We have sorted the dataset Descending based on March 2011 sales and, Chevrolet Impala sales volume in March 2010 is now in the cell: C12 We type the following formula in the cell "H2," and we drag it down so that the formula applies to the cells below. What should replace the *** in the formula? =IF{-,"Less"."More") Q D2>C12 Q $D$2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
