Solve using Python - Jypiter note book

Construction.xlsx data below:

5. Finding a regression model. 20 points A cost estimation for a construction company has collected the data found in the file Construction.xlxsx describing the total cost (Y) of 97 different projects and the following five independent variables thought to exert relative influence on the total cost: regular or premium wages paid (X1), total units of work required (X2), constructed units of work per day (X3), level of equipment required (X4), city/location of word (X5). The cost estimator would like to develop a regression model to predicts the total cos of a project as a function of these five independent variables. a) Prepare five scatter plots showing the relation of the independent variables and dependent variables. b) Which independent variables would you consider in your regression model? Create a regression model. c) Create a regression model based on X2 and X5. Then compare this regression model with the one you created in the section b. Wage - Regular (0) or Premium Units of Contracted Units Level of Equipment 00100162602505078364322133522226666667591086280255455864808524045256