Question

Case 4 trader is interested in finding an SUV car. With a limited budget, he does not mind A new getting a used one. Below is the summary of his criteria and the choices that he has selected as potential cars that he may purchase. Conduct TOPSIS in an Excel spreadsheet to determine the best car that he should purchase. What do the results suggest? Ratings Mercedes-Benz Маzda Kia Nissan Criteria Weight Sportage GL320 QASHQAI CX-3 Objective $24,990 $21,999 $28,540 $21,990 Price Min Odometer (km) 5 59,234 143,000 0 29,195 Min Fuel consumption (1/100km) 3 7.9 10 6.9 6.1 Min Fuel average distance (km) 5 785 1,000 942 787 Max CO2 emission (g/km) 2 182 264 159 146 Min Power-to-weight ratio (W/kg) 7 73.1 69.4 79.5 90.8 Мах Build year 5 2017 2007 2018 2015 Маx Fuel cost per fill $147 $81 $60 6 $78 Min

Answer 1

For the given example we have to use the Wilcoxon rank sum test. For this test we are given,

Sum of ranks for first sample = W(-) = 192.5

Sum of ranks for second sample = W(+) = 132.5

The test statistic T1 is given as below:

T1 = Max [W(-), W(+)]

T1 = Max [192.5, 132.5]

T1 = 192.5