data analytics question and need the explanation and answer to help me learn.

I need help with Excel Auto analysis
Requirements: good
Project Description:
Community Auto Sales is considering opening a new location on the east side of town. They need to determine the types of vehicles that they would like to have on the lot for sale. They have acquired a sample data set of vehicle features and estimated MSRP (manufacturer’s suggested retail price) and need your help in setting up some analysis so that they can explore their options.
Steps to Perform: