Problem statement

An automobile company aspires to enter the US market by setting up their manufacturing unit there and producing cars locally to give competition to their us and curopean counterparts.

They have contracted an automobile consulting company to understand the factors on which the pricing of cars depends. Specifically, they want to

understand the factors atrecting the pricing of cars in the American market, since those may be very different from other markets. The company wants to knOw

Which variables are significant in predicting the price

How well those variables descmoe the price of a car

based on various market survevs. the consulting Tirm has gathered a large dataset of different types of cars across the American market.

Business Goal:

You are required to model the price of cars with the available independent variables. It will be used by the management to understand how exactly the prices

vary with the independent variables. They can accordingly manipulate the design of the cars, the business stratedy etc. to meet certain price levels.

Further, the model will be a good way for management to understand the pricing dynamics of a

new market

Questions (100 points):

What is T (Task). E (Experience). P (Performance) for this specitic problem?

2. What is the size of the training data? How many teatures do we have.

a. Training data size as 206 (206 mes in the excel

file)

b. The number of leatures 1s 26 (26 columns in the excel ties

Prepare a Junvter nython notebook to explore the given

Use the scikit-learn nackage to use the proper machine

learning model for your analysis. Specifically:

1. Model the relationship between car price and horsepower using linear regression.
2. Model the relationship between car price and citvmang using linear regression.

price? How did vou reach that conclusion?

d. Prepare a brier power point presentation which contains the following:

1. Title slide which has the prolect name. your name, vour university department. and date

A slide explaining the problem

A she explaining the goals or aims of the

1V. A slide answermng auestions I and 2 above

V. A slide highlighting the methods you used

Vi. A Slide with vour main conclUsions With

metrics supporans your conclusions

VIl. A Tuture work slide and any obstacles vou

faced during the project such as data pre-processing. data qualitv, data size

VIlI

Convert vour Dot to bot and name it as:

LastName_FirstName_CarPriceProject.pdf

vou can email me at

osamahmalkawi.inbox@gmial.com to send vou the excel file for the data, I am unable to upload an excel The nere. please neip me because the due date is in three hours