Show the work through excel!!

Show the work through excel!!

4. First City Real Estate executives wish to build a model to predict sales prices for residential properties. Such a model will be valuable when collaborating with potential sellers who might list their homes with First City. The company has provided the following data: The price of the property depends on square footage, the age of the property, the number of bedrooms, the number of garages, and the area (foothills =1, and o otherwise). A. Develop the multiple regression model to predict property prices. B. At a 5% level of significance, is the overall model significant? C. Is each of the independent variables statistically significant in explaining property prices? D. Formulate the null and alternative hypotheses. E. State whether you would reject the null hypothesis. F. Interpret the slope coefficients. G. Interpret the intercept. H. Determine the price of a property with the following characteristics: 2,10o square feet, 15 years old, 4 bedrooms, 2 garages, and not located at the foothills. I. What percentage of the variability in property prices is accounted for in the model