Use The Residential Real Estate Properties data set.

This database contains the following variables.

Link for excel: https://liveconcordia-my.sharepoint.com/:x:/g/personal/a_attist_live_concordia_ca/EaEDNN0-yNZOlIQvp0ErJugBUyTJ-vgj52fkXjrOc8bl9Q?e=5KqTiT

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 ofresidential properties within their zone. It is required to write the results of the following three case questions in to your final report.

1. REC wants to test a hypothesize 50% of the houses are not coming with Garage(s). Run a statistical test use ? =0.05 significance level and state your conclusion.Set up a 95% confidence interval for the proportion of the houses without Garage.Based on the confidence interval does REC's claim seem unusual?

2.A competitor company claims that the average area of the listed properties

By REC is less than 3000 Sq Feet, run a statistical test using ? = 0.01,

and state you conclusion.

3. Perform a multiple regression analysis to show a mathematical

model to forecast the listing Prices , using following independent variables ;

Age

Size

Number of Rooms (Ground Floor)

Location Rating

Garages.

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.

.

4.The REC claims that large properties have better chance to come with a Garage.To test this claim, first classify properties into Small, Medium and Large sizes using.

Small Size Property

2600

Large Size Property > 2900 Sq F.

Show your conclusion in the context of the problem using an appropriate statistical test at ? =0.05.

\f