I need this work to be done.The file BostonHousing.xls contains Housing data for 506 census tracts of Boston from the 1970 census. Following is the description of each variable in the file:The original data are 506 observations on 14 variables, medv being the target variable:CRIM per capita crime rate by townZN proportion of residential land zoned for lots over 25,000 sq.ftINDUS proportion of non-retail business acres per townCHAS Charles River dummy variable (= 1 if tract bounds river; 0 otherwise)NOX nitric oxides concentration (parts per 10 million)RM average number of rooms per dwellingAGE proportion of owner-occupied units built prior to 1940DIS weighted distances to five Boston employment centresRAD index of accessibility to radial highwaysTAX full-value property-tax rate per USD 10,000PTRATIO pupil-teacher ratio by townB 1000(B – 0.63)^2 where B is the proportion of blacks by townLSTAT percentage of lower status of the populationMEDV median value of owner-occupied homes in USD 1000’sCAT. MEDV categorical data for high (1) and low(0) median home prices.Answer the following questions using SPSS Modeler:1. Partition data in BostonHousing.xls into training (400 records) and test(106 records)).2. Fit a multiple regression model to the median home price (MEDV) using CRIM, CHAS, and RM and evaluate the model based on reported statistics.3. Write the equation for predicting the median home price and predict the median price for a home with CRIM=0.325 CHAS=1 , and RM=6.54. Fit a logistic regression using CAT.MEDV as your target (output) variable using the same predictor variables. Compare the reported statistics with statistics reported by multiple linear regression.