please help

A Realtor is interested in modeling the selling price ofhouses based on the square footage (X1), the age ofthe house (X1) and the number ofhedrooms (X3). The data was collected in the two largest cities in Arkansas and is given in an excel le. 1. a} Write down your rst order regression model with no interaction terms. h} Obtain the M output for this model and ll in the ANDVA table below. (Round to the nearest whole number: except F, which you should round to 2 decimal places: and don't use commas) c) Test ifthis model is useful. 2. a) Write down your complete second order regression model with all interaction (there should he 4 interaction terms). {This question won't be in the submission link, but you need to lcuow how to do it] b} Obtain the 1M? output for this model and ll in the ANDVA table below. (Round to the nearest whole number: except F, which you should round to 2 decimal places: and don't use commas) c) Test if this model is useful. d) Now test if the squared terms and interaction terms are significant to the regression model, when taken together, by conducting the partial F-test. Note that the model in problem 1 is the reduced model and the model in problem 2 is the full model. (This will be multiple questions in the submission link) 3. Now using the appropriate model (from your partial F test), write down the prediction equation. Then predict the selling price of a house that has 720 square feet, is 54 years old, and has 4 bedrooms. What is the residual? (both to 1 decimal place)\f