Determinants of Residential Property value in Las Vegas-

The Greater Las Vegas Association of Realtors® (GLVAR) is interested in analyzing the determinants of residential property values in the Las Vegas (NV) housing market. The data set is based on the residential properties of the city of Las Vegas. Residential property values (PRICE) are explained by a number of factors. The relationship between price and these factors is written as:

PRICE                 =f(SQFT, BED, BATH, AGE, POOL, FORECLOS, DOM)

PRICE                = Sale price of residential property
SQFT                  = Square feet, measuring the size of living space
BED                   = Number of bedrooms
BATH                 = Number of bathrooms
AGE                   = Year of the residential property
POOL                 = 1 if the property has a pool or a spa and 0 if not.
DOM                  = Days the property was on the market for sales
FORECLOS         = 1 if property is a foreclosed property and 0 if not

Part I: Characteristics of residential properties

1. Construct a table that includes the summary statistics (mean, standard deviation, minimum and maximum) of all the variables. Explain briefly your findings.

2. Compute the matrix of correlation coefficients for the variables PRICE, SQFT, BED, BATH, AGE, POOL, FORECLOS, and DOM. Analyze the direction and strength of the relationship of the right-hand side variables (SQFT, BED, BATH, AGE, POOL, FORECLOS, and DOM) on PRICE.

3. Show the scatter plots of the relationships between (i) PRICE and SQFT, (ii) PRICE and BED, (iii) PRICE and BATH, (iii) PRICE and AGE and (iv) PRICE and DOM (Use PRICE as the variable on the vertical axis in each plot). Explain your findings. Are the results of the plots consistent with the correlation results in (2)? Explain.

Part II: Comparing characteristics of foreclosed and non-foreclosed home

The variable FORECLOS accounts for the recent bad housing market conditions in Las Vegas. Is there a difference in values between foreclosed and non-foreclosed residential properties? Compute the average difference in values of the two types of properties. Explain your findings. Are your findings consistent with intuition? Explain.

Table: Descriptive Statistics (Average Values)

Variables                    Foreclosed                  Non-foreclosed                      Difference                             

PRICE

SQFT

BED

BATH

AGE

POOL

DOM                          

Part III: Policy recommendation

The Greater Las Vegas Association of Realtors (GLVAR) likes your study and requests that you draft a useful policy for the Association with regard to housing market in Las Vegas Metropolitan area. Your recommendation should be based essentially on the data and results of this project.

Attachment:- Housing 2013 Data.rar