Use The Residential Real Estate Properties data set.

This database contains the following variables.

Age in Years

Price in $10,000S

Size in Square Feet

Number of Rooms (Ground floor)

Location Rating; High =7, Low=1

Garages; Yes=1 and No=-0

A Real Estate Company - REC, has hired your team as a consultant group to study; trends, research, data and insights on housing market using statistical methods.

They want you to come up with a forecasting model to predict the listprice of residential properties within their zone. It is required to write the results of the following three case questions in to your final report.

Perform a multiple regression analysis to show a mathematical

model to forecast the listing Prices , using following independent variable

-Number of Rooms (Ground Floor)

a) Is overall model statistically significant? Use significant level of 1%.

b) Using a significant level of 5%, which variable (s) is (are) insignificant.

c) REC wants your team to show in your final/cleaned recommended model,

the Listing Price of a. 5 years old property with 3000Sq F area, 3 Rooms with a Garage and in the location Rating 6.