Question 2:
In the file “Data_PCA_project.xlsx” you will find survey data below on 10 cars in
terms of 6 attributes. The higher the score in a particular attribute the better the car
in terms of that attribute. Analyze the car data using a principle component
analysis? How many principle components will you retain and why? What is the
interpretation of the principle components that you retain? What conclusions can
you draw from the principle component analysis regarding these cars and the
survey data at hand?
Luxurious Safe Sporty For Family Practical Exciting
BMW 4 3 5 2 2 4
Ford 2 3 2 4 5 2
Infinity 4 3 3 3 3 2
Jeep 3 3 2 4 4 3
Lexus 5 4 3 3 3 3
Chrysler 1 3 1 5 5 1
Mercedes 5 4 3 3 2 2
Saab 3 4 4 3 3 4
Porsche 4 2 5 1 1 5
Volvo 2 5 1 5 4 1