ISM assignment #2

ASSIGNMENT 2

Name of Team members:

Panther IDs

Total will be for 100 points (scaled to 700 points)

Please submit the Excel sheet in addition to the assignment word document when you submit it.

1) List the make and price of – 20 points

a. the most expensive foreign car and

b. most expensive domestic car.

c. Least expensive foreign car

d. Least expensive domestic car

2.a) Create a weighted score “WScore” column for each car as the following using formulae

i.e.:½ x Price + 100 x mpg + 1000 X trunkroom + weight - 20 points

b) Next create a new column called Rating = “WScore” divided by 4000 - 20 points

c) List the car with the highest rating - 20 points

d) List the car with the lowest rating – 20 points