ASSIGNMENT
Panther IDs
Submit the Excel sheet in addition to the assignment word document when you submit it.
1) List the make and price of.
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.
b) Next create a new column called Rating = "WScore" divided by 4000.
c) List the car with the highest rating.
d) List the car with the lowest rating.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.
Attachment:- Autos.rar